Using the SSIS Script Component With Multiple Outputs
One of the more common questions I find in SQL Server SSIS forums is how to split apart a single...
2017-08-22
479 reads
Blog Posts
Adding a New Default to a Column
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21
493 reads
Automatic Seeding in Always On Availability Groups in SQL Server 2016
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-08-21
988 reads
Azure Automation and SQL Index Maintenance
Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...
2017-08-21
954 reads
Backup Log to Nul– #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-08-21 (first published: 2017-07-31)
1,724 reads
Deploy an SSIS project to the SSIS catalog.
You’ve installed SSDT, created an SSIS project, created any packages you need and now you want to place that project...
2017-08-21
840 reads
Microsoft Azure – How to Check the availability of cloud services using PowerShell
Hello friends, in this blog we will learn how to check whether a cloud service is available to use with...
2017-08-21
475 reads
Monday Coffee: Posting error messages
I posted a couple of messages on twitter over the weekend giving any new bloggers advice that was given to...
2017-08-21
286 reads
New eBook with Pure Storage – Overcoming SQL Server Storage Challenges
My company, Heraflux Technologies, is proud to announce a new ebook as part of our joint partnership with Pure Storage!...
2017-08-21
245 reads
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to...
2017-08-21
117 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
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
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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