Generate RESTORE LOG statements
Today, we're going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files,...
2018-06-06
811 reads
Blog Posts
Getting Called Up
When baseball players are called up to the Major League from the Minor League it’s referred to as getting “Called...
2018-06-06
278 reads
Power BI with Mapbox and Volcanic Ring of Fire
(2018-May-27) With recent Hawaiian volcano activity, it would be interesting to see how other similar events have shaped our Earth planet....
2018-06-06 (first published: 2018-05-27)
2,492 reads
Speaking at PASS Summit 2018
I am honored to have been selected to be a presenter at this year’s PASS Summit coming up this November....
2018-06-06
293 reads
Speaking at PASS Summit 2018!
I found out a few days ago that one of my sessions was selected for Summit this Fall - I will...
2018-06-06
280 reads
The June 2018 SQL in the City is coming
We’ve got the schedule up and you can register today. Once again I’m heading to the UK, along with Grant,...
2018-06-06
1,162 reads
T-SQL aside: replace PRINT with RAISERROR
I was minding my own business innocently reading a blog post by Erik Darling, when this tip smacked me in...
2018-06-06
1,147 reads
Understanding the Role of SQL Server Agent in SQL Server
SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in SQL Server. It runs as a Windows service...
2018-06-06
19 reads
Understanding the Role of SQL Server Agent in SQL Server
SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in...
2018-06-06
3,967 reads
4 Ways To Define Lookup Values In A Query
Watch this week's video on YouTube
Occasionally you may need to create a lookup table of values for a single query. Building a permanent table of these values is a...
2018-06-05
29 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