My Journey with SQL Server

My Journey with Microsoft SQL Server as SQL Server DBA!

Stories on Issues Faced, Struggled, Hacked, Profiled, Troubleshooted, Resolved, Fixed and .... Restarted!

Monday, March 26, 2012

How to enhance your knowledge in SQL Server?

›

Read SQL Server Best Practices Articles in MSDN Read SQL Server Whitepapers Follow SQLCAT, PSSSQL, Paul Randal blogs. Read Guru's Gui...

Tuesday, November 29, 2011

Why you should not use undocumented commands in production server?

›

Today I worked on a interesting issue... There was a Non-yielding scheduler dump generated and continuos Non-yielding scheduler error mess...

Sunday, May 22, 2011

How to track Auto Close Database Shutdown using T-SQL

›

While I was working on a troubleshooting scenario, I was asked for a way to track whether database is shutdown already (Auto closed) Curre...

Wednesday, May 11, 2011

Get Windows Kernel Version from Command Prompt using WMIC

›

I got a task to get the windows kernel version using a command. There are lot of options available like winver command from command line, ...

Tuesday, May 3, 2011

How to get job id of a maintenance plan

›

Should be a simple one but just posting here for someone looking for a quick reference. SQL Server creates jobs for each sub plan in a mai...

›

Home

View web version

Powered by Blogger.