Monthly Archives: March 2018

Predictions for the Future

There is no shortage of predictions that we all make every day. Long before PREDICT and the popularity of Machine Learning/R/Python and more, each and every one of us has regularly made guesses about what will happen in our world. Some of … Continue reading

Posted in Uncategorized | Tagged | Comments Off on Predictions for the Future

Table Internal Sync Rule–Substituting the Sync Column

I’ve been playing with Data Masker for SQL Server v6 and it’s an interesting product. I like the way it works, but I do find it a little challenging sometimes to figure out how to mask values. I’ve written a … Continue reading

Posted in Uncategorized | Tagged , , | Comments Off on Table Internal Sync Rule–Substituting the Sync Column

SSMS 17.4 Vulnerability Assessment

SSMS 17.5 is out as of February 2018, but the the Vulnerability Assessment (VA) was released in SSMS 7.4 It seems that the Microsoft tools team is trying to build us better tools that come with the platform. There are … Continue reading

Posted in Blog | Tagged , , | Comments Off on SSMS 17.4 Vulnerability Assessment

Decouple the Tools

For years, SQL Server included a complete set of add-ons with the main product. We got SSIS, SSRS, and more as part of an integrated installation. This also included things like Books Online and various tools, such as Profiler, bcp, … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Decouple the Tools