Blog Anniversary
Two years old. In March of 2008 I received a whopping 96 visits. I’m up to 1900 so far this...
2010-03-09
537 reads
Blog Posts
Buying a Second Seat on the Plane
Saw this article about more elbow room, the premise being that is it is often cheaper to buy a second...
2010-03-09
356 reads
Easy Ways to Detect I/O Pressure in SQL Server 2008
It is pretty common for large, busy SQL Server instances to run into I/O bottlenecks. Even smaller, less busy systems...
2010-03-09
4,569 reads
Happy Belated International Woman's Day - C'est Votre Jour Les Femmes !
Yesterday was International Woman’s Day – Let’s take the time to honour a few great women at the top!
Firstly, to Her...
2010-03-09
1,032 reads
How to Easily Log SQL Server 2008 Instance Level Metrics
If you want to record the results of some useful, instance level DMV queries somewhere where you can easily query...
2010-03-09
1,177 reads
IO IO IO
Once again it is that time. It is TSQL Tuesday. This time it is being hosted by Mike Walsh. Mike...
2010-03-09
1,370 reads
My Adventures with the SQL 2005 Security Cache
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...
2010-03-09
506 reads
Solid State Drive Performance Hands-On: Part 1
(Punch it, Hurb
Yo, I don't think we should talk about this
Come on, why not?
People might misunderstand what...
2010-03-09
2,001 reads
Taking Advantage of SQL Server Tools
Reprinted from my editorial in Database Weekly.
An important question I think you should be asking yourself, when it comes to...
2010-03-09
350 reads
T-SQL Tuesday – I/O Fallacies
It’s time for the March T-SQL Tuesday and this month Mike Walsh picked the topic. It’s I/O and you can...
2010-03-09
469 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers