Back To (Security) Basics
Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another...
2017-12-06 (first published: 2017-11-27)
1,582 reads
The Monday Morning DBA
File This Under File Groups (Part 1)
I never had cause to give much consideration to storage when I was a SQL developer. The companies I worked...
2017-11-19
448 reads
Spaced-Out Strings
I came across this in a code review not long ago:
Three things pop into my head when I see this...
2017-11-27 (first published: 2017-11-13)
2,594 reads
A View On Views
In my experience, there are few database objects more poorly understood, misunderstood, misused, and outright abused, than the humble view....
2017-11-16 (first published: 2017-11-05)
1,990 reads
It’s All About The Joins
One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too...
2017-10-29
528 reads
Welcome to The Monday Morning DBA
I started my IT career twenty years ago as a VB and C developer, wandered into C++ for a bit,...
2017-09-30
352 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