The Modern Data Warehouse via The Modern Data Warehouse – SQLServerCentral.
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.
The trick is to stop and start the RS service at the time of day when it should start up. The recycle time is relative to that, not the time that it last recycled… Prevent SQL Server Reporting Services Slow Startup.