Webcast Follow-Up: Introduction to Columnstore Indexes
Similar to yesterday’s post, I have a follow-up for another Pragmatic WorksTraining on the T’s session that I delivered last month....
2014-04-10
852 reads
Smart Moves with SQL Server VMs – Data Movement
Today marks another installment in my ‘Smart Moves with SQL Server VMs’ blog post series. Today we are going to...
2014-04-10
979 reads
I’m a Traveling Man
We are coming into quite a busy time for my speaking schedule. I’m hitting the road. It does one thing...
2014-04-10
795 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
722 reads
Collation: Correction -> Expression, Column, Database
I had a recent run in with collation problems and it got me started reading about them. As I read...
2014-04-10
1,016 reads
Rolling back transactions with cursors and local variables.
I’ve been doing some work on a credit card payment system lately. Obviously this needs to be robust and consistent...
2014-04-10
809 reads
Alter Table Not Permitted
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some...
2014-04-10
703 reads
this isn’t thunderdome
When I received my first MVP award for SQL Server it was fairly abstract to me until I went to...
2014-04-09
743 reads
Vote for me at SQLBits
SQL Bits XII is coming this July to Telford in the UK and voting is underway for sessions. I’ve submitted...
2014-04-09
824 reads
Webcast Follow-Up: Introduction to Clustered Indexes and Heaps
Last month, I presented a session for Pragmatic WorksTraining on the T’s titled Introduction to Clustered Indexes and Heaps. I’d meant to...
2014-04-09
771 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers