Learn more about SQL Server tools


SQL Server DBA Tips and Tricks

Latest SQL Server Tips
Get Total Line Counts for all SQL Server Source Objects Using PowerShell
I want to count the number of lines of code for all of our non-CLR procedures, views and UDFs in a database, how can I do this? I also want to exclude comments and empty lines from the counts.
What's Trending?
SQL Server Cursor Example
In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them. Can you provide some cursor examples? Can you give any guidance on when to use cursors? I assume Microsoft created them for a reason so they must have a place where they can be used in an efficient mann
SQL Server Tutorials
SQL Server Webcasts
High Availability for SQL in VMware without Raw Device Mapping
Did you know that you can have high availability (HA) protection for SQL in a VMware environment without the hassles of Raw Device Mapping (RDM)? Creating shared storage clusters in a VMware environment means complex implementation using RDM - and giving up important VMware features, such as Vmotion.

In this webinar, SIOS clustering expert Tony Tomarchio will demonstrate an easy way to create a failover cluster in a VMware environm
All Categories

Sponsor Information