The Key at SQL Saturday #33
For the handover of SQLSaturday to PASS, Rushabh Metha, President of PASS, came to the Charlotte SQL Saturday, where Andy...
2010-03-10
915 reads
Blog Posts
Top 6 Myths of Transaction Logs
Top 6 Myths of Transaction Logs I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I...
2010-03-10
4,533 reads
Upgraded to Model
That's right, folks, I'm now a model. Or at least, a model DB. Tom LaRock released his most recent rankings and...
2010-03-10
569 reads
An Introduction to Data Compression in SQL Server 2008
This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008.
There is one thing every...
2010-03-09
1,279 reads
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
535 reads
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
352 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,536 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,019 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,159 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,361 reads
Blogs
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers