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,259 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
656 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,717 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,057 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
605 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
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers