Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – SQL Backup and FTP – A Quick and Handy Tool

October 3, 2011

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

SQL Backup and Restore, SQL Documentation, SQL Download, SQL Utility

Scroll down at the end of this post to win my SQL Wait Stats Book. I have used this tool extensively since 2009 at numerous occasion and found it to be very impressive. What separates it from the crowd the most – it is it’s apparent simplicity and speed. When…

SQL SERVER – CE – List of Information_Schema System Tables

October 2, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Yesterday I wrote blog post that I downloaded WebMatrix and it was very easy to install, after installing I noticed it has default database as SQL CE. I started to play with SQL CE and I was glad that it supports many of the Information_Schema. There is one important thing…

SQL SERVER – CE – Samples Database for SQL CE 4.0

October 1, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

I recently installed WebMatrix Version Next. I found it very neat and easy to install. You can download it for FREE. After installing it I download when I checked the about page, it displayed following result. ————————— About WebMatrix ————————— Version 2 Beta WebMatrix: 7.1.1307.1 IIS 7.5 Express: 7.1.1307.1 .NET…

SQL SERVER – Denali – DMV – sys.dm_os_windows_info – Information about Operating System

September 30, 2011

Pinal Dave

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

SQL DMV

One more quick introduction to DMV for Denali. Following DMV provides information about Windows Operating System. Here is the quick example of the same. This DMV returns information about the operating system volume (directory) on which the specified databases and files are stored. Here is the quick example I have…

SQL SERVER – Denali – DMV – sys.dm_os_volume_stats – Information about operating system volume

September 30, 2011

Pinal Dave

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

SQL DMV

SQL Server Denali has many new interesting feature – one of the interesting feature is New DMVs. This DMV returns information about the operating system volume (directory) on which the specified databases and files are stored. Here is the quick example I have created for the same. SELECT DB_NAME(f.database_id) DatabaseName,…

SQLAuthority News – Various Ways to Stay in Touch with SQLAuthority.com – Best Practices

September 29, 2011

Pinal Dave

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

Best Practices

Social Media is growing and quite commonly we reach to the point where we have confusion about the various aspects of the same. I have written a previous article on this subject SQLAuthority News – Social Media Confusion – Twitter, FaceBook, LinkedIn and Me. I am present and active at…

SQL SERVER – Denali – DMV Enhancement – sys.dm_exec_query_stats – New Columns

September 28, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts

SQL Server version next Denali has lots of enhancements. Some of the enhancements are just game changing and overcomes needs of more coding to do the same thing. Similar function DMV is sys.dm_exec_query_stats. There are four new columns added to this DMV. I have often used this DMV to check…