T-SQL Tuesday #31 – Logging
This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...
2012-06-12
1,050 reads
Marlon Ribunal - SQL, Code, Coffee, etc.
Getting started with SQL Server on private cloud
I have been invited to a private beta of SQLDirector by ScaleGrid. “SQLDirector is a MS SQL as a Service...
2012-06-06
1,534 reads
Review of “Start Here! Learn Microsoft Visual C# 2010?
Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.
If you’ve never seen a programming code in...
2012-06-05
1,079 reads
Are you ready?
I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...
2012-06-01
891 reads
Your SQL Server database just failed, can you restore the backup?
It’s one thing to be able to backup a database, it’s another thing to be able to restore it into...
2012-05-09
4,505 reads
On the road less traveled: a DBA Roadmap review
The story of why I came up with this blog is no secret to the few readers I have here. In...
2012-05-03
1,368 reads
Who are the sysadmins in this sql server?
Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...
2012-04-24 (first published: 2012-04-23)
33,092 reads
10 must follow blogs that might not be in your list
There are few memes going around in the SQL world. Probably the most popular of them is TSQL Tuesday (#tsql2sday)....
2012-04-16
1,760 reads
Limiting user access to your database
There are situations where you need to grant SELECT permission to a particular user and limit that access to a...
2012-04-11
2,505 reads
The evolving role of the database professional
The role of the database professional is quickly evolving to conform with the ever changing demands of the business world....
2012-04-04
1,222 reads
Blogs
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,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
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