SQL Lunch One Year Anniversary
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
422 reads
SQLDownSouth
Maintain Change Data Capture Configuration when restoring a database
I have been working with a several clients that are leveraging Change Data Capture (CDC) as a tool for incrementally...
2010-10-03
1,347 reads
SQL Saturday #57 (Houston) Call for Speakers and Registration is Open!!
So many people have been waiting for a SQL Saturday in Houston and now it’s finally here. As a native...
2010-10-03
719 reads
SSIS: Assign a value to Variable using Dataflow Script task
I am not quite sure how many of you have tried to set or change the value of a variable...
2010-09-19
4,751 reads
Baton Rouge SQL Server User Group Tonight
Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group. My topic was SSIS-...
2010-09-15
524 reads
Where do you get your motivation and drive?
I was asked by someone the other day, where do you get your drive and motivation? For a second, I...
2010-09-06
649 reads
MDX Puzzle #7 - Solution
Puzzle #7 had an interesting twist. You were required to add a column to the result set that dynamically displayed...
2010-09-03
595 reads
Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)
Join me for Lunch - SQL Lunch #33 (Indicators, Sparklines and Databars)
#33-SSRS 2008 R2 - Indicators, Sparklines and Databars
Speaker: Patrick LeBlanc
Add To...
2010-08-30
1,697 reads
MDX Puzzle #7
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up...
2010-08-29
477 reads
MDX Puzzle #6 - Solution
Puzzle #6 should not have presented too much of a challenge, it's intentions were to introduction you to the ORDER...
2010-08-27
496 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