Visiting Boston This Week
I get busy and usually forget to post when I'm out and about, but for once I've remembered. I'll be...
2008-05-11
454 reads
Blog Posts
Possible interview questions for Intern/Junior DBA or Developer
I wrote these questions thinking about what some basic t-sql statements that I would want to see if I were...
2008-05-10
3,809 reads
A View Variable
I saw that Erland Sommerskag posted a Connect item that asked for a "View Variable" to be added to the...
2008-05-09
1,255 reads
A little fun with SSIS Expression Language
The SSIS expression language is a powerful yet enigmatic entity. Once you get used to its syntax - which is part...
2008-05-08
4,867 reads
Follow Up Notes on SQLSaturday #3
Our most recent SQLSaturday went well, but there is always room for improvement. Here are my notes from this event:
The...
2008-05-08
389 reads
Kindle Research - Procs and Cons with the Sony Reader
After the editorial on the Kindle, which got quite a few responses, I've continued to look around and research things....
2008-05-08
959 reads
ACM, 5 Year Anniversary, and Customer Service
Time moves by and I was surprised to get a coffee mug in the mail from ACM (Association for Computing Machinery)...
2008-05-07
479 reads
Thoughts on SQL Saturday in Jacksonville
I was able this Saturday to head down to Jacksonville and speak at the SQL Saturday there. There were a...
2008-05-07
722 reads
One More SQL Feature Wish
It would be handy to have a checkbox/SET option/something that would tell SQL not to cache plans run in a...
2008-05-06
404 reads
Photos from SQL Saturday
Check out the photos from SQL Saturday 3 - Jacksonville:
http://tim-mitchell.spaces.live.com/
2008-05-06
887 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