Shameless Plug: My First SSC Article Published Today
Please forgive the shameless plug. My first article was published today on sqlservercentral.com. It’s titled “Backup and Housekeeping with Maintenance...
2011-01-26
554 reads
Blog Posts
SQL Saturday #71: Call For Speakers
The SQL Saturday #71/New England Data Camp #3 call for speakers has been open for quite a while. But, we...
2011-01-26
1,030 reads
SQLSaturday 57 In Houston, Here I Come!
Another year and staring it off right! I’ll be speaking at SQLSaturday in Houston, TX on the fundamentals of storage...
2011-01-26
944 reads
User Group Giveaway: My Latest Book
As I annouced earlier, Oracle and database expert, Bert Scalzo and I collaborated on an introductory text appropriately titled Introduction to SQL...
2011-01-26
704 reads
#SQLRally is coming, Go vote!
We are in the final stages of selecting the speakers for the SQLRally May 11th through the 13th in sunny...
2011-01-25
671 reads
31 Days of SSIS – One Package, Unlimited Databases (24/31)
31 Days of SSIS
Another day, another blog post all about SSIS in my continuing journey through 31 Days of SSIS. ...
2011-01-25
1,415 reads
A Banner Day for SQLRally
Help us promote our upcoming PASS events by including any or all of these on your blog or in your...
2011-01-25
727 reads
Backing up the log in simple mode
Someone posted a note saying that their backups were really large and slow. So they were trying to manage their...
2011-01-25
1,462 reads
Getting Started With Consulting Webcast Recording Now Available
If you missed my PASS Professional Development Virtual Chapter Webcast “Getting Started With Consulting” last week, it’s now available online.
I...
2011-01-25
806 reads
Internals Matter: Why You Should Check Your Page Verify Settings, and I Should Go to Masters Immersion Training (SQL Skills Contest Entry)
This post is about two things:
1) Your Page Verification Settings are Critical
You should confirm you are running with the correct...
2011-01-25
1,278 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