https://www.mssqltips.com/sqlservertip/4596/copying-sql-server-backup-files-to-azure-blob-storage-with-azcopy/

First, manually copy the latest full backup for each database to Azure storage.
2nd, setup automated job to copy backups to Azure.
3rd, if you feel it's needed, research tools...

Rather than depending on proper string -> date conversion at time of query, you can create a check constraint on the table column, insuring that date strings are encoded with...

Hi Gary, CosmosDB (specifically the DocumentDB) is something I've started to work with this past year. Change Feed seems geared toward replicating from CosmosDB to either another CosmosDB database or...

I think we could use more folks with an IT background in the political legislature to balance and counterpoint the usual career politicians, activists, and businessmen. Those of us in...

Isolation level determines how much time your query will spend waiting for other processes to commit their updates. In a transaction databases (where many users are querying and updating at...

I went to PASS 2017 and didn't witness anyone there drunk, dressing provocatively, or getting rowdy; although I have seen it at high school band camp and neighborhood block parties....

..Certainly some people want the freedom to behave as they see fit, where they don't believe they are doing anything wrong. I understand that, but ultimately I also believe...

Perhaps the data science teams at companies like Twitter and FaceBook should turn their analytical skills inward and start asking questions like: "Why is employee #2922 suddenly interested in querying...

First, you need encryption, more encryption, and then encryption again. The guys who rack, stack, and backup the data don't need to decrypt (much less query) the databases at all....

I believe that an analogy can be made between a data breach and an accidental spill of industrial pollution into a river. It would be pretentious to argue that the...

I don't know your database, but it could be argued that if users must routinely perform LIKE '%keyword%' queries on text columns just to locate the rows they are looking...

Today in 2018, when an IT organization is thinking about the next 5 or 10 years, the debate shouldn't be Standard Edition vs. Enterprise Edition or SQL Server vs. PostgreSQL,...