News in the Category:
SQL 
Total posts: 5071 | Sort by Views | Sort by Hits
Journey to SQL Authority with Pinal Dave, May 27, 2012
Views: 1 | Hits
Before continuing this blog post – please read the two part of the SEQUENCE Puzzle hereA Puzzle Fun with SEQUENCE in SQL Server 2012 Guess the NextValueandA Puzzle Part 2 Fun with SEQUENCE in SQL S...
Journey to SQL Authority with Pinal Dave, May 26, 2012
Views: 120 | Hits
Before continuing this blog post – please read the first part of the SEQUENCE Puzzle hereA Puzzle Fun with SEQUENCE in SQL Server 2012 Guess the NextValue. Where we played a simple guessing game abo...
Journey to SQL Authority with Pinal Dave, May 25, 2012
Views: 117 | Hits 3
Yesterday my friend Vinod Kumar wrote excellent blog post onSQL Server 2012: Using SEQUENCE. I personally enjoyed reading thecontenton this subject. While I was reading the blog post, I thought of ver...
Journey to SQL Authority with Pinal Dave, May 24, 2012
Views: 233 | Hits 3
During my 8 years of career, I have been many times interviewer and quite often interview candidate myself. If I am interviewer I do ask many questions from easy to difficult one. When I am a candidat...
Journey to SQL Authority with Pinal Dave, May 23, 2012
Views: 56 | Hits 8
SQL Server management Studio 2012 is wonderful tool and has many different features. Many times, an average user does not use them as they are not aware about these features. Today, we will learn one ...
Journey to SQL Authority with Pinal Dave, May 22, 2012
Views: 148 | Hits 6
Some confusion never go away. Here is the one of the ancient one. Precision of the SmallDateTime is the one concept/confusion I receive more than once a day everyday. Let me start the with question: W...
Simple Talk, May 21, 2012
Views: 96 | Hits 8
When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often needs to be acquired quickly, from scratch. Up until now, it has been a curiously frustrating searc...
SQL Server DBA, May 21, 2012
Views: 103 | Hits 8
Question: I cannot connect to Sql server remotely from management studio , It is the correct User name and password.Cannot connect to xxxx.xxxx.xxxx.xxxx===================================A network-re...
The Code Project Latest Articles, May 21, 2012
Views: 126 | Hits 26
This tip introduces how to query an SqlDataReader with Linq....
Simple Talk, May 21, 2012
Views: 110 | Hits 15
Prefetching can make a surprising difference to SQL Server query execution times where there is a high incidence of waiting for disk i/o operations, but the benefits come at a cost. Mostly, the Query ...
The Code Project Latest Articles, May 21, 2012
Views: 98 | Hits 8
How to export data from a SQL Server CE database to an Excel sheet...
Journey to SQL Authority with Pinal Dave, May 21, 2012
Views: 146 | Hits 10
If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn recently 2) I share what I learn and request your participation. Today’s blo...
The Code Project Latest Articles, May 20, 2012
Views: 124 | Hits 4
How to export data from a SQL Server CE database to an Excel sheet...
Method ~ of ~ failed, May 20, 2012
Views: 151 | Hits 10
At the Developing Windows 8 Metro style apps with C++ event that happened on 18-May-2012, we saw and heard some very interesting things. If you were watching live then hopefully you didnt see how I tr...
Journey to SQL Authority with Pinal Dave, May 20, 2012
Views: 200 | Hits 15
Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to share with the world, collaborate with others on their projects, and download op...
Journey to SQL Authority with Pinal Dave, May 19, 2012
Views: 170 | Hits 7
Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at time instead of running them all together and try to guess the answer. I...
Journey to SQL Authority with Pinal Dave, May 18, 2012
Views: 110 | Hits 7
Nakul Vachhrajani is a Technical Specialist and systems development professional with iGATE having a total IT experience of more than 7 years.Nakul is an active blogger with BeyondRelational.com (150+...
SQL Server DBA, May 17, 2012
Views: 214 | Hits 4
Question: This SQL Server Error message appears in the logs :Timeout occurred while waiting for latch: class 'LOG_MANAGER', id 000000001B8009F8, type 4, Task 0x0000000004ED9288 : 0, waittime 300, flag...
Journey to SQL Authority with Pinal Dave, May 17, 2012
Views: 98 | Hits 4
Microsoft has just released SQL Server 2012 Upgrade Technical Guide. This guide is very comprehensive and covers the subject of upgrade in very much depth.This is indeed a great detailed white paper. ...
Journey to SQL Authority with Pinal Dave, May 16, 2012
Views: 84 | Hits 8
Joes 2 Pros SQL Server Learning series is indeed fun. Joes 2 Pros series is written for beginners and who wants to build expertise for SQL Server programming and development from fundamental. In the b...
Simple Talk, May 15, 2012
Views: 70 | Hits 1
SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It makes use of existing SQL Server features, particularly Failover Clustering, and provides new ca...
the telerik blogs, May 15, 2012
Views: 130 | Hits 1
Microsoft SQL Server 2012 is certainly an interesting upgrade for the SQL Server, offering lots of improvements and new features. There are many things that might tempt you to migrate to 2012 or at le...
SQL Server DBA, May 15, 2012
Views: 624 | Hits 1
Question: This SQL Server Error message is appearing on a SQL Server Production Server Error Logs :The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your...
Journey to SQL Authority with Pinal Dave, May 15, 2012
Views: 194 | Hits 4
Sometime a simple solution have even simpler solutions but we often do not practice it as we do not see value in it or find it useful. Well, today’s blog post is also about something which I have seen...
SQL Server DBA, May 14, 2012
Views: 121 | Hits 10
Question: Id like to create a regular SQL Server security audit. This information will be scanned by an internal audit tool . Could you recommend a list of SQL Server procedures to cover users and obj...
Journey to SQL Authority with Pinal Dave, May 14, 2012
Views: 173 | Hits 3
As you know I have been writing on Columnstore Index for quite a while. Recently my friend Vinod Kumar wrote about SQL Server 2012: ColumnStore Characteristics. A fantastic read on the subject if you ...
Journey to SQL Authority with Pinal Dave, May 13, 2012
Views: 451 | Hits 4
Data modeling is the most important task for any BI professional. Matter of the fact, the biggest challenge is toorganizing disparate data into an analytic model that effectively and efficiently suppo...
Journey to SQL Authority with Pinal Dave, May 12, 2012
Views: 206 | Hits 17
Developer Training Kit is my favorite part of any product. The reason behind is very simple because it give the single resource which gives complete overview of the product in nutshell. A developer ca...
SQL Server DBA, May 11, 2012
Views: 133 | Hits
Question :This message appears in the SQL Server Logs Cannot use Large Page Extensions: lock memory privilege was not granted. Its a SQL Server 2008 64 bit on Windows 2008 R2 64-bit Operating System. ...
Journey to SQL Authority with Pinal Dave, May 11, 2012
Views: 135 | Hits 4
This blog post is inspired fromSQL Interoperability Joes 2 Pros: A Guide to Integrating SQL Server with XML, C#, and PowerShell SQL Exam Prep Series 70-433 Volume5. [Amazon] | [Flipkart] | [Kindle] ...
Simple Talk, May 10, 2012
Views: 142 | Hits 12
In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan Kehayias provides a guide to identifying the causes, reacting to, and ultimately preventing the dread...
Simple Talk, May 10, 2012
Views: 119 | Hits 12
SQL Views are essential for the database developer. However, it is common to see them misued, or neglected. Joe Celko tackles an introduction to the subject, but there is something about the topic th...
Journey to SQL Authority with Pinal Dave, May 10, 2012
Views: 185 | Hits 5
This blog post is inspired fromSQL Programming Joes 2 Pros: Programming and Development for Microsoft SQL Server 2008 SQL Exam Prep Series 70-433 Volume4. [Amazon] | [Flipkart] | [Kindle] | [IndiaPl...
Journey to SQL Authority with Pinal Dave, May 9, 2012
Views: 228 | Hits 3
This blog post is inspired fromSQL Architecture Basics Joes 2 Pros: Core Architecture concepts SQL Exam Prep Series 70-433 Volume3. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up ...
SQL Server DBA, May 8, 2012
Views: 136 | Hits 13
Question: How can I compare two files and report on differences using Powershell ? I have two large T-SQL scripts , which both parse successfully on SSMS , but give me different resultsAnswer: Compari...
Journey to SQL Authority with Pinal Dave, May 8, 2012
Views: 328 | Hits 10
This blog post is inspired fromSQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008 SQL Exam Prep Series 70-433 Volume2.[Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is...
Journey to SQL Authority with Pinal Dave, May 7, 2012
Views: 187 | Hits 8
This blog post is inspired fromBeginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners SQL Exam Prep Series 70-433 Volume1. [Amazon] | [Flipkart] | [Kindle] | [IndiaPlaza] This is follow up ...
The Code Project Latest Articles, May 6, 2012
Views: 156 | Hits 13
This is an alternative for "List SQL Server table column name as rows"...
Journey to SQL Authority with Pinal Dave, May 6, 2012
Views: 180 | Hits 20
One of the very common question I receive on my facebook is that if there is any tutorial for SQL Server 2012 newenhancedfeatures and solutions. I see this demand a bit increasing as the SQL Server 20...
SQL Server DBA, May 5, 2012
Views: 138 | Hits 3
Question: How can I export a Powershell recordset to a CSV file format, so I can then open the file in MS Excel?Answer: Powershell has the Export-CSV cmdlet . The Export-CSV cmdlet creates a CSV file ...
Journey to SQL Authority with Pinal Dave, May 5, 2012
Views: 308 | Hits 3
How many time you have felt that there should be need of the tool which help you to migrate SQL Server Reports from one server to another server. Well, I am glad to see this migration tool for migrati...
Simple Talk, May 4, 2012
Views: 72 | Hits 1
As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows even more sophisticated scripting possibilities for managing automated database tasks...
Journey to SQL Authority with Pinal Dave, May 4, 2012
Views: 169 | Hits 7
I think there was a time when lots of questions were coming via either email or blog comments. Now a days, the trend is changed in recent time. Most of the question I receive is through social media. ...
Journey to SQL Authority with Pinal Dave, May 3, 2012
Views: 222 | Hits 5
Just a day ago in evening I asked very simple question on my Facebook Page. The question was written in jiffy and in very light mood. When writing question I left few things out, and it did miss few d...
SQL Server DBA, May 2, 2012
Views: 107 | Hits 4
Question : When a CREATE INDEX is executed on an existing table with rows in it, is it required to execute a UPDATE STATISTICS or will CREATE INDEX update the stats? Does the STATISTICS_NORECOMPUTE ef...
Journey to SQL Authority with Pinal Dave, May 2, 2012
Views: 160 | Hits 6
SQL Server 2012 launched on March 7, 2012. SQL Server 2012 was available on April 1, 2012 for General Availability. Recently I have received quite a few queries that they are facing issues with SQL Se...
DBA DB2, May 1, 2012
Views: 68 | Hits
Question : I am seeing this SQL0911N Reason Code 68 message in my DB2 diaglog file:command : db2 backup db MYDB online use TSM include logs
SQL0911N The current transaction has been rolled back becau...
Journey to SQL Authority with Pinal Dave, May 1, 2012
Views: 160 | Hits 2
Balmukund Lakhani(Blog | Twitter | Site) is currently working as Technical Lead in SQL Support team with Microsoft India GTSC. In past 5+ years with Microsoft he was also a part of Premier Field Engin...
Code Climber, April 30, 2012
Views: 187 | Hits 13
A few days ago I started migrating a web app I was working on from ASP.NET MVC 3 and EF4 to ASP.NET MVC 4 and EF 4.3.1. All went well, except for some problems with the automatic generation of the DB ...
Journey to SQL Authority with Pinal Dave, April 30, 2012
Views: 203 | Hits 6
Data is powerful. Data drives businesses. Data supports decision making and fuels progress. But managing datamaking data work for usisn’t inherently easy. And if there is one thing that is certain, it...