One caution I would add is that if you operate in a specialist area that only other DBAs will appreciate then you risk being invisible within your organisation except...

I believe that concerns about page buffer pool, plan cache, and latency are outside the intended use case for this type of serverless databases. It's definitely not for high volume...

I've never done this before, but assuming a scenario where you've lost the MASTER database, have no good backups, but do still have good user database (MDF) files, it may...

Microsoft's MSDN website has good documentation, and there are a couple of books by RedGate that might be useful.

Here are a few that I've bookmarked in the past to get...

• This reply was modified 6 years, 6 months ago by Eric M Russell.

The higher a DBA climbs up the mountain, the more he or she will realize how big the world is, and how many more mountains there are. Of course, if...

Perhaps it's a limitation of the GUI you're using to design your tables. T-SQL certainly allows for declaring the same foreign key in multiple tables.

It depends on what type of lab you want to setup. I believe that building up a local lab is way more expensive than an Azure subscription (both in financial...

I'm not sure the FTC has a general reporting rule. They have rules over health data and there was (maybe law?) a draft on credit agencies, but I don't...

Here in the US, the Federal Trade Commission (FTC) mandates that corporations report data breaches, and other agencies enforce HIPPA and Sarbanes-Oxley Act (SOX). But is there an agency (the...

We keep hearing about data breaches resulting from data being exposed on the internet, meaning that a web search could access the data in un-encrypted form. There is more to...

a_dep like '100%'

What I meant was that, when considering which version of SQL Server to run on, if there are...

I've never known any release of SQL Server to be categorically "unstable". Every release fixes some issues and introduces new issues, but every experience is unique depending on what features...

I believe that Azure Stack and server-less architecture could make financial sense for an organization with a very large IT enterprise; maybe something like a government or global bank where...

Also, since the application is only filtering on a tiny subset of rows, then consider simply using Filtered Indexes as an alternative to my previous suggestion of a Paritioned View...