If we’ve been around for any length of time, we’ve all got that project that “went south”. The one that…
I like triggers. (Stop throwing things!) Seriously, I like the fact that you can set up actions in a database…
Thank you all for attending my session yesterday on improving application performance with async messaging using Service Broker. It’s a…
When taking on a major data migration project it’s important to know what queries are running against your data source…
Anyone who’s seen me present at any event has heard me ask everyone in the audience to find something about…
Technology changes rapidly, and it can be a real challenge to keep up with everything that’s changing. For me, the…
As stated on the home page of this site, Data is the Truth of Your Business. You need good, quality…
Businesses need answers to questions that support or inform decisions. Those answers are best served by supporting data, and that…
So many people in our industry equate disaster recovery to high availability. In many cases high availability does mitigate localized…
A colleague of mine recently asked me the best way to run queries against SQL Server from PowerShell. The scenario…