Whether you are a long time Redgate customer or have recently made a purchase you can find helpful and easy to follow video courses on Redgate University. With the brand-new look and the recently added courses you will soon be getting the most from your Redgate tools.
You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance requirements. In this article, Joshua Feierman explains how to set up the audit and collect the data in Azure Log Analytics when running SQL Server in an Azure VM.
SQL Change Automation's Development component for developing new databases and modifying existing databases, using migrations, now integrates directly into SQL Server Management Studio as well Visual Studio. It allows teams to collaborate effectively during development, regardless of their preferred IDE, and in a way that integrates easily with common build/integration servers and release management tools.
Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.
In this blog post Rebecca Woof walks us through the new features of SQL Monitor 9.1. With PowerShell API alerting and a new permissions table the latest release addresses challenges that come with a growing SQL Server Estate.
In this tip we look at ways to sort alphanumeric strings in SQL Server by decomposing all numeric values and sorting the string based on numeric sorting rules.
There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.
The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.
Are you working with Oracle databases or know somebody that is? Does a company or client that you are working with also have an Oracle counterpart? If so, we want to talk to you/them about how they are currently working. We are currently running an Early Access Program (EAP) for a migrations-based solution for Oracle users. Sign up today, get the beta release and let us know your feedback!
Discover how to reduce the pains you might have feel when migrating all the logins and associated permissions from one instance of SQL Server to another.
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
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