PowerSQL – SQL Instance Configuration & Installation Information by Reading Registry Keys

Today I got a chance to retrieve configuration information of sql server 2005 instances. PowerShell provide a facility to read...

SQL Database connectivity|| SharePoint Configuration || Named Pipes Error In MOSS 2007

Hello Friends,
MOSS2007 is still live and sometime we need to check certain features and that can give learning too. Recently...

SQL in the City London 2013

Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...

SQL Server Data Tools (SSDT) – June 2013 update

SQL Server Data Tools (SSDT) has a new update:
VS 2010: June 2013 version: 10.3.30618.1, December 2012 version: 10.3.21208.0, November 2012 version:...

SQL Server Pro Article: Custom Programming to Enhance SSRS Reports

I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance...

SQL Server: Part 3 : All About SQL Server Statistics :Who Create and Manage the Statistics ? Role of Statistics in Performance Tuning

In the last posts, we have discussed about the histogram ,density vector and how SQL server use the statistics information in cardinality estimation. In this post let us discuss about how the...

SSRS export to Excel converts DateTime Column to Text Column

Recently we observed a weird issue with SSRS export to Excel. One of the datetime column in the report was...

trace flag for backup and restore operation

1. 3004
show the internal backup/restore operation for every step.
ex.
dbcc traceon(3004,3605,-1)
GO

3605 means output the message to errorlog. you can use 3604...

T-SQL Tuesday #44 The Second Chance

Hello Dear Reader!  This is the first Tuesday of the month and you know what that means.  It’s time to...

July 2013 – Monthly SQL Server Checklist

First Monday of the month and time to update the monthly SQL Server checklist.  Monthly SQL Server checklist, you ask?...