Living with DTS on SQL Server 2005 and 2008
The DTS support in SQL Server 2005 and 2008 is excellent (almost). Typically the packages and jobs do not need...
2009-11-02
1,336 reads
Blog Posts
Minor Setup Issue with SQL Server 2008 or SQL Server 2008 R2 on Windows 7
Microsoft’s Peter Saddow, who is a Program Manager on the SQL Server Setup team has a post in the SQL...
2009-11-02
427 reads
PASS Summit 2009 – Day -1
The official start date for the summit is Tuesday, but trust me, everything kicked off on Sunday when registration opened....
2009-11-02
364 reads
DB Audit Challenge #1
Take the DB Audit Challenge - Intermediate - DB Audit Challenge #1
For those of you who have been following my recent blogs,...
2009-11-01
1,194 reads
PASS Summit In-flight Note
I'm on a Delta non-stop flight from Atlanta to Seattle for the PASS Summit. This is the first time I've...
2009-11-01
1,277 reads
SQL PASS Summit 2009 – Day Zero
For me, today was the start of a six-day SQL Server adventure at the PASS Summit in Seattle. The day...
2009-11-01
712 reads
Stored Procedure Call Tree
I was reading a post by Linchi Shea in which he demonstrates a Perl script to Find the complete call...
2009-11-01
1,802 reads
Two Very Important Configuration Settings For SQL Server 2005/2008
Two settings that I always enable when I install SQL Server 2005 or 2008 on an x64 production database server...
2009-11-01
5,910 reads
Blogging From the 2009 PASS Community Summit
Like a lot of other SQL Server bloggers, this week I will attempt to write regular blog entries each day,...
2009-10-31
1,383 reads
Not Attending/Presenting at SQL Connections
Given everything that has happened in the last couple of weeks, this is not surprising to those who have kept...
2009-10-31
1,379 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
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers