#PowershellBasics: Powershell vs Powershell Core
I’m taking a Powershell class this week and I have to say the teacher is one of the best I’ve ... Continue reading
2019-10-10
361 reads
Blog Posts
Communicating Effectively at the Workplace
This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-10 (first published: 2019-10-08)
420 reads
Cool Stuff in Snowflake – Part 10: RATIO_TO_REPORT
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-10-10 (first published: 2019-10-02)
756 reads
GroupBy: SQL Server Admin Best Practices with DMV's
Thanks for the 40+ of you online for GroupBy 2019 North America, excited to have presented my DMV session for the audience.Big shoutout to Bob Pusateri's fantastic preceding presentation,...
2019-10-10
104 reads
2019-10-10
36 reads
2019-10-10
12 reads
Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
84 reads
Split data into N equal groups
In this blog post, you will get the query to “Split data into N equal groups” using SQL Server and you will also see the practical implementation of the...
2019-10-10
769 reads
Upcoming SQLpassion Online Trainings
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2019-10-10
7 reads
Weekly reading #28
September is over. This was not a good month for us. We had to cancel the conferences planned for September and were not able to write as much as...
2019-10-10
32 reads
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers