Thank you!
I won’t be able to make it to the PASS Summit this year but I still consider myself part of...
2014-03-19
677 reads
Kenneth Fisher
Start with stupid
True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked...
2014-03-17
575 reads
:CONNECT in SSMS
Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...
2014-03-13
1,438 reads
T-SQL Tuesday #52: Keep your head down!
It is T-SQL Tuesday again and this month we are taking the road less traveled. Michael J Swart (b/t) has...
2014-03-11
1,290 reads
Impersonating a server level permission
Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s...
2014-03-07 (first published: 2014-02-26)
2,548 reads
Characters you should never ever use in an object or schema name!
You can put pretty much any character you want into an object or schema name by enclosing the name in...
2014-03-05
727 reads
Using SQLFiddle
SQL Fiddle is a free website that you can use to demonstrate and save a query example in any one...
2014-03-03
3,046 reads
What’s the difference between a temp table and a table variable?
I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...
2014-02-24
1,099 reads
Finally added a (t) to my (b)
I feel like an old man opening a computer for the first time but I’ve finally signed up on twitter....
2014-02-20
506 reads
DBA Myths: An index on a bit column will never be used.
Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...
2014-02-19 (first published: 2014-02-17)
2,618 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
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...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
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...
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