Working from Home Effectively
Some of us have been lucky enough to have already been working from home (WFH) prior to the world events. This has allowed most of us the ability to...
2020-04-24
130 reads
John Morehouse | Sqlrus.com
Azure SQL Database: Great Choice for Modern Cloud Applications
Microsoft offers several options for moving your SQL Server workloads to Azure. If you’re looking to host modern cloud applications, your best option is Azure SQL Database Service. For...
2020-03-27
178 reads
Changing How I Write Abstracts
Sometimes a swift kick in the rear is needed to become motivated. Recently, I was the recipient of the business end of a boot and it drove me to...
2020-03-06
3 reads
Finding Foreign Key Child Records In SQL Server
Foreign keys help to ensure referential integrity between tables. In other words, parent records cannot be deleted if there are child records present. This is a great thing and...
2021-05-03 (first published: 2020-01-31)
520 reads
Changing MaxDop For Resumable Index Create Operations
I’ll admit it, sometimes I’m wrong. Recently I blogged about the usefulness of a newer feature that was enhanced with the release of SQL Server 2019. Resumable Indexes operations...
2021-04-23 (first published: 2020-01-17)
1,287 reads
Happy New Year!
Happy New Year!! Yes, I know it was two days ago but I’m still pseudo-on-vacation-not-really so just another simple blog post wishing you prosperity, health, and good tidings this...
2020-01-03
7 reads
Merry Christmas
Christmas was this week so nothing technical today, just a simple blog post wishing you and your family blessings and good tidings during this holiday time. May the holidays...
2019-12-27
57 reads
Data Virtualization in SQL Server 2019
Some of the most eagerly anticipated features now available in SQL Server 2019 relate to expanded data virtualization capabilities. Data virtualization enables you to bring all your data together...
2019-12-20
66 reads
Understanding Azure Geo-Redundant Storage
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-27 (first published: 2019-12-13)
306 reads
Understanding Azure Geo-Redundant Storage
While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery Strategies for the Data Platform. In that session, I talked about Azure storage and the...
2019-12-13
21 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