Upcoming Engagements
I haven’t been blogging lately because I’ve been busy tweaking my resume, working on PASS SQLRally, serving at church, and spending...
2011-03-07
633 reads
Blog Posts
XQuery for the Non-Expert – Aggregates
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2011-03-07
1,255 reads
In summary - SQLskills internals.
Well, I attended a full week of SQL internals from Paul Randal [Blog | Twitter] and Kimberley L. Tripp [Blog | Twitter]...
2011-03-06
500 reads
Leading Wildcards Aren’t A Good Default
SQL Server has LIKE, which lets us do various pattern matches, but most commonly we use the percent side as...
2011-03-05
1,171 reads
SQL Server Hardware Selection Presentation from Rocky Mountain Tech Trifecta
I just wanted to post a link to my presentation on Hardware 201: Selecting and Sizing Database Hardware for OLTP...
2011-03-05
511 reads
Back from the MVP Summit
Back home after three days in Seattle at the 2011 MVP Summit. As I wrote in an editorial this week,...
2011-03-04
441 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes. There was a lot of good feedback from that....
2011-03-04
6 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes....
2011-03-04
516 reads
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Jump on the SQLExpress – Useful info, ways to schedule and run maintenance jobs
Sometimes, folks come to me, and ask for...
2011-03-04
5,051 reads
March PASSMN Meeting Announced
Come one, come all to the March PASSMN meeting – that’s the Minnesota SQL Server User Group. This month we’re going...
2011-03-04
659 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