Performance Impact from Page Splits
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list...
2013-01-30
1,961 reads
Tim Radney - Database Professional
PASS Summit 2012 – Networking
I was fortunate to attend my 4th PASS Summit. For the past 4 years I have flown out to Seattle...
2012-11-20
677 reads
Instant File Initialization with TDE
If you are using Transparent Data Encryption TDE and have Instant File Initialization turned on, you are not getting the...
2012-11-13
953 reads
Scripting out users
Many of us know the importance of scripting out our users on a regular bases in order to be able...
2012-11-02
1,988 reads
SQL Backup and Recovery
I was very fortunate to have the opportunity to write a book for Joes2Pros on a topic that is very...
2012-11-01
574 reads
SQL in the City US tour begins tomorrow #sqlcity
The Red Gate SQL in the City US tour begins tomorrow in New York City. If you have not registered...
2012-09-27
1,433 reads
SQL Saturday 167
SQL Saturday #167 is just hours away. We have worked hard to get everything setup and in place and hope...
2012-09-07
579 reads
Reducing Your Storage Footprint Using SQL Storage Compress
I was asked to speak at SQL in the City in New York and Austin Texas. I have used many...
2012-09-06 (first published: 2012-09-04)
1,906 reads
SQL in the City – FREE Training
Is SQL in the City coming to a town near you? The events are being held in New York, Austin,...
2012-08-29
1,413 reads
When Things That Are Supposed to Protect You Try to Kill You
This past week I was presented with a very unique issue. A call came in with a production issue on...
2012-08-03
764 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