(for your reading pleasure, written by Jules. –ed) We have all had that sinking feeling of defeat: you’ve just finished explaining a very important and highly technical thing to...
2023-07-05 (first published: 2023-06-20)
416 reads
“Work Smarter, not Harder” We’ve all heard it before, pretty much any job, anywhere. In our DBA slice of the IT world, this is very relevant to how we...
2023-05-08 (first published: 2023-04-28)
518 reads
If you need to find the SQL Server ErrorLog in a hurry and don’t want to spend 30 minutes drilling into every drive on the server: “I don’t watch...
2022-11-21 (first published: 2022-11-01)
262 reads
Query multiple SQL Server instances at one time! Thanks for watching! Kevin3NF Follow @Dallas_DBAs
The post SQL Server Registered Servers appeared first on DallasDBAs.com.
2022-11-09 (first published: 2022-10-28)
460 reads
I blogged about this in August, but wanted to do this video as well: Thanks for reading and/or watching! Kevin3NF Follow @Dallas_DBAs
The post Organize Your Tabs in SQL Server...
2022-11-02
146 reads
As a CIO or CTO, one of your primary responsibilities is to ensure that your organization’s data is managed effectively and efficiently. To do this, you need to have...
2022-09-14
29 reads
How long has this worked, and why didn’t anyone tell me? A typical restore statement from a FULL backup and a LOG backup: USE [master] RESTORE DATABASE [XE_demo] FROM...
2022-05-11
47 reads
(This post written by Jon Biggs (t), one of our Senior DBAs) We are currently performing migrations with upgrade of multiple-instance SQL Servers to new servers. The migrations are...
2022-03-22
50 reads
This is not another IRL post, but rather is more of “Help, my SQL Express database is full!” post. I was contacted by a lawyer that was using a...
2022-01-12 (first published: 2021-12-30)
329 reads
I was chatting with Jeff (b|t) on my team yesterday and the context escapes me but I had this thought: “Can you Group By the beginning characters, or a...
2021-10-29 (first published: 2021-10-22)
505 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
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