Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break

We all know that we should document our SQL Servers, right? RIGHT?
So let's say you had some time on...

SQL 2005 or above – Find Transaction Rate on a busy OLTP Database

Change Database name of a below mentioned query
DECLARE @cntr_value1 bigint

DECLARE @cntr_value2 bigint
SELECT ‘BEFORE’
SELECT @cntr_value1 = cntr_value

FROM sys.dm_os_performance_counters

WHERE counter_name = ‘transactions/sec’

AND object_name = ‘SQLServer:Databases’

AND...

PowerShell – CHECK, START and STOP SQL Services of a remote servers

Replace a valid server name in the following examples. Try to do a testing on your local machine and understand...

Exploring Excel 2013 for BI Tip #6: GeoFlow–The Latest Excel Visualization

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...

Find SQL Server Installation – Date and Time – 2005 Onwards

SELECT create_date as ‘SQL Server Install Date’ FROM sys.server_principals WHERE name=’NT AUTHORITY\SYSTEM’

PowerShell – Pattern Search – Local or Remote Folder

#Description : List all the files of a local or remote drive, run this PowerShell script using PowerShell-ISE.exe for better execution...

Set DAC port with a specific number

Usually named instance can uses dynamic port, if firewall setup on the server, you can use SQL Server Configuration Manager...

SSRS Map Label Overlap Fixed

In Reporting Services 2008 r2 and above there is a great tool called the Map tool. It is great for...

Staggering SQLIO Sessions Across Multiple Volumes

In a previous post, I discussed running SQLIO against multiple files.  The purpose in using multiple files is being able...

SQL Server 2000 is unsupported

Microsoft no longer supports SQL Server 2000 in any capacity.
http://youtu.be/A5cneCgNA9U