SQL Server 2016 – Stretch Databases
One of the feature I’ve been interested in that’s coming with SQL Server 2016 is the stretched database. The ability...
2015-06-15
518 reads
The DBA Who Came In From The Cold
SQL Server 2016 features I’m interested in
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
1,353 reads
SQL Server 2016 features I’m interested in
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
490 reads
In-Memory OLTP: Part 4 – Native Compilation
This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery
In this final post for the #SQLNewBlogger challenge I want...
2015-04-27
895 reads
In-Memory OLTP: Part 4 – Native Compilation
This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery
In this final post for the #SQLNewBlogger challenge I want...
2015-04-27
320 reads
In-Memory OLTP: Part 3 – Checkpoints
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
1,084 reads
In-Memory OLTP: Part 3 – Checkpoints
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
411 reads
In-Memory OLTP: Part 2 – Indexes
Following on from In-Memory OLTP: Part 1 – Introduction where we created a database capable of hosting memory optimised tables, I’d...
2015-04-13
870 reads
In-Memory OLTP: Part 2 – Indexes
Following on from In-Memory OLTP: Part 1 – Introduction where we created a database capable of hosting memory optimised tables, I’d...
2015-04-13
465 reads
In-Memory OLTP: Part 1 – Introduction
In-Memory OLTP is getting a lot of (rightly deserved imho) hype at the moment. But what does it entail exactly?...
2015-04-10 (first published: 2015-04-06)
829 reads
Blogs
Delta Lake over Spark Connect
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Generating Random Strings with GenAI
By Steve Jones
One of the things I’ve been experimenting with in AI is taking things other...
Heading to SQL Bits 2025
By Steve Jones
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day...
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