Im in Houston Today (and this weekend too)

I’ll be spending the day with the 2011 Idera ACE’s (aka the old aces) and the 2012 Idera ACES (the...

SQL Script Toolbox for Developers

I work with a motley crowd of developers and have the opportunity to give lunch and learn training sessions on...

SQL Server: Measuring The Index Fragmentation

In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance....

Becoming the dumbest guy in the group

“Why I joined Linchpin People as a Teammate”
It was announced publicly this past weekend at SQL Saturday #111 that I...

CONCAT in SQL 2012

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to...

Great User Group Meeting Tuesday, Now on to Madison and SQL Saturday #118

Minnesota SQL Server User Group Meeting Review (4/17/12) First of all, I have to thank the awesome speakers who presented...

More IMPORTANT miscellaneous info

 
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.

Okay,...

PowerShell: Using Exponents and Logs to Format Byte Sizes

In a recent Scripting Games event, I had to format some byte values into their most appropriate size according to...

script system object in resource database

When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or...

Spend two hours with me at #sqlsat107.

In just two days SQL Saturday 107 will be in full swing.  Tomorrow begins their precon with the infamous Kalen...