New Article: Exploiting SQL Server via CONTROL SERVER permissions
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,736 reads
I have a new article up at MSSQLTips.com, covering what someone can do with CONTROL SERVER. Most folks know to...
2012-02-27
1,736 reads
I just received great news that one of my sessions, Attacking SQL Server, was picked by the community for SQLRally....
2012-02-27
980 reads
Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...
2012-02-23
1,230 reads
I received great news last week that one of my sessions, Windows Operating System Internals for DB Pros, was accepted,...
2012-02-21
864 reads
Gone are the days when remote drives were easy to detect because there was some size to them. Nowadays USB...
2012-02-15 (first published: 2012-02-13)
2,211 reads
I've been asked this question a few times, and Columbia, SC isn't hosting a SQL Saturday this year. Bobby Dimmick...
2012-02-13
1,177 reads
For those who've asked, here are the slides and scripts from my SQL Server auditing webinar with Idera:
Presentation (.PDF)Scripts (.ZIP)
If...
2012-02-10
1,046 reads
Tomorrow at 3 PM Eastern I'll be giving a webcast in conjection with Idera and MSSQLTips.com:
Registration for Successfully Meeting Your...
2012-02-07
1,014 reads
So I went to present at Charleston PASS on Thursday night and of course I had my standard contact information...
2012-01-30 (first published: 2012-01-25)
2,005 reads
Another article has published over at MSSQLTips.com. This one covers how to identify what stored procedures are set to run when...
2012-01-30
937 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