(Prashanth Jayaram) The following query lists all the Primary keys of all the table.

(David Dye) Often you may run across a stored procedure, view, or function that peeks your curiosity and you REALLY want to see how it works. This is even true of system objects. There are several ways of provinding the text to these objects using T-SQL.

(Brady Upton) I have implemented the SSIS catalog that comes with SQL Server 2012 and I love the reporting and centralization that comes with it, however, I noticed after a few months that the database was growing exponentially. How can I keep the size of this database to a minimum?

(Derik Hammer) Often I need to examine an execution plan from a production server. Just as often, I can’t re-run the stored procedure in that environment. There are several techniques for simulating the environment on a test server such as exporting statistics and using the un-documented DBCC AUTOPI

(Pradeep Adiga) Last week I had worked on SQL Server 2008 R2 installation on a Windows Cluster. The installation would go fine until the installer tries to bring the SQL Server resource online. At that time it would fail with the following error message,

(YsFred4) I have been using Azure for many years and have a cloud service that supports my global prayer app named Thoughts and Prayers (WP, W8, iOS, Android). I created this years ago before Azure Mobile Services were created and made my own WCF service to use across all platforms.

(Greg Larsen) Before you can read data from your database you need to understand how to insert data into the tables in your database. There are a number of different ways to accomplish this. In this article I will be explore the methods you can use when inserting data into a database table using t

(Kenneth Fisher) It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host picks a subject and we all blog about it. It was originally started by Adam Mechanic (b/t) almost 5 years ago. This month Sebastian Meine (b/t) is hosting and he’s picked passw

(Jen McCown) I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating. RECOVERY_PENDING is very different from RECOVERING.

(Carla Abanes) In a previous tip, you have learned to setup AlwaysOn in SQL Server 2012. After a successful setup and everything seems to be in the right place, you are preparing to test your AlwaysOn to failover to your secondary replica for the first time.