A Little Variety - WMV
Do we really need to corner the market for our particular business? Steve Jones talks about the need to grow your business at the expense of others.
Basic SQL Server security principles you can't afford to miss
Learn how using basic SQL Server security practices of least privilege, delegated administration and separation of duties will protect SQL Server databases.
Myths - iPod
Every profession has its share of myths about how it works. IT might have more than its share and Steve Jones comments on a few of them.
Myths - MP3
Every profession has its share of myths about how it works. IT might have more than its share and Steve Jones comments on a few of them.
Myths - WMV
Every profession has its share of myths about how it works. IT might have more than its share and Steve Jones comments on a few of them.
Test Data Generation with Data Dude
The Visual Studio 2005 Team Edition for Database Professionals (a.k.a Data Dude) was released somewhere around December 2006 helping many Database Administrators and Database Developers. The release was huge for us, because it addresses many issues faced by us.
The Backup Myth - WMV
Running backups is enough for disaster recovery, right? That's a myth that could get you into trouble. Steve Jones explains there's more that's needed.
First Look: SQL Server 2005 SP2 CTP
Service Pack 2 for SQL Server 2005 is not quite here, but Wayne Fillis brings us a look at what you can expect if you install the CTP version that is available now.
Losing Your Job
It's not easy to lose your job, but it can be done if you aren't performing. What concerns Steve Jones is someone recently lost their job for their behavior on their own personal time.
Partitioning - Part 3
Continuing on with his series on SQL Server table partitioning, Andy Warren takes a look at how partitioned views are handled when you query them.
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