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.
2019-09-26
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.
2019-09-26
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
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!
2019-09-24
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
Since many of you choose to host a blog on Wordpress, here are a few things to think about when securing your site. Some of these might also be things you check for your other applications accessing SQL Server.
2019-09-23
2,865 reads
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
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.
2019-09-20 (first published: 2003-08-26)
73,967 reads
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
i have sqlexpress on rds, is there any way i can get notifacation that...
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers