SQL Saturday Baton Rogue Recap
Thank you to everyone who came out and saw me present at the SQL Saturday in Baton Rogue! It was a blast to see smiling faces and not be...
2022-09-09 (first published: 2022-08-23)
124 reads
Blog Posts
Daily Coping 8 Sep 2022
Today’s tip is to notice the things you do well, however small. I think I have a lot of room for improvement, and it’s easy to self-criticize and find...
2022-09-08
25 reads
A simple lab to demonstrate the danger of NOLOCKs in INSERT statements
The READ UNCOMMITTED isolation level, which the NOLOCK table hint activates, is not to be trusted when it comes to writing data. You are not always protected by error...
2022-09-07 (first published: 2022-08-25)
554 reads
Daily Coping 7 Sep 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-09-07
27 reads
Thinking about data points and more …
(2022-Aug-28) Going on a family vacation road trip always fills me with a myriad of happy emotions and expectations to explore new places, see new people and essentially be led...
2022-09-07 (first published: 2022-08-29)
185 reads
Daily Coping 6 Sep 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-09-06
22 reads
Daily Coping 5 Sep 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-09-05
24 reads
Database Fundamentals #33: Check Constraints from the GUI
The other types of constraints are referred to as check constraints. They limit the data by defining a logical operation that checks the state of the data prior to...
2022-09-05
21 reads
Log Shipping – Standby Mode
Hello, dear blog reader. This week’s blog is coming to you from the home office. Finally, my son is back in school, and the house has some peace. For...
2022-09-05 (first published: 2022-08-23)
304 reads
Why is security important in a dev environment?
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve ... Continue reading
2022-09-05 (first published: 2022-08-23)
240 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers