Working with the registry from within SQL Server
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the...
2017-08-30 (first published: 2017-08-16)
3,680 reads
Blog Posts
You might be a DBA if
I’d been trying to think of a fun post to write and an homage to Jeff Foxworth’s You might be...
2017-08-30
1,876 reads
Database Fundamentals #8: All About Data Types
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how...
2017-08-29
647 reads
Database Fundamentals #8: All About Data Types
SQL Server provides all different kinds of data types in order to give you more flexibility and control for how...
2017-08-29
1,427 reads
Power BI Custom Visuals Class (Module 64 – Dot Plot MAQ Software)
In this module you will learn how to use the Dot Plot Custom Visual by MAQ Software. The Dot Plot...
2017-08-29 (first published: 2017-08-17)
1,561 reads
Power BI Custom Visuals Class (Module 66 – Calendar by Tallan)
In this module you will learn how to use the Calendar Custom Visual by Tallan. The Calendar Visual provides a...
2017-08-29
821 reads
Tech news: Your phone screen is a dirty rotten spy
Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic...
2017-08-29
394 reads
The 10 Basic Concepts of T-SQL
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the...
2017-08-29
1,369 reads
The Game Night Poll
This year we’ve handed off Game Night to the PASS organization and it’s an official event. Volunteers from the community...
2017-08-29
637 reads
Warning! Are your queries vulnerable to SQL injection?
Watch this week's video on YouTube
Looking for a script to find possible SQL injection vulnerabilities on your server? Scroll to the bottom of this post.
OWASP names SQL injection as...
2017-08-29
20 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