Upcoming Presentations
I'll be attending the South Florida Code Camp on Feb 2 and also SQLSaturday Tampa on Feb 16th. For both...
2008-01-16
521 reads
Blog Posts
Covert It Live
I watch the Geekbrief update a few times a week, partially to see new gadgets and partially to see how...
2008-01-15
730 reads
SQL Server 2005 Replication bug?
Last week, in our production, we noticed some records are missing in the subscriber side while existing on the publisher...
2008-01-15
916 reads
E-Readers, Will They Ever Take Off?
I was discussing the Kindle recently with business partner Steve Jones and while we both like the idea of having...
2008-01-14
482 reads
Hot Subtract
Over the last few weeks I've seen a few posts about the new Hot-Add CPU feature in SQL Server 2008....
2008-01-14
786 reads
Evaluating Speakers at Events
Speakers tend to live for the evals. Hopefully it's a validation of work done well after a lot of time...
2008-01-09
905 reads
On the Importance of Documentation...
It seems that I keep inheriting old systems that provide a singular, albeit mission critical, function to their owners. In...
2008-01-09
531 reads
Sometimes You Need an Analog Solution, Sorta - Earth Class Mail
Spotted this on the Webware feed, Earth Class Mail is a service that opens and scans your regular mail so...
2008-01-09
496 reads
SQL Injection, Again!
Many posts including this one about as many as 70,000 sites being hacked using SQL injection and a vulnerability in...
2008-01-09
626 reads
Partitioning Part 3 Posted on SSC
Part looks at using views for partitioning, still a valid technique even in the SQL 2005 world. I added in...
2008-01-08
254 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers