Welcome to Megan Brooks’ Sql2Go™.com. You’ll find a brief introduction to me and this website here.
See Services for information about my availability.
Update (7/25/16): You should be fine with older versions of Report Server and SSMS 2016/Visual Studio 2015/SSDT, if you do these three things:
Disclaimer: I have not yet tested this, but the built RDL looks OK.
I only have time for a quick post at the moment, but be aware that if you take advantage of the latest SSMS 2016/Visual Studio 2015 SSDT releases, they do (at last) incorporate the SSDT-BI designer templates. The VS 2015 Report Designer, however, always upgrades the edited RDL file to the 2016 RDL schema. Continue reading →
Window Functions and Cruel Defaults – Brent Ozar Unlimited®
It has been years since I tried selecting the RS 2012 option that automatically configures Report Server at installation time. I vaguely remembered that there was a good reason never to use it, but I felt like I needed reminding. And there was. … Continue reading →
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. Dealing with the Evil of FMTONLY from SSRS – SQLServerCentral.
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.