Scale-out SSRS (a brain dump)
So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...
2018-02-06
410 reads
SQL Awesomesauce
Absolute computer fundamentals: the command line!
So I’ve spoken to more than one DBA who is not familiar with using the command prompt (aka command line)...
2018-01-02
387 reads
RegEx in SSMS: A gift for quick code
I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought...
2017-12-28
716 reads
PowerShell for fun (and profit?)
Let's have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.
The post PowerShell...
2017-11-15
385 reads
Session: T-SQL’s Hidden Support Feature
Today I presented one of my favorite sessions - T-SQL's Hidden Support Feature - for the DBA Fundamentals group! They'll put up...
2017-11-14
352 reads
Five reasons to be a technology speaker
I don’t think everyone should be a technical speaker. But I wouldn’t object if everyone spent a season trying. Why be a...
2017-11-08
359 reads
Attend “T-SQL’s Hidden Support Feature” online September 11!
I’m presenting T-SQL’s Hidden Support Feature for the DBA Fundamentals virtual chapter on Monday, Sep 11 at 9:30 PM CDT! Session description: The most effective...
2017-09-06
379 reads
Tech news: Your phone screen is a dirty rotten spy
Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic...
2017-08-29
393 reads
That thing you want to do? Do the thing.
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
682 reads
Celebrate! Second Anniversay Giveaway (is now over)
Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a...
2017-07-18
329 reads
Blogs
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
A Note and a Message: T-SQL Tuesday #193
By Steve Jones
This month Mike Walsh hosts T-SQL Tuesday. It’s been quite some time since he...
More fun with Git: git restore
The setup My day job involves babysitting a lot of Git repositories hosted on...
Forums
This doesn't make sense to me - making me crazy - er
Hi So I have the below select query that won't return results if I...
Catalog max connection pool size: 100
Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
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