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.
2019-09-25
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.
2019-09-25
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.
2019-09-24
You may have seen our getting started courses which show you the fundamentals of your Redgate tools. If you are already up to speed and using the tools then you may want to revisit the site as we have added some exciting new courses for SQL Change Automation and SQL Test. These courses aim to give you tips, tricks and ideas on how to utilize your tools to their full potential.
2019-09-23
Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.
2019-09-23
Redgate invite you to look around their newly refurbished University. If you are new to their tools there are simple, easy to follow courses to get you up and running, and if you are a long-time customer you can check out the recently added courses which take you through some more technical tips, tricks and troubleshooting
2019-09-20
In this tip we look a script to find SQL Server logins and database users that have read or write access to any database in the instance.
2019-09-20
In this tip we look at a way to stop the execution of a SSIS data flow task that is running by executing an outside process to stop the data flow immediately.
2019-09-19
Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.
2019-09-18
In this we look at how we to quickly split up data from a SQL Server table into relatively equal size buckets.
2019-09-17
By Steve Jones
If it fails where you thought it would fail that is not a failure....
By Kevin3NF
Some of the best career enhancers you can buy. Why I Go to...
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
Comments posted to this topic are about the item A Place where AI Technology...
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers