Enterprise Architecture – Connect-the-Dots for Adults, Part 4
This article, part 4 in a series, discusses how to use, publish, maintain and govern the enterprise architecture.
2008-01-29
3,259 reads
Strategies
Application Locks (or Mutexes) in SQL Server 2005
Application locks aren't a well known area of locking in SQL Server, but they can be very useful for special scenarios. They work in an analogous way to the lock() construct in .Net and are basicaly user defined mutexes in SQL Server.
2008-01-15
4,038 reads
Are key performance indicators a true measure?
Some managers love to look solely at numbers when assessing performance, and key performance indicators (KPIs) are right up their street. But how useful are they in the context of software development
2007-10-12
3,591 reads
Are you innovating?
Andy has some examples of not very high tech solutions that involve some technology behind the scenes, but the binding factor was that someone had to see the problem first, and it wasn't one of those show stopper type problems. It's not about SQL, but we think it is on topic.
2004-09-30
5,310 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers