how to get ahead
Many people have ideas as to how to do well in life. Of course, many people do not even agree...
2012-12-05
1,641 reads
should I use clustering on a VM?
ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
If you want prescriptive...
2012-11-28
883 reads
thanks for Bud
My Dad died horribly three weeks ago in a fall after the power got knocked out during Hurricane Sandy. I...
2012-11-22
826 reads
blogging fun: dealing with spammers like Psychz Networks
@PsychzNetworks is spamming me non-stop. Every minute of every day.
I googled them and it seems Psychz Networks are famous for...
2012-11-21
1,504 reads
[video] Inside Tempdb - Bob Ward
Boris Hristov shared this with me ages ago and I still haven't watched it yet (it is a few hours...
2012-11-20
2,477 reads
Bob Duffy
ok, everyone has their favorite SQL guru and favorite SQL tips. There are some people whose names you associate with...
2012-11-19
920 reads
circle of trust
I have heard it said that a former US President once remarked "People tell you who they are by their...
2012-11-16
662 reads
"fail fast" vs calligraphy
If you are a person inspired by ideas, you have probably encountered the concept of "fail fast". You probably also...
2012-11-15
687 reads
problem solving: sometimes you need to walk away from a problem to solve it
If anyone is a believer in solving challenges through sheer force of will, it's me. I'm a stubborn man and...
2012-11-14
723 reads
How to obtain the version and license for a Red Gate SQL BACKUP install
/*
here is a little script I've hobbled together that I use to get version and license info for a Red...
2012-11-13
1,151 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