Check Those Settings
Recently, I was tasked with “enhancing” a third party application. This third party application (TPA) outputs a bunch of files...
2017-03-30 (first published: 2017-03-16)
2,266 reads
SQL Swimmer
Next Stop, SQL Saturday Richmond
I can’t believe it’s almost time for SQL Saturday #610. I’ll be there presenting What is Power BI? If you...
2017-03-11
330 reads
Triad Developers Conference – My Debut
I did it! I did my first “real world” presentation this morning at the Triad Developers Conference in Winston-Salem. What...
2017-03-10
332 reads
Speaking at Triad Developer’s Conference
I am honored to have been recommended by a colleague and selected as a speaker for the Triad Developer’s Conference...
2017-02-09
360 reads
Pesky Percent File Growth
As DBAs we all know setting your file growth to grow by percent is not optimal. It can cause all...
2017-01-31
727 reads
My First SQL Saturday – As A Speaker!
I am so honored and excited to have been selected to speak at SQL Saturday Richmond on March 18, 2017.
I...
2017-01-31
607 reads
How to Exclude Entire Sections in VS Schema Compare
Right now I am so excited, and a little embarrassed. After using Visual Studio (VS) for database projects for the...
2017-01-23
6,080 reads
So Long, Farewell, I Hate to Say Goodbye
The Sound of Music is one of my all time favorite movies. It reminds me of some great times with...
2016-10-12
507 reads
SQL Saturday Charlotte is Coming!
That’s right, SQL Saturday Charlotte is coming September 17, 2016. Next to the annual PASS Summit, this is my favorite...
2016-09-01
389 reads
SQL Server 2016, Database Mail and .Net 3.5 Framework
There were so many cheers when Microsoft announced that the .Net 3.5 Framework was no longer a pre-requisite for installing...
2016-06-30
3,156 reads
Blogs
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
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...
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