SQL Server 2022 introduces an exciting feature: the ability to access the Query Store from a secondary replica in an Availability Group. This enhancement offers a significant advantage, allowing...
2023-12-11 (first published: 2023-11-22)
353 reads
As you may have noticed, the agenda for Data Saturday Holland was recently published. I’m delighted to share that I will be conducting a full-day precon on October 7,...
2023-08-01
13 reads
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking about SQL Server Availability Groups.
2023-04-05 (first published: 2023-03-21)
233 reads
On April 4, 2023 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when...
2023-03-17 (first published: 2023-03-07)
314 reads
Today I have uploaded SQL Server Quickie #44 to YouTube. This time I’m talking about SQL Server on Docker.
2023-01-23 (first published: 2023-01-16)
210 reads
On September 29, 2022 I will run an SQLpassion Live Training about SQL Server Availability Groups. High Availability with previous versions of SQL Server was always complex: you had...
2022-09-12 (first published: 2022-09-05)
177 reads
On May 3, 2022 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when...
2022-04-04
34 reads
Today I’m talking about limitations that you have with data pages, and why there are restrictions that you will love, while you will hate other restrictions. As you learned,...
2022-03-07 (first published: 2022-02-21)
280 reads
In today’s blog posting I want to talk about Heap Tables in SQL Server. Heap tables are tables without a Clustered Index. A table in SQL Server can have...
2022-03-01
387 reads
Today I’m talking about Extent Management in SQL Server, because this is a very important topic, especially when you deal with TempDb in SQL Server. On a very high...
2022-02-28 (first published: 2022-02-14)
594 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Comments posted to this topic are about the item The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers