I like MSSQL Central Management Server especially for deploying Ola's Backup Solution across a large amount of SQL Servers.
If you have to store backups in different locations depending on the...

I would also call it something between smart coding and coding for eventual failure (smart coding for eventual failure?). Some of these mentioned things like Staging Tables should be (and...

as this is still somehow related to Variables and the likes, I'll make this a follow up question:

Imagine there is the daily load which passes the daily File_YYYYMMDD.txt...

Well not just Amazon's attempt at AI has been biased, Google and Microsoft AIs have been found to be racist at times.

I would love to have a simple...

cheers, happy to help! 🙂

and then there are companies like one of my current customers:

Oversize varchar fields by a good margin in case "you ever might need to add more text than...

Hi there,

Glenn wrote a good Article on this a while ago, if you use that script and pass in NONE for CompressionType you should see the additional...

indeed as Sue suggested I would rather have a look at gMSA. What you might be missing is Service Pricipal Names do still like AD Accounts, which leads straight to...

just imagine SQL Server expects some other data after the crash to be in that location, afaik once SQL Server knows about corruption he won't stop moaning about it either....

Well one reason for having multiple Applications within one DB could be sharing the same base data for different Applications.

Of course you could import the data 20 times...

I'll start with Question 1: Pretty simple, if the data stored in that particular area isn't really used, you won't get a message any sooner. Once you start querying (or...

Hi Christoph,

as far as I know it does apply to Basic Availability groups, the limitations are different there it's more along the line of two nodes and only...

try this site it's not the most up-to-date information but for older versions it's still useful.
Or try this one, looks more recent

When you urge the business side to not waste my precious time and the first thing happens is 1 week of work was wasted because datatypes agreed on didn't match...

I like to use Custom Schemas for segregation of applications or application functions. One thing I like is using an [Error] Schema in DWH Scenarios, there I have things of...