Tags » SQLSERVER

SQL Server latest Cumulative Updates (July 2014)

Directly from the Microsoft Release Service blog, here is the list of latest updates for SQL Server 2008 R2 SP2 and 2012 SP1/SP2:

SQL Server 2008 R2 SP2… 49 more words

SQL Server

#SAP, Breaking Data, and Re-enabling #SQLServer Database Referential Integrity Constraints #Microsoft #FTW

Many times as Data professionals we no longer have full control over the quality of data in the source systems. I am discussing SAP in my example, but I could have easily mentioned PeopleSoft, SalesForce, or a number of other purchased solutions. 1,460 more words

Software Development

#SAP, Breaking Data, and Re-enabling #SQLServer Database Referential Integrity Constraints #Microsoft #FTW

Many times as Data professionals we no longer have full control over the quality of data in the source systems. I am discussing SAP in my example, but I could have easily mentioned PeopleSoft, SalesForce, or a number of other purchased solutions. 1,460 more words

Software Development

PASS SQL Saturday in Parma

This year, 22 November, PASS SQL Saturday will come to Parma, my birth town. I’m proud to be the organizer of that event.

Our community, … 219 more words

SQL Server

SQL Server Offline Documentation

Installing SQL Server documentation offline is pretty straight forwards. I prefer downloading an offline installer instead of using the online library manager, mostly because of a fussy work proxy.

SQLServer

#0340 – SQL Server – Myths - ORDER BY can only work on columns fetched in the SELECT clause

We were recently working on an ad-hoc reporting request that involved customizations to an existing report (more specifically, customizations to an existing query). The query was to be embedded into a custom Excel reporting solution. 554 more words

#SQLServer

Deadlock Detection and Reporting part-I

This will be a 2 part series about deadlock.  First part will be about how you detect deadlock in SQL Server and collect that information.  Second part will be about reporting from the collected information. 248 more words

Deadlock