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,270 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,838 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
657 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,719 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,058 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
606 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,034 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
857 reads
Blogs
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers