T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting it and have picked a topic that is near and dear to me. If you...
2020-04-07
54 reads
Blog Posts
COVID-19 - Work & Life Changes, How We're Coping
Settle in folks, this is a long, rambling post.
As this goes live, it’s been about three weeks since my abrupt switch from driving to the office every day to...
2020-04-06
8 reads
Daily Coping 6 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-06
15 reads
Error handling protip: @@Error resets after the next command
The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run ... Continue reading
2020-04-06 (first published: 2020-03-30)
381 reads
Getting Your dbatools Version–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was trying to test something recently and...
2020-04-06
166 reads
SQL Server and VMware Resource Pools
Resource pools are used to hierarchically partition available CPU and memory resources, and are available for use at the VMware host cluster layer. To better prioritize certain VMs over...
2020-04-06
71 reads
T-SQL Tuesday Live–7 Apr 2020
Last week went a little crazy, and I learned something: don’t post a Zoom link on Twitter. My apologies to anyone that wanted to join and had things go...
2020-04-06
12 reads
Understanding Disk Performance and IOPS in cloud platform
In the past many years, apart from working as DBA, I was working with multiple cloud technologies and actively involved in the migration process to cloud infrastructure. In between,...
2020-04-06 (first published: 2020-03-29)
2,900 reads
What Prevents You From Securing Your Servers?
Reading about how hackers are using SQL Server instances that are exposed on the internet AND have weak passwords to work into systems, I’m sitting here wondering why. I...
2020-04-06
75 reads
Disks performance in Azure
In our earliest post, we have discussed in detail about the factors that affect the disk performance and different types of disk offerings in the AWS platform. In this...
2020-04-05
14 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