New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
10 reads
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
11 reads
New Bug: Change Data Capture (CDC) Fails after ALTER COLUMN
[read this post on Mr. Fox SQL blog] EDIT #1: Fri 19 Jun 2015 We received confirmation the Microsoft Support Team the bug can be reproduced – however at this point in...
2015-05-02
70 reads
2015-03-03
3 reads
NUMA remote (foreign) memory access overhead on Windows, SQL Server and In-Memory OLTP
In NUMA (Non-Uniform Memory Access), processors in the same physical location are grouped in a node which has its own local node memory. In a NUMA based system, there...
2014-12-04
37 reads
Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)
The SQL Server 2014 Buffer Pool Extension feature can extend the buffer pool space on to Solid State Drive (SSD), where data and index pages can be cached. There...
2014-12-04
22 reads
2014-10-31
5 reads
2014-10-20
9 reads
2014-09-26
8 reads
2014-09-19
9 reads
Blogs
More fun with Git: git restore
The setup My day job involves babysitting a lot of Git repositories hosted on...
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Forums
Catalog max connection pool size: 100
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers