Can Log Shipping Work Without Shipping the Log?
When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:
Backup: Performs a backup log...
2015-04-02 (first published: 2015-03-30)
6,890 reads
Blog Posts
Connect the Nots
Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered...
2015-04-02
622 reads
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a dacpac I use SSDT and tSQLt in my work...
2015-04-02
1 reads
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a...
2015-04-02
29 reads
Generating tSQLt tests from a dacpac
UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a...
2015-04-02
43 reads
Generating tSQLt tests from a dacpac
Generating tSQLt tests from a dacpac
I use SSDT and tSQLt in my work and I am always interested in productivity...
2015-04-02
1,277 reads
Monitoring SQL Agent Jobs when you work for Mr Krabs
For those of you who don’t know who Mr. Krabs is, he is a character in the TV show Sponge...
2015-04-02
534 reads
Mr. Fox SQL Blog…
So I’ve decided that its finally time I took a bite out of the magic apple and started doing some Blogging. Starting a blog has been on my mind...
2015-04-02
6 reads
Mr. Fox SQL Blog…
So I’ve decided that its finally time I took a bite out of the magic apple and started doing some...
2015-04-02
477 reads
New Blogger Challenge 1 – Adding a Primary Key
The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to...
2015-04-02
807 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers