December Question: When reflecting on this year, what has gone well, and what would you do differently?
December is the last month of the year, and is often a good time to reflect on the past year...
2011-12-01
1,183 reads
Speaking in Colorado Springs
I’m probably going to have to put together a new SQL video, because I’ve been accepted to speak at SQL...
2011-12-01
569 reads
SQL Table variable and temporary table
Table variables and Temporary tables are used interchangeably – but they were designed for different purposes.
Temporary tables were designed for storage...
2011-12-01
1,763 reads
The process could not read file due to OS error 3
When configuring a subscription to a publication in SQL Server, on initialization it is common to encounter the error:
The process...
2011-11-30
43,344 reads
December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out to participate in the local User Group for SQL...
2011-11-30
14 reads
December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out...
2011-11-30
1,635 reads
PASS Board Elections
Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look...
2011-11-30
2,333 reads
Using OFFSET and FETCH
Introduction
Many times while developing our applications we feel the need of pagination, where our User Interface (UI) has to list...
2011-11-30
9,809 reads
Buffer Size in SSIS
Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in...
2011-11-30
16,643 reads
Forgiving Mistakes
My main phone line at the house has been on the fritz for about 3-4 weeks. Yes, we still have...
2011-11-30
2,439 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
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...
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers