Download AWS RDS SQL Server Backup
Learn how to create a backup of an AWS RDS for SQL Server database and download the backup file to use on another SQL Server instance.
2024-09-16
Additional Articles
Level up your learning in 2024 with PASS Data Community Summit
Connect, share and learn with the global data community in Seattle this November. Whether you're a DBA, Developer, Architect, Engineer or you're just getting started in your data career, there's a huge range of content for you to choose from (over 150 sessions and counting across 5 different tracks). Speakers this year include Steve Jones, Grant Fritchey, Ryan Booz, Bob Ward, Deepthi Goguri and Jennifer Stirrup. Check out the full program and register before September 18 to secure your ticket at the standard price.
2024-09-16 (first published: 2024-08-19)
Introducing the New Stars of Data speakers for PASS Summit 2024
Three new speakers will be taking to the stage at this year's PASS Data Community Summit for the New Stars of Data Track. Sessions will be delivered by Haripriya Naidu, Vitalija Bartusevičiūtė, and Jarid McKenzie!
2024-09-13
LIKE Constraints
In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK constraints to strengthen your data integrity.
2024-09-13
Event Streams for Persistent and Asynchronous Microservice Communication
This article looks at how you can use event sourcing to maintain persistent and asynchronous communication between microservices.
2024-09-11
Effective Strategies for Storing and Parsing JSON in SQL Server
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because of its heavy usage in applications today, it inevitably will make its way into databases where it will need to be stored, compressed, modified, searched, and retrieved.
2024-09-09
SQL ROUND Function vs. Bankers Rounding with T-SQL
Learn about rounding values using T-SQL and how the ROUND function works compared to creating a user-defined function for bankers rounding.
2024-09-06
I Must Be an Idiot: Automatic Tuning Never Works for Me.
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a smoke break rather than showing up for work.
2024-09-04
How to Slice Data by Fiscal Month using DAX for Power BI Reports
In this article, learn how to set the current fiscal month identity in a calendar table using DAX for Power BI when dealing with fiscal periods.
2024-09-02
Is it still worth it to sponsor PASS Summit?
Conference planning is underway. Several folks have asked me whether I think the PASS conference is still worth exhibiting. I thought an article would be best to break down my thoughts. I’m in an interesting position, being a marketing leader who also specializes in SQL Server and doesn’t work for Microsoft. I’ve worked directly for several companies in the ecosystem, so I know how difficult reaching the DBA market has been post-pandemic.
2024-08-30
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