SQL Server 2008 R2 Diagnostic Queries from SQL Saturday #51 Nashville
Here are the diagnostic queries that I ran during my presentation at SQL Saturday #51 in Nashville on August 21,...
2010-08-24
1,203 reads
Blog Posts
SSSOLV: Twitter Compliant
This is just a short blast about the Las Vegas User Group called SSSOLV (Web | Twitter). I am not certain...
2010-08-24
504 reads
Twitter: The Next Best Thing To Being There
Why do DBAs want to go to PASS, TechEd, or SQLConnections? If asked, I suppose that many would point to...
2010-08-24
741 reads
Use ReadOnlyVariables and ReadWriteVariables properties in Scripts
For those of you just starting out with SQL Server Integration Services, you'll find a LOT of information out there...
2010-08-24
6,603 reads
DMV Emergency Queries From SQL Saturday #51 in Nashville
I wanted to post the first T-SQL script from my DMV Emergency Room presentation on August 21 in Nashville. This...
2010-08-23
1,717 reads
Estimating Data Compression Savings in SQL Server 2008 and 2008 R2
Since I finished upgrading the last of my Production environment to SQL Server 2008 R2 running on Windows Server 2008...
2010-08-23
3,118 reads
Fall Speaking Schedule
I just got back from speaking at SQL Saturday #51 in Nashville, which was a lot of fun. I’ll write...
2010-08-23
809 reads
Free SQL Server Training for the Week of August 23, 2010
Note: I got some of the dates mixed up, so I'm re-publishing this post.
Monday
SQL Lunch - Troubleshooting SSIS Package Development - Dustin...
2010-08-23
940 reads
Getting Drive Info Part 2, DTS
In this installment of the drive info series we will gather the drive information via a DTS package. Part 1...
2010-08-23
1,098 reads
Incremental Load - TSQL
For my first technical post in a short while I thought I would look at something I have worked on...
2010-08-23
11,039 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