SSIS Expressions Basics
For those that are new to SSIS, using expressions may seem very foreign and unpleasant. Not only is it a...
2009-07-23
865 reads
Blog Posts
The Kindle Flack
There have been so many reports and debates about the Kindle debacle in the news. I saw an interesting one...
2009-07-23
1,227 reads
Watch Your Repairs
Apparently PC repair people have learned a few things from auto mechanics of the past. A news group in the...
2009-07-23
622 reads
Database Mirroring - Hitting the Limits
When I first heard about database mirroring in 2004, I was excited. Here was a great new feature that would...
2009-07-22
4,385 reads
Featured Blogger: Glenn Berry
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
730 reads
Kindle Alternatives – B&N on Blackberry
I’m not a fan of Blackberry devices. Actually that’s not true, I really dislike them. They’re not intuitive, and I’ve...
2009-07-22
1,288 reads
My Virtual Lab setup Hyper-V 2008 and Virtual Server 2005 R2
One of the things I’ve maintained over the years is a lab to do everything I need. From testing new...
2009-07-22
3,537 reads
Replication Snapshot Errors Caused By Compatibility Level Setting
I ran across an interesting replication error recently that's worth sharing. It happened while using a distributor running SQL 2008,...
2009-07-22
455 reads
Barnes and Noble eBooks
I saw yesterday that Barnes and Noble released their e-reader for iTouch/iPhone, Blackerrys, Mac, and PCs and at the same...
2009-07-21
795 reads
Contest to Win a Free Trip to PASS
MSSQLTips & Idera are sponsoring a contest where the grand prize in an all expenses paid trip to the PASS Summit...
2009-07-21
711 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
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
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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