Blogger questions: What if someone else wrote about the same subject?
I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a...
2016-02-03
564 reads
Kenneth Fisher
The CONNECT permission
The CONNECT permission exists at the instance and database levels. Note: as of SQL 2012 it is CONNECT SQL at...
2016-02-03 (first published: 2016-01-27)
3,020 reads
Reusing schedules in SQL Agent
I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor...
2016-02-01 (first published: 2016-01-25)
1,501 reads
What is RESULT SETS?
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before...
2016-01-26 (first published: 2016-01-14)
7,933 reads
Start SQL Server without tempdb
tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter.
While at the...
2016-01-20
10,515 reads
Ad-hoc Changes
TSQL Tuesday #74: Be The Change
Each month, on the first Tuesday of the month, the announcement for the blog...
2016-01-18 (first published: 2016-01-12)
1,530 reads
To the page and back again
To the page
It’s not one of those things you have to do frequently but every now and again you need...
2016-01-18
538 reads
MSDTC Requirements for SSIS Transactions
MSDTC is frequently required when using transactions within SSIS. And not just when you are connecting to two SQL Server...
2016-01-12 (first published: 2016-01-06)
3,665 reads
Do you check for TRUSTWORTHY databases as part of your security audits?
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do...
2016-01-06 (first published: 2015-12-30)
2,470 reads
2015 a year in review
It’s a new year, so time to look back at the previous year, and forward to the next. I’ll tell...
2016-01-04
442 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