"More and more I think that key to continued adoption and growth of SQL Server is licensing by scale, not edition, and not by feature. Just...

Other questions aside, I think storing the Phases as a dimension is the more correct design. The performance considerations would be more about the initial DW load, and then cube processing...

"We should be sure that the goals and results from any AI system continue to befocused on what we want to achieve, and that we transparently...

Going to Glacier in August - can't wait. I'll be doing some horseback trail rides. I'm from Australia and now living in the USA, so I'm making the most of...

Worst recent example was a contract web developer who thought he could get away with 'upgrading' a relational database to non-relational. Project delayed for months while other developers fixed the damage.

I agree baselines are critical. SQL server's inbuilt data collections also provide a mechanism for accessing performance metrics over time. Together with Reporting Services report subscriptions, we use this to...

Basic SSIS post including how to map query parameters to variables: https://docs.microsoft.com/en-us/sql/integration-services/control-flow/execute-sql-task?view=sql-server-2017

Some of the MDW reports can be downloaded from here: https://blogs.msdn.microsoft.com/billramo/2010/11/18/may-the-source-be-with-you-mdw-report-series-part-6the-final-edition/

We use MDW extensively for monitoring our customer's databases - it saves them a lot in licensing third-party monitoring software. We had some concerns when there were some omissions with its SQL...

Glad to see someone mention referential integrity - I have seen some disasters resulting from the growing non-relational trend. 
In addition to knowing basic SQL programming I think it is...

I believe there will be problems with future technology to overcome, until someone sees it as an opportunity and turns it around. That to me encompasses the Western free-enterprise culture that...

It looks as though the rows should be readable as the range key locks prevent phantom reads, and inserts, updates & deletes - from https://technet.microsoft.com/en-us/library/ms191272.aspx  "This lock blocks any attempt to...

Thanks Sue its good to know the purging by date can be safely scripted. Its disappointing that an issue like this which can severely impact performance around a system database such...