Feeds:
Posts
Comments

Archive for May, 2011

SQLAuthority News – Best SQLAuthority Posts of May

Posted in About Me, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 31, 2011 | 1 Comment »

Month of May is always interesting and full of enthusiasm. Lots of good articles shared and lots of enthusiast communication on technology. This month we had 140 Character Cartoon Challenge Winner. We also had interesting conversation on what kind of lock WITH NOLOCK takes on objects as well. A quick tutorial on how to import [...]

Read Full Post »

SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)

Posted in PostADay, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 30, 2011 | 75 Comments »

Earlier this weekend I have presented at Bangalore User Group on the subject of SQL Server Tips and Tricks. During the presentation I have asked a question to attendees. It was very interesting to see that I have received various different answer to my question. Here is the same question for you and I would [...]

Read Full Post »

SQL Azure – SQL Azure Throttling and Decoding Reason Codes

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 29, 2011 | 3 Comments »

I was recently reading on the subject SQL Azure Throttling and Decoding Reason Codes and end up reading the article over here. What I really liked is the explanation of the subject with Graphic. I have never seen any better explanation of this subject. I really liked this diagram. However, based on reason code one [...]

Read Full Post »

SQL SERVER – A Quick Notes on SQL Azure

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on May 28, 2011 | 4 Comments »

I was recently attending a small meeting where I was asked if I can share few things to be considered when designing SQL Azure database. Today I am sharing the same notes over here. Disclaimer: This is no way a complete guide – this is some notes which are compiled in short meeting. SQL Azure [...]

Read Full Post »

SQL SERVER – Copy Database from Instance to Another Instance – Copy Paste in SQL Server

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Azure, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on May 27, 2011 | 18 Comments »

SQL Server has feature which copy database from one database to another database and it can be automated as well using SSIS. Make sure you have SQL Server Agent Turned on as this feature will create a job. The same job will execute the task. Make sure that SSIS is properly configured as well with [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers