Isolation Levels–MCM Prep
I was watching the Isolation Levels video for my MCM prep and learned something about the isolation levels. I knew...
2011-01-17
1,328 reads
Blog Posts
Multi-subnet Failover Clusters
Multi-subnet Failover Clusters
I want to take a closer look at one of the new features in SQL Server Denali. While...
2011-01-17
4,709 reads
My Prize Has Arrived!
Back in November, I was lucky enough to be nominated and then got enough votes to win the New to...
2011-01-17
546 reads
Notes from SQLSaturday #62
The weekend started with a later afternoon drive to Tampa, returning a couple calls and then chatting with Steve Jones...
2011-01-17
620 reads
SQL Saturday SQLSaturday #62 - Tampa Review
For those who attended SQL Saturday #62 in Tampa I hope you enjoyed this free event.As I promised in the...
2011-01-17
1,266 reads
TechEd: Session Preference Survey
TechEd has listed some potential sessions for TechEd North America 2011 here: http://northamerica.msteched.com/sessionpreference?fbid=I1Ydc71JM4a. They want to know which sessions you...
2011-01-17
510 reads
Using the MERGE statement
I love MERGE. You know all those awful IF BEGIN END ELSE BEGIN END blocks you need to write for...
2011-01-17
4,085 reads
XQuery for the Non-Expert – @Variable Use
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In a...
2011-01-17
2,710 reads
31 Days of SSIS – 10 Things About Expressions (16/31)
31 Days of SSIS
Sixteen days in and we are past the half way point for the 31 Days of SSIS...
2011-01-16
997 reads
Check that what you expected is actually what you got - DB's and SQLCMD
I feel that it is wise move for a script to actually check itself that the database connection that is...
2011-01-16
1,397 reads
Blogs
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...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
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