Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Cumulative Update Released in February 2013 for SQL Server Editions

February 24, 2013

I keep eyes on cumulative updates. I keep a watch that which one released and what they are impacting. If you are facing issues with SQL Server – Comulative Updates may have a solution for you. I suggest to install CU on Development Server first and later roll out the…

SQL SERVER – Weekly Series – Memory Lane – #017

February 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – T-SQL Script to Keep CPU Busy

February 22, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Never run this on your production server – you can just lose your job and can damage your organization. Now I am done with the disclaimer here is the subject I would like to discuss. How to keep your CPU busy? Well, actually there should not be any need of…

SQL SERVER – Shortcut to SELECT only 1 Row from Table

February 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

If you watch any SQL Server Developer, you will notice one particular task them doing every day frequently. It is they select the row from the table to see what are the various kinds of data it contains. Most of the tables are very big so it is always advisable…

SQL SERVER – Restore SQL Database using SSMS – SQL in Sixty Seconds #044 – Video

February 20, 2013

Pinal Dave

SQL Video

Database, SQL Backup, SQL in Sixty Seconds, SQL Restore, SQL Scripts, SQL Server Management Studio

“How do I restore SQL Database backup?”

SQLAuthority News – Introduction to ColdFusion – Video Tutorial on Pluralsight

February 19, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Pluralsight

I recently released a Introduction to ColdFusion video course on Pluralsight. The course is very well received and I have received a quite a lot of good feedback about it. However, one of the questions keeps on showing up in my email box is that users had no idea that…

SQLAuthority News – NuoDB Announces Webinar Series To Demystify Cloud Data Management

February 18, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

NuoDB

For those of you who read my blog regularly, you know that I’ve been evaluating NuoDB, a new database company that is re-writing the rules for relational databases. They’ve introduced a new category – Cloud Data Management Systems (CDMS) – and are claiming to be the first and only. In…