Prometheus
The myth of Prometheus has some relevance to technology workers. How? Read what Steve Jones thinks.
Check your SQL Server using Windows PowerShell – Part 5
This fifth installment of the “Check your SQL Server using Windows PowerShell” series illustrates how to access SQL Server instance properties and SQL Server configuration details using Windows PowerShell.
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
The Baker's Dozen: 13 Tips for SQL Server 2008 and SSRS 2008
SQL Server 2008 gets new developer features, and SQL Server 2008 Reporting Services gets a facelift and new architecture that no longer requires Internet Information Services.
DLP Technology
Steve Jones isn't talking about his new television, but rather a new technology dealing with data and databases.
The FILESTREAM Data Type in SQL Server 2008
There is a new data type in SQL Server 2008 that might help you deal with all those music, image, and other media files in SQL Server. FILESTREAM allows you to store these files in the file system, but access them from within SQL Server. New author Deepa Gheewala brings us a look at setting a table for FILESTREAM.
Changing the default SQL Server backup folder
Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?
Faking Arrays in Transact SQL
It is a simple routine that we all need to use occasionally; parsing a delimited list of strings in TSQL. In a perfect relational world, it isn't necessary, but real-world data often comes in a form that requires one of the surprising variety of routines that Anith Sen describes, along with sage advice about their use.
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