Using a SSRS Report to run SQL Agent Jobs
Data Warehouse latency is often a complaint I have heard from end users when trying to access data via either...
2009-11-11
6,601 reads
Blog Posts
And the Winner is........
DB Audit Challenge #1
And the Winner is….
First, I want to thank everyone that participated in the DB Audit Challenge, and...
2009-11-10
816 reads
Article of the Week – Sanjay Mirsha (Data Compression)
Data Compression was introduced in SQL Server 2008. This feature helps compress data inside the database, thus potentially reducing the...
2009-11-10
722 reads
Looking Back – PASS Summit 2009 Day 2
Tuesday started early for me because I had to be at the bloggers table in time for the opening remarks...
2009-11-10
638 reads
PASS Summit 2009 – Overall Event
I thought that we got a great Summit from PASS in 2009. This week I’ll be looking back at some...
2009-11-10
699 reads
SQL Connections
I’m flying off to the SQL Server Magazine Connections part of DevConnections in Las Vegas later this afternoon. I’m presenting...
2009-11-10
560 reads
SQL Server MVP Deep Dives Book Signing at PASS
The PASS Community Summit is one of the highlights of my professional year. It’s a time when members of the...
2009-11-10
388 reads
SQL Server Wish: Last Logon Information
The other day my wife and I were driving around and noticed that a Little Caesar's location had shown up...
2009-11-10
8,739 reads
Time Management Quotes
A short post today, ran across http://www.lifeoptimizer.org/2007/03/08/66-best-quotes-on-time-management/ when I was looking for ideas for my Moo cards. Quotes are fun...
2009-11-10
493 reads
Closing Out PASS Summit 2009
I was up early again on Friday morning to have breakfast with Patrick Leblanc (SQLLunch man), and then off to...
2009-11-09
626 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
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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