Back up Encryption
Nowadays security breaches happen way to frequently. As DBA’s we should all take extra care with sensitive data and ensure we...
2018-09-11 (first published: 2018-09-05)
2,073 reads
SQLEspresso
What is Automatic Tuning in Azure SQL Database
Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many...
2018-08-28
504 reads
Save Money On Your Azure Monthly SQL Database Bill
Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model...
2018-09-05 (first published: 2018-08-22)
2,240 reads
Contained Database – No more need for Server Level Logins
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained...
2018-07-11 (first published: 2018-07-05)
2,912 reads
Congrats to DCAC Staff on MVP Renewals
July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and...
2018-07-02
318 reads
Replication Max Text Length
Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce...
2018-06-28 (first published: 2018-06-20)
9,727 reads
Respectfully Responding
I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets....
2018-06-29 (first published: 2018-06-14)
2,259 reads
How to get started with Always Encrypted for Beginners Part 4: Change is Coming
A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part...
2018-06-25 (first published: 2018-06-13)
2,569 reads
Importance of Statistics
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
576 reads
Query Predicates
Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...
2018-05-24
732 reads
Blogs
A New Word: Lookaback
By Steve Jones
lookaback– n. the chock of meeting back up with someone and learning that your...
Azure Vulnerability Assessments
Regarding managing databases in the cloud, security should never be an afterthought. That’s where...
Speaking at the NYC Lunch and Learn–May 23
By Steve Jones
In a couple of weeks, I’ll be in New York City for the Redgate...
Forums
Deleting a Database
Comments posted to this topic are about the item Deleting a Database
Data Analyst AI tool
Comments posted to this topic are about the item Data Analyst AI tool
Removing Log Shipping
Comments posted to this topic are about the item Removing Log Shipping
Question of the Day
Removing Log Shipping
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers