SQL Saturday in Orlando
The dates for Microsoft's TechEd 2008 are fast approaching here in North America. Sandwiched between the two weeks of this year's...
2008-05-23
1,948 reads
Blog Posts
Visiting Birmingham SQL Group in June
I'll be doing a presentation for the Steel City SQL Group on June 17 and then on June 18th I'm doing...
2008-05-23
1,372 reads
Hard Core Object Oriented Programming Guidelines
I read Andrew Binstock occassionally in SD Times and in the most recent issue he posted a list of guidelines...
2008-05-21
1,698 reads
Pop Quiz - What's the Max Number of Resultsets Supported by Management Studio?
Ran across this strange occurence while doing some testing. To duplicate the results (the actual code was a little more...
2008-05-20
1,479 reads
Review of How to Cheat at Securing SQL Server 2005
SQL Server MVP Frank Kalis has posted a short review on How to Cheat at Securing SQL Server 2005, a...
2008-05-20
1,899 reads
Answers To DBA Interview Questions
Here are your answers to the questions from last week You should get some variation of what I have given...
2008-05-19
2,732 reads
Answers To SSIS Interview Questions
This is just a starting point for you to prepare for your interview so make sure not to limit yourself...
2008-05-19
4,062 reads
Collation Issues
This is really interesting to me:
CREATE TABLE #TEMP (name varchar(80))
INSERT INTO #TEMP values ('Malteser Schloßschule')
INSERT INTO #TEMP values ('Malteser...
2008-05-19
714 reads
SSIS Interview Questions
I have decided to make a short series of blogs about possible interview questions to help you prepare for an...
2008-05-19
3,009 reads
Technical Podcasts I Listen To
There are a few podcasts I tend to listen to as I have time. Since I work with a wide...
2008-05-19
4,039 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