Decoded Statistics Names and More
Auto-generated statistics names can seem like they are entirely random, but there is a method to the madness. With a little effort and a bit of TSQL trickery, we...
2020-05-04 (first published: 2020-04-17)
622 reads
Blog Posts
Improved Windows Terminal Setup
I’ve long been a Cmder/ConEmu user for Windows as it’s provided a much-needed improvement of the standard Windows terminal.
I’ve started trying to use the newer Windows Terminal project to...
2020-05-04 (first published: 2020-04-20)
362 reads
SQL Homework – May 2020 – Forum Lurking.
A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among ... Continue reading
2020-05-04
27 reads
Stairway to Microsoft Azure SQL Database Part 2 : Purchase Models DTU vs vCore
In the last post, we have discussed about different deployment options available with Azure SQL server. I hope you got a good understanding of various deployment models. In this...
2020-05-03
15 reads
Stairway to Microsoft Azure SQL Database Part 2 : Purchase Models DTU vs vCore
In the last post, we have discussed about different deployment options available with Azure SQL server. I hope you got a good understanding of various deployment models. In this...
2020-05-03
726 reads
ASF 031: Paul Andrew interview
Introduction Paul Andrew. Principal consultant and architect at Altius specialising in big data solutions on the Microsoft Azure cloud platform. Data engineering competencies include Azure Data Factory, Data Lake,...
2020-05-02
5 reads
Data Community #DataWeekender Europe 2020: Ethics in Modern Data
On Saturday May 2 Christine and I are presenting at the Data Community #DataWeekender Europe 2020 online conference, an all-online free virtual popup Microsoft Data Conference hosted by various professionals...
2020-05-02
18 reads
Be warned: The way I’m feeling right now I might actually give you sysadmin when you ask for it.
You want sysadmin permissions in production? And your manager has approved it so I shouldn’t have any problems giving it ... Continue reading
2020-05-01 (first published: 2020-04-20)
696 reads
Coding Standards Gone Bad in SQL Server
Knowing your data is very important when it comes to writing code. Now I’ll admit that I am very far from being a developer, however as a DBA, I...
2020-05-01 (first published: 2020-04-21)
1,044 reads
Daily Coping 1 May 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-05-01
17 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