Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of...
2017-05-28
436 reads
Igor Micev
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
7 reads
Microsoft Certified Trainer!
For the first time in my career, I’m a Microsoft Certified Trainer (MCT). This title came as a result of my two-year working as a trainer at the Seavus...
2017-05-28
8 reads
Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three...
2017-05-10 (first published: 2017-04-29)
2,390 reads
Some stuff with Date and Time in SQL Server
I’m writing this post because I want to put some more stuff around dates and times in one place. I...
2017-05-09
1,066 reads
Some stuff with Date and Time in SQL Server
I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...
2017-05-09
10 reads
Some stuff with Date and Time in SQL Server
I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up...
2017-05-09
6 reads
Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...
2017-04-29
29 reads
Multiple usage of functions to ensure “value” is not null? – NO
In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three functions for a variable to ensure it never accepts...
2017-04-29
4 reads
Mixed page allocation
MIXED_PAGE_ALLOCATION is a new option introduced with SQL Server 2016. It controls whether the database can create initial pages using...
2017-04-08
5,809 reads
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
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...
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