The weirdness of SSRS dataset stored procedure metadata, explained at last! I have fought this battle in the past and won, eventually, but it sure is nice if you know the enemy. “Evil” is no exaggeration.
The Modern Data Warehouse
Change Your #SQLPASS Password Right Now. – Brent Ozar Unlimited® by Brent Ozar Unlimited®.
119 SQL Code Smells.
Resolving SSDT-BI Installation with IsVisualStudio2012ProInstalled() error – SQLServerCentral.
Locating business logic in applications – Simple-Talk. One of the most pernicious and pervasive myths in business-application development is that all business logic must be kept from the relational database and contained in a separate ‘business layer’.
The second time I have heard this lately: It’s not NoSQL versus RDBMS, it’s ACID + foreign keys versus eventual consistency | Java Code Geeks.
Fascinating read: Chris Date and the Relational Model.
Is SQL Server Losing Mindshare.
One of my favorite subjects of late. Just watch out if your variable expression makes calls to a custom assembly. It doesn’t always seem to work! SQL Server Reporting Services Report and Group Variable References.