2011-05-19
2,692 reads
2011-05-19
2,692 reads
I’m in a fun mood today, so a few silly items for you.
The last few weeks, Paul Randal (blog | @PaulRandal)...
2011-05-18
891 reads
Simon Sabin had his own take on increasing laptop speed. He had some good ideas, but he inspired me to...
2011-05-18
2,336 reads
What do yo do if you find malicious code in your system? Delete it? Steve Jones suggests that a honeypot might be a better idea.
2011-05-18
184 reads
Someone posted this query recently:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name = 'INSERT'
and
b.grantee_principal_id = a.principal_idThat’s a little ugly, so let’s fix...
2011-05-17
2,242 reads
Would you rather work longer hours or tackle harder work? Steve Jones comments today on a recent post by Seth Godin. The answer as to what most people prefer might surprise you.
2011-05-17
284 reads
I saw a post from Marc Beacom on the presentations this week for various groups. You can get the info...
2011-05-16
754 reads
If you are looking to move into management, do you need an MBA? It's nice, but Steve Jones notes that many people are realizing that an MBA doesn't necessarily prepare you to manage other people or lead them in a company.
2011-05-16
220 reads
2011-05-16
2,280 reads
I saw a post recently that had query that looked like this:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name...
2011-05-12
1,831 reads
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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