Change Data Capture
I started working through some labs for my SQL Server 2008 class and one of the labs was on the...
2008-02-12
1,148 reads
Blog Posts
Computed Columns Published on SSC
I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level...
2008-02-12
440 reads
Speaker Eval Form, Part 2
My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've...
2008-02-12
975 reads
Init from Backup Published on SSC
This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it...
2008-02-11
337 reads
Kalen Delaney SQL Server Internals DVD
I did end up pre-ordering the first DVD on SQL Server internals by SQL Server MVP and SQL Server internals...
2008-02-11
1,355 reads
Making Sponsorship Work at Community Events & User Groups (My Wish List)
This topic came up during the speaker reception at the South Florida Code Camp and while I've posted here and...
2008-02-11
791 reads
Next oPASS Meeting is Feb 12
For those of you in Orlando our next meeting will be held on Feb 12 from 6-8 pm at the...
2008-02-11
507 reads
SQLSaturday Tampa 2008 is This Weekend (Feb 16)
The Tampa crew of Wes Dumey and Pam Shaw and many volunteers have been working on this for the past...
2008-02-11
559 reads
The Right Font
I was doing some development on my laptop tonight and I was getting fed up with the default font, Courier...
2008-02-09
3,604 reads
Do It My Way
Actually more it's "our way" as mentioned in Andy's post, and less my way than by committee these days with...
2008-02-08
798 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
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