Paying Attention to Estimates
Aaron Bertrand follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
A Visit to Microsoft and SQL Server 2016
Today we have a guest editorial from Andy Warren as Steve is on vacation. Andy talks about a trip to Microsoft for the SQL Server 2016 launch.
Biml Academy 2 - Importing, Staging, and Loading Data
Next week are 5 more lessons on working iwth Bilm. Each day, Aug 15-19, at 1:00pm EDT.
SQL Server Stored Procedure to Compress Non Partitioned Tables
My SQL Server database has some very big tables that can be compressed. The tables are simple, non-partitioned tables and I want a quick tool to compress them. I
An object lesson about what is really important
A story I heard a long time ago reminds us to choose what is really important.
Executing Multiple Threads to Create a Load
Learn a few techniques for executing multiple sets of queries at once.
SSIS in SSDT: The Basics
SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially. Rob Sheldon provides a beginner's guide to get you started with using SSIS with Visual Studio and SQL Server Data Tools (SSDT).
Keyboard Hardlines
The potential vulnerabilities of wireless devices might be a security issue for databases.
Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes
Find out how to speed up your queries by indexing and partitioning data, U-SQL style.
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