Introducing Milestone Notifications
Your website is a product of your hard work and passion. Therefore, when your site hits a milestone — it shouldn’t go unrecognized. To make it easier for you...
2021-04-14
18 reads
Blog Posts
Modern Data Warehouse & Reverse ETL
An extension to the Modern Data Warehouse (MDW) that I have heard a bit about lately is called “Reverse ETL”. Before I describe what that is, first I wanted...
2021-04-14 (first published: 2021-04-12)
856 reads
Running Scripts in Parallel with SQL Multi Script
One of the lesser known tools in the Redgate Toolbelt is SQL Multi Script. While few customers used it, those that did loved it, as it solves a problem...
2021-04-14 (first published: 2021-04-05)
468 reads
Become a Contributor to Microsoft Docs
Starting this month, I'm leading a talk series with my teammates from the SQL Docs team at Microsoft. In this presentation we lay out just how easy it is,...
2021-04-13 (first published: 2021-04-08)
187 reads
Daily Coping 13 Apr 2021
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...
2021-04-13
37 reads
Help Build an Amazing Summit in 2021
For a good portion of my career, I’ve been going to the annual Summit in the fall with lots of my fellow SQL Server/Data Platform professionals. I have been...
2021-04-13 (first published: 2021-04-07)
139 reads
T-SQL Tuesday #137–Notebook Uses
It’s actually my month to host T-SQL Tuesday, and I came up with the notebook idea last year. Aaron Nelson (b | t) sent me a link to a...
2021-04-13
54 reads
#TSQL2sday #137 Invite Using Notebooks Every Day
It’s time for the T-SQL Tuesday blog party, and I’m hosting this month. I don’t host too often, but since I had some schedule mix ups, I’ll handle this...
2021-04-12 (first published: 2021-04-06)
345 reads
Daily Coping 12 Apr 2021
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...
2021-04-12
22 reads
Extended Events: Embrace the XML
While XML is, without a doubt, a giant pain in the bottom, sometimes, the best way to deal with Extended Events is to simply embrace the XML. Now, I...
2021-04-12 (first published: 2021-04-05)
242 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
BCA KCU PASURUAN Telp/Wa: 0817839777
Cso Bca: 0817839777 Jl. Soekarno Hatta No.33, Trajeng, Kec. Panggungrejo, Kota Pasuruan, Jawa Timur...
BCA KCU MALANG Telp/Wa: 0817839777
Cso bca: 0817839777 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa...
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...
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