Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your...
2009-07-01
10,021 reads
Blog Posts
Connector Editorial for July 1, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-30
1,516 reads
Querying the Procedural Cache on Canada Day (July 1st)
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources...
2009-06-30
2,444 reads
SSIS - Creating a Deployment Manifest
Using a Deployment Manifest in SSIS allows you to deploy a set of packages to a target location using a...
2009-06-30
42,024 reads
Tracking My Goals – Half the Year
I made a series of resolutions in January related to SQLServerCentral. These are things that I wanted to accomplish this...
2009-06-30
1,728 reads
Unwired for Days
Today is the first day that I've really had any significant time on the computer over vacation. That probably sounds...
2009-06-30
1,380 reads
Best Thing I Learned at PASS
At the 2003 PASS Summit in Seattle the organization had a "SIG Challenge" that involved developing a database solution to...
2009-06-29
1,369 reads
Featured Blog: Jeremiah Peschka
I met Jeremiah at the PASS Summit last year and since then I’ve looked in on his blog from time...
2009-06-29
1,697 reads
SQL Saturday #17 - Abstract Submitted
I was asked to attend SQLSaturday #17 in Baton Rouge, LA. Despite my lack of desire to travel, I've never...
2009-06-29
1,518 reads
LinkedIn Groups
I’ve written a few posts now about LinkedIn, and for now still find it be the best fit for me...
2009-06-28
1,556 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers