Video: Walk & Talk #002 – RTO
Recovery Time Objective (RTO)
What is it and why does it matter?
I am actually walking this time! Join me to walk...
2014-09-18
211 reads
Chris
Video: Walk & Talk #002 – RTO
Recovery Time Objective (RTO)
What is it and why does it matter?
I am actually walking this time! Join me to walk...
2014-09-18
497 reads
Export a SSMS Query Result Set to CSV
Once you have a query that is returning the data you like in SSMS you have a few options to...
2014-08-19
39,838 reads
Export a SSMS Query Result Set to CSV
Once you have a query that is returning the data you like in SSMS you have a few options to...
2014-08-19
808 reads
Live 360 Discount Code & Helping Digby!
Join me at SQL Live 360 this November!
I am hugely excited to have been selected to present at Live 360,...
2014-08-05
391 reads
Live 360 Discount Code & Helping Digby!
Join me at SQL Live 360 this November!
I am hugely excited to have been selected to present at Live 360,...
2014-08-05
869 reads
Null Values in SQL Server
Walk & Talk #001 – Unknown or Null Values
Ride with us in this video as we head to Richmond, Virginia to present...
2014-07-21
607 reads
Whitelist a Set of IP Addresses in SQL Server
Blacklist vs Whitelist
Are you on the Whitelist?
I think just about everyone is familiar to some degree with the concepts of...
2014-07-14
3,731 reads
How Critical is a Demo?
Do you always need a demo?
Is a demo always needed?
One of my more popular presentations I have been doing as...
2014-07-03
658 reads
Announcing SQL Summer Camp
A new way to train in SQL Server.
I had an idea a few years back about a training event unlike...
2014-06-02
672 reads
Blogs
A New Word: Lackout
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Delta Lake over Spark Connect
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Introducing FabricTools (PowerShell module)
By Kamil
🔍 The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps...
Forums
Merge techniques
In Azure SQL DB, i want to merge records from the staging table to...
SSRS error: The Value for the image 'Image1' has a constant value...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
XML_COMPRESSION for existing tables
We are in the process of upgrading to SQL Server 2022 and would like...
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers