T-SQL Tuesday #190–Mastering a New Technical Skill
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great invitation that is near and dear to my heart: mastering a new or existing technical...
2025-09-09
77 reads
Blog Posts
From Chaos to Clarity: How Microsoft Purview Streamlines Data Governance
In today’s digital landscape, data is both a strategic asset and a potential liability. Organizations are generating vast amounts of information across cloud platforms, on-premises systems, and hybrid environments....
2025-09-08
668 reads
Get required permissions for DMVs
Part of my job at work is to update Transact-SQL reference content. System dynamic management views (DMVs) have permissions that are managed in the SQL Server Database Engine source...
2025-09-08 (first published: 2025-08-23)
260 reads
Getting Started with the MSSQL AI Agent in VS Code
Recently I was working in VS Code and I saw a walkthrough for the new Copilot chat features. I decided to give those a try in trying to get...
2025-09-08
510 reads
Summer Speaking Summary 2025
In the blink of an eye, summer has passed. I don’t know about you, but I’m ready for things to get back to “normal” after 10 weeks of events...
2025-09-08
18 reads
Why DBAs Still Need to Know the Foundations of SQL Server
Over the years, I’ll admit, SQL Server has come a long way in making life easier for database administrators and with each version it keeps getting better and better....
2025-09-08 (first published: 2025-08-19)
503 reads
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates HammerDB benchmarking for SQL Server using Docker. If you’ve ever needed to run TPC-C or...
2025-09-06
218 reads
Advice I Like: Praise
Don’t reserve your kindest praise for a person until their eulogy. Tell them while they are alive when it makes a difference to them. Write it in a letter...
2025-09-05
862 reads
Cosmos DB vs Traditional SQL: When to Choose What
From where I stand, the decision between Cosmos DB and a traditional SQL database often wants to be chosen between a sports car and a reliable sedan. Both will...
2025-09-05 (first published: 2025-08-18)
678 reads
Power BI dataflow Gen1 needs Gateway to connect to Azure SQL DB
I’m in the progress of migrating some legacy stuff at a client, and in their Power BI environment there are still quite some Power BI dataflows Gen1. I had...
2025-09-05 (first published: 2025-08-20)
365 reads
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
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...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
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
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