I Don’t Care

It’s funny how certain sentences can both accurately reflect a situation and communicate entirely the wrong message.
When thinking about cloud-based...

Last Weeks Top “Reading” Links #38

For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...

Metadata Functions (OBJECT_NAME for example)

What is a metadata function? According to BOL a metadata function is one that returns data about the database or...

My upcoming SQL Server Trainings

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
The 1st half...

Natural Born Killers (The series) – Day 5 Key Lookups

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...

Recently Recompiled Resource Hogs

It’s not too uncommon for a query to get a new execution plan that performs a lot worse than it...

SQL Server – How to Enable a Disabled SQL Server Login

When an account is disable it cannot be used to login to SQL Server. You will receive below error when...

SQL- SP_PROCOPTION – AutoNotification to App Owners – When SQL Instance Restarts

We had a situation where Application owners automatically notified whenever server restarts.  The SP_PROCOPTION do have a facility to perform...

ASP.Net MVC Debugging "Internal Server Error 500"

I was recently seeing “Internal Server Error 500” when trying to make an ajax call from an ASP.Net MVC view...

Huge collection of Free Microsoft eBooks

I must share it, there are many useful resource

http://blogs.msdn.com/b/mssmallbiz/archive/2013/06/18/huge-collection-of-free-microsoft-ebooks-for-you-including-office-office-365-sharepoint-sql-server-system-center-visual-studio-web-development-windows-windows-azure-and-windows-server.aspx?Redirected=true

http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx

http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/30/another-large-collection-of-free-microsoft-ebooks-and-resource-kits-for-you-including-sharepoint-2013-office-2013-office-365-duet-2-0-azure-cloud-windows-phone-lync-dynamics-crm-and-more.aspx

Thank you , Eric