I recently got added to the company's PluralSight subscription and have found the content and presentation to be quite good. It helps when your employer is forthcoming about their future plans...

If user Smith Rice can query and update tables at will, then they are totally awesome. Best thing to do in this situation is hunker down and hope they don't...

Query Store is to query performance metrics what Service Broker is to message queuing; it's just a standardized, optimized, and extensible way of doing something that many of us have...

I enabled Query Store on a 3 TB sized database that is bulk loaded nightly. During the day it receives a fairly high volume of queries (ie: 100 per second)...

If the job basically involves assisting end users with data entry and querying using the front office application GUI (not back office ETL programming or data analysis) then I'd call...

An administrative assistant who specializes in performing basic data querying tasks for an executive would probably be soon displaced by {Alexa, Cortana, Echo, Watson}. It still sounds like a job...

It's entirely possible the DBA can't help much when it comes to understanding the logical model of the database, especially if it's part of a 3rd party vendor application, because...

...Perhaps we need data scribes in more industries. Not a single employee dedicated to one person, but a specialist in the gathering and cleaning of data, preparing it in...

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...