Identity Crisis
I’m sure most people have identity values lurking somewhere in their databases. In fact I would guess that most people...
2012-05-02 (first published: 2012-04-25)
2,469 reads
Blog Posts
One Week from SQLRally!
SQLRally is a week away (pre-cons start on Tuesday, conference starts on Thursday). I have the privilege of two sessions to...
2012-05-02
845 reads
Presenting at SQL Saturday 119 Chicago!
First thing in the morning Saturday May 19th:
I will be presenting with my colleague from House of Brick David Klee...
2012-05-02
559 reads
SQL Server Indexed Views Explained
Indexed views are a really powerful and possibly underused feature of SQL Server. It’s basically a way of writing a...
2012-05-02
52 reads
SQLFriends in Minneapolis
Ever wanted to hang out and talk about SQL Server over lunch? Maybe get a chance to ask those questions...
2012-05-02
618 reads
Automatic page repair with SQL Server Mirroring
Now and then my colleagues and I find our selves in the middle of a discussion about SQL Server Mirroring...
2012-05-01 (first published: 2012-04-24)
3,202 reads
Checking Your Main BIOS Version
As some of you may know, I spent four years in the U.S. Marine Corps back during the Reagan administration....
2012-05-01
1,768 reads
Creating a Sequence in SQL Server 2012
Sequences are a new object in SQL Server 2012 that generate just what the name implies: a sequence of numbers....
2012-05-01
2,933 reads
Denali — Day 1: Tempdb Compatibility – Bug?
Denali — Day 1: Tempdb Compatibility – Bug?
I have installed sql server 2012 express and evolution edition on my personal laptop, and...
2012-05-01
463 reads
How to Configure Database mail
In my daily job as a SQL Server consultant I go to a lot of places, many days on the...
2012-05-01
8,445 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