SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and...
2014-09-22
11,616 reads
MSSQLFUN
Cumulative Update – 12 for SQL Server 2012 Service Pack 1 Is Now Available !
The 12th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes...
2014-09-17
9 reads
Cumulative Update – 2 for SQL Server 2012 Service Pack 2 Is Now Available !
The 2ndcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released...
2014-09-17
12 reads
Cumulative Update – 12 for SQL Server 2012 Service Pack 1 Is Now Available !
The 12th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2014-09-17
534 reads
Cumulative Update – 2 for SQL Server 2012 Service Pack 2 Is Now Available !
The 2ndcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support...
2014-09-17
2,327 reads
Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite...
2014-09-15
15 reads
Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want...
2014-09-15
492 reads
How to Start SQL Server in Single User Mode ?
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc. Steps to start...
2014-09-04
14 reads
How to Start SQL Server in Single User Mode ?
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master...
2014-09-08 (first published: 2014-09-04)
43,855 reads
Cumulative Update – 3 for SQL Server 2014 RTM Is Now Available !
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the...
2014-08-26
11 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU DARMO Telp/Wa:0817.839.777
CSO BCA 0817839777 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur...
BCA KCU JEMBER Telp/Wa:0817.839.777
CSO, BCA. 0817839777 Jl. Gajah Mada No.14-18, Kelurahan Jember Kidu, Jember Kidul, Kec. Kaliwates,...
BCA KCU INDRAPURA Telp/Wa:0817839777
CSO BCA : 0817839777 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
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