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,300 reads
Blogs
Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell
As AI continues to evolve, many of us are looking for ways to leverage...
Monday Monitor Tips: Finding the Hostname for Queries
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Can AI Read Execution Plans?
Yeah, yeah, second AI post in a row. I promise not to make a...
Forums
Size of DB on physical disk doesn't match Disk Usage by Table report
Hi everyone I am looking at the size of my db on disk (ie...
Getting the TEXTSIZE
Comments posted to this topic are about the item Getting the TEXTSIZE
The Return to the Office Debate
Comments posted to this topic are about the item The Return to the Office...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers