So as long SQL Server keeps adding features I can use, while maintaining the same historical level of reliability and affordability, then I'd say each new release is better than...

Even for core SQL Server developers, the incremental improvements to ColumnStore and In-Memory table support are reason enough to upgrade.

Well, asking for my favorite SQL Server version isn't the same as asking for my favorite Smashing Pumpkins album release. SQL Server has a history of linear improvement. I may...

With a scale-out architecture which allows for individual servers to fail over or be taken offline for maintenance, the questions becomes: At what point of degradation is the application or...

Creating a linked server connection to another domain.

It seems to me that if an organization already has a customer data-mart, then fulfilling such a request would be as simple as running a canned report. It could even...

There is practically no limit to the logical size of a SQL Server table. However, the underlying hardware, data model, and configuration will limit what is practically possible. 168 TB is...

Well, I'm not a clairvoyant. Better than that; I'm an engineer. What I can see "GDPR Consultant" as the new hot IT career title. What I also see are 3rd...

I've worked with multi-tenant databases in the past, including situations where external clients had ad-hoc access query access. The way we dealt with it was to have a separate database...

Despite having a database developing career that spans 20 years and several significantly sized organization, I've somehow never had a use case for row level security, never even seen in,...

If you are concerned about how much data would be pulled across the network from Azure to your work PC, then one option is to provision an Azure IaaS instance...

It is interesting how the cable TV has for decades been regulated in terms of customer profiling, data collection, political advertising, content, and anti-monopolization. But FaceBook hasn't been held to...

Where I've worked, ServiceNow has been part of the change control process, even if the DBAs occasionally create the support ticket and assign it to ourself. I'm not sure if...