Remember OBJECTPROPERTY(..) when investigating objects.
The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the...
2011-01-20
1,301 reads
Blog Posts
SSMSDeploy 1.1 Now Available
Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and...
2011-01-20
713 reads
Tips & Tricks for DBAs Writing Their First Article
I have been writing full or part-time for nearly 30 years, and I have written and edited hundreds of articles....
2011-01-20
1,363 reads
31 Days of SSIS – SQL Server Configuration (18/31)
31 Days of SSIS
The last post in the 31 Days of SSIS talked about the use of environmental variables. As...
2011-01-19
2,215 reads
How to find the SQL server port number
Advertisements
One day I got a call from my junior DBA. She asked me, how can I find out the port...
2011-01-19
575 reads
New Book: Introduction to SQL Server
Last year, Kevin Kline (blog | twitter) introduced me to Oracle and database expert, Bert Scalzo. Bert was looking to take...
2011-01-19
599 reads
New PASS Chapter in Orlando–MagicPASS
Kendal Van Dyke is launching a new PASS Chapter called MagicPASS in Orlando this week, with the first meeting on...
2011-01-19
684 reads
SSMSDeploy Now Available!
I have finished my website, done all my recompilations, checked all my settings, and finally SSMSDeploy is on the internet,...
2011-01-19
606 reads
Time To Get Your #SQLRally Vote On!
It’s week two of voting for the upcoming SQLRally. This week, we are voting for the Database & Application Development sessions...
2011-01-19
453 reads
Un-SQL Friday: Your Tech Giants
This started as just a regular blog…but it’s sparked such a big conversation online, I’ve decided to make it an...
2011-01-19
1,087 reads
Blogs
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...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
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