Natural vs Artificial Primary Keys
There has been a long standing debate over the use of a natural primary key vs an artificial one. I...
2016-08-29
1,242 reads
SQLStudies
Copying an on-premise Database to an Azure SQL Database
Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud....
2016-09-06 (first published: 2016-08-24)
1,834 reads
Cloud Security
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those...
2016-08-22
648 reads
RBAR vs Batch
Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s...
2016-08-25 (first published: 2016-08-17)
2,715 reads
Temper, Temper
Possibly the single most influential event in my career happened over 25 years ago. I lost my temper at a...
2016-08-15
1,051 reads
Write-Only permissions
Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other...
2016-08-11
617 reads
Azure: What’s the difference between SQL Database and SQL Server?
If you want to blog T-SQL Tuesday is a great way to get started. On the first Tuesday of each...
2016-08-09
604 reads
What’s the difference between LEFT and RIGHT OUTER JOINs?
A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?”
There are several different...
2016-08-03
1,291 reads
Using impersonation to allow a task without granting the required permission.
I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can...
2016-08-03 (first published: 2016-08-01)
2,032 reads
When was this database restored?
I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis....
2016-07-27
856 reads
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers