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,382 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,706 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,486 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,906 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,078 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,755 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,018 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
728 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,048 reads
Managing & Professional Development Classes
I've been working on a rough outline for two new classes that will each be one day long. One on...
2008-05-18
504 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers