Robert Hartmann

My name is Robert Hartmann. I am an M.Sc Computer Science graduate with a specialization in databases. I've worked as a DBA for 2 years now, and recently earned an MCSA certification in SQL Server 2012. My focus of interests regarding SQL Server lies in in-depth knowledge as well as query optimizing and tuning, though I also sometimes work with SSAS and SSIS. I try to be as simple as possible in my writing in order to reach as many interested readers as I can.
Outside of work, I have a beautiful son and am married enjoying my family. You can follow me on twitter, or simply subscribe to my RSS feed on http://dirtyread.de/.

All authors

All authors

Blogs

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

By

One of the first things I review when I inherit a new SQL Server...

AgentDBA vs Critical SQL Server

By

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

I’ve had a Dropbox account for years. Like a lot of people, I started...

Read the latest Blogs

Forums

identity increments by 10,000 when it was supposed to be 1

By stan

hi a peer of mine who ive never known to be wrong says a...

Displaying Money

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Displaying Money

The Slow Growing Problems

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Slow Growing Problems

Visit the forum

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 Euros

See possible answers