Old DBA Trick To Confirm SQL Server Connectivity
“What’s wrong with the database?" or “I can’t connect to SQL Server” How many times have you heard phrases like...
2009-12-09
960 reads
Blog Posts
On Conciseness...
I had the privilege of writing a guest post on Mike Walsh's blog, entitled:
Conciseness
It's simply about being concise in our...
2009-12-09
779 reads
OPASS December Meeting Recap
This was the first meeting where I really lead most of the meeting. Andy Warren (@sqlandy) did the networking at...
2009-12-09
365 reads
Updating Software on the Blackberry Bold
Had a message waiting on my phone this morning that there was a system upgrade available. Interesting, think it’s the...
2009-12-09
232 reads
Windows Home Server – Setup and Installation
I wrote an editorial last summer asking people what type of protection they had for their home setup. I got...
2009-12-09
706 reads
Age calculation with SQL Server
There seem to be many different methods being suggested to calculate an age in SQLServer. Some are quite complex but...
2009-12-08
1,130 reads
Are trivial plans cached?
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on...
2009-12-08
1,232 reads
ASK SQLServerCentral
We've had the ASK SQLServerCentral site up for a couple months now and while I see traffic continuing over there,...
2009-12-08
593 reads
Database Books
Well my theory on posting every week has been tested to the limit somewhat and I didn’t get anything written...
2009-12-08
450 reads
December Patches
I note these for Database Weekly, but I haven’t blogged about them. A mistake on my part.
The December patches from...
2009-12-08
499 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