UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
394 reads
Blog Posts
What’s that SSIS Password
From time to time it is necessary to find a way into an SSIS package that is password protected. This article will help you find your way in to...
2017-10-30
47 reads
What’s that SSIS Password
A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that...
2017-10-30
1,360 reads
A Pretty PowerBi Pester Results Template File
I have left the heat and humidity of Singapore where I have been presenting at the PowerShell Conference Asia and...
2017-10-29
603 reads
Columnstore Indexes – part 114 (“Machine Learning Services”)
Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the unsung...
2017-10-29
713 reads
It’s All About The Joins
One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too...
2017-10-29
528 reads
Monday Night Networking Dinner 2017
It’s on! Free registration at EventBrite.
I wrote last month about not being able to make it to Seattle on Monday...
2017-10-29
595 reads
The #SQLSAT Speaker Goodie Bag
Last summer, I heard about an awesome idea for speaker gifts at SQLSat Pensacola 2017 from organizer Karla Landrum and...
2017-10-29
619 reads
Create a Login in a SQL Server Availability Group
Situation In SQL Server Availability Groups (AG), Logins must have the same SID (Security identifier) on all the nodes where...
2017-10-28
375 reads
Data Visualization Panel at PASS Summit
Next week is PASS Summit 2017, and I’m excited to be a part of it. One of the sessions in...
2017-10-28
370 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
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
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
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