Thoughts on Virtualization
I get a lot of questions about virtualization and really have few answers. At a high level it's not hard...
2008-05-25
1,682 reads
Blog Posts
Reminder: Midlands PASS Chapter Meeting with Brian Knight
Tuesday, May 27, 2008
Speaker: SQL Server MVP Brian Knight
The Midlands PASS chapter will hold a special meeting on...
2008-05-23
1,729 reads
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,952 reads
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,374 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,701 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,901 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,738 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,067 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
720 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers