Welcome to Megan Brooks’ Sql2Go™.com. You’ll find a brief introduction to me and this website here.
See the Services page for information about my availability and services offered.
Why I don’t do AGs (nothing against them; just not part of the service here)…
Services page updated with new services and availability.
Love this… This is nothing new but it’s still a fun idea. The problem: The vendor app we just purchased (and are told we must keep) requires the sa password. The vendor insists that sa is hard coded int… Source: SA Spoof | SQL Studies
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: Set the appropriate compatibility level for deployment (TargetServerVersion) in the report project properties. Build the report project before deploying (this may also catch some kinds of errors). … 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.