Current database vs database locks
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading
2019-07-22
300 reads
Blog Posts
Error: ‘misaligned log IOs which required falling back to synchronous IO’ And Slow AG Synchronisation
I recently hit this rather interesting issue when migrating a bunch of SQL Servers onto a nice, shiny new SAN. The plan was simple enough, take the secondary servers...
2019-07-22 (first published: 2019-07-08)
2,776 reads
2019-07-22
14 reads
Importance of Testing
I’ve always said if you’re running a script for the first time in a production environment, you’re doing it wrong. Testing is fundamental to technology, yet it is one...
2019-07-22
23 reads
Is That Database in Use?
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Finding Deprecated Uses in SQL Server November 7, 2016...
2019-07-22 (first published: 2019-07-03)
967 reads
Kubernetes Pipelines
This post continues looking at some of the Kubernetes concepts I’ve been learning with the 50 days of Kubernetes (K8s). Specifically in this post, I’m writing and thinking about...
2019-07-22
30 reads
Last Week Reading (2019-07-21)
Another week passed. Look what did I find during that time. Press British Airways faces record £183m fine for data breach The penalty imposed on BA is the first...
2019-07-22
19 reads
Moving Databases into Azure SQL Elastic Pools
Quite a simple requirement (when I needed it a few months ago). Study my Azure SQL database environment below. As you can see I have a standard elastic pool...
2019-07-22
31 reads
The Data platform has evolved – so too must the DBA.
This blog post is around the changing landscape of both SQL Server and the people who are our trusted guardians of it – DBAs. If you have been involved...
2019-07-22
285 reads
Top Modern Data Warehouse questions
Below are the top 15 questions I am seeing from customers looking to build a modern data warehouse in the cloud, and the blogs that I have wrote that...
2019-07-22
971 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