What is a Foreign Key & How many foreign keys can you have on a single table?
Yesterday, I was attending a database design meeting. In the meeting, I was asked one of the questions – “How many...
2018-04-12 (first published: 2018-04-05)
12,084 reads
Blog Posts
Baton Rouge SQL Server User Group – Execution Plans
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton Rouge .Net User Group does the same at the...
2018-04-11
7 reads
Baton Rouge SQL Server User Group – Execution Plans
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton...
2018-04-11
314 reads
Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,061 reads
Contextual View
In this post I describe technique of presenting data that is context specific - for example, data that will be changing...
2018-04-11
1,181 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
1,007 reads
Cost savings of the cloud
I often hear people say moving to the cloud does not save money, but frequently they don’t take into account...
2018-04-11
165 reads
Creating Facets in SQL Server 2017 Using R
SQL Server 2017 In-Database Machine learning has brought the analytics closer to the data. It is now convenient to do...
2018-04-11
949 reads
Dates and Times in SQL Server: the science of time
Now that we have covered the various date and time data types (see the post from last time) in SQL...
2018-04-11
853 reads
DBA Fundamentals–Tuesday 11 Central–Execution Plans
WHAT: EXECUTION PLANS FOR BEGINNERS
WHEN: Tuesday, 04/17/18 - 11:00 am – 12:00 pm
WHO: Thomas LeBlanc
WHERE: https://attendee.gotowebinar.com/register/7086336336602188044
This will be a Beginners session highlighting...
2018-04-11
594 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Foreach Loop still executes after process and delete all the folders
I have two challenges XML source control not displaying the XML file parent node...
Which 'Where' statement conditional upon a variable
Thanks in advance for any clues on this. I am trying to write a...
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers