The effect of VLF size on shrinking the log.
I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided...
2013-08-29 (first published: 2013-08-26)
2,631 reads
SQLStudies
Lots of ways to UNPIVOT a table
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated...
2013-08-21
1,314 reads
sp_SrvPermissions
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it...
2013-08-19
1,391 reads
sp_DBPermissions
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last...
2013-08-14
1,406 reads
“My transaction log is too big!”
“My transaction log is too big!” I wish I had a dime for each time phrase has been spoke, written,...
2013-08-12
1,662 reads
How are COALESCE and ISNULL different?
At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2)...
2013-08-16 (first published: 2013-08-07)
8,880 reads
Database Permissions Queries
Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup?...
2013-08-05
1,426 reads
Using DTEXECUI to generate a DTEXEC command line statement the easy way
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,701 reads
Notes on debugging Database Mail problems
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of...
2013-07-29
1,390 reads
I’m going to my first SQL Saturday!
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
661 reads
Blogs
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Flyway Tips: Automation Assistance in Flyway Desktop
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
Forums
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
Used Car Dealerships Near Me – Recommendations Needed
Hi everyone, We are selling cars and have a range of options at our...
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers