I will be speaking at SQL Bits 2018
In two weeks from now, on 23rd of February, I will be speaking at SQLBits 2018! It’s my first time on the largest SQL Server conference in Europe for...
2018-02-09
2 reads
Cláudio Silva
- Website: https://claudioessilva.eu
Using dbatools to verify your SQL Server instances version compliance
One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service...
2018-01-23
724 reads
New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute
Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know...
2017-12-15 (first published: 2017-12-05)
2,477 reads
New version of sp_WhoIsActive (v11.20) is available - Deployed on 123 instances in less than 1 minute
Last night, I received Adam Machanic’s (b | t) newsletter “Announcing sp_whoisactive v11.20: Live Query Plans”.
For those who don’t know about it, sp_WhoIsActive is a stored procedure that provides...
2017-12-05
5 reads
Using Common Table Expression (CTE) - Did you know...
Today I will write just a short blog post to do a quick reminder!
I still hear a lot of people suggesting CTEs because they think it works like a...
2017-11-30
1 reads
Using Common Table Expression (CTE) – Did you know…
Today I will write just a short blog post to do a quick reminder! I still hear a lot of...
2017-11-30
698 reads
TSQL Tuesday #96: Folks Who Have Made a Difference
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
TSQL Tuesday 96: Folks Who Have Made a Difference
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about “folks who have made a difference” in our careers.
Thank you, Ewald! This is...
2017-11-14
1 reads
DELETE data on SQL Server HEAP table – Did you know…
Before I complete my question let me provide context. I've received an alert saying that a specific database could not...
2017-10-04 (first published: 2017-09-26)
2,673 reads
DELETE data on SQL Server HEAP table - Did you know...
Before I complete my question let me provide context.
I’ve received an alert saying that a specific database could not allocate a new page (disk was full)
The message that you...
2017-09-26
3 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
Testing whether TRY_CONVERT is losing precision
Hello All, I am using TRY_CONVERT to parse character data into a decimal column....
need help with assigning a value to a variable
Hi I am trying to assign the value of the variable using the output...
Merry Christmas 2025
Comments posted to this topic are about the item Merry Christmas 2025
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers