Writing Another Question of the Day

The most recent one I wrote was a “question from error message” pattern. An experienced DBA should get it easily,...

Data Collection in SQL Server

Problem : As a DBA, one of your primary job description is to handle management and administration of 1 or 100+...

Psst! Wanna some API?

If you have already visited SQL Code Guard's website you might notice a reference to an "API for custom tool...

Thanks to Toadworld.com team for recognition !

Thanks to Toadworld.com team for recognition !

Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit...

Allowing your App team to run SQL Agent Jobs

Problem : In most of your projects, there is always that situation that the application team have that need to run...

That “Cannot Generate SSPI Context” headache

Problem : You have completed an SQL Server setup on a new instance. The setup is successful, you can connect locally...

Carolina Cruise

I’m going to speak at three user groups in three days in North and South Carolina. Evidently this is known...

DAX #2 – Installing AdventureWorks DW Tabular Model SQL Server 2012

OK, first thing first. We all know the famous Adventure Works multidimensional sample project. To learn the tubular mode/DAX, we...

Error Log Management

Thought I’d write a quick post about managing error logs within SQL Server. Good error log management is essential for...

Friday Followup For May 9, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...