Additional Articles

SQL Change Automation 4.0: Collaborative Database Development Across Visual Studio and SQL Server Management Studio

by Additional Articles

Redgate

SQL Change Automation

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

New: SQL Monitor 9.1 - control and refine the alerts for your growing estate

by Additional Articles

Redgate

SQL Monitoring

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

Sort Alphanumeric Values in SQL Server

by Additional Articles

MSSQLTips.com

Learn SQL

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

Discuss

Using PowerShell to Generate Logins, Server and Database Permissions

by Additional Articles

SQLServerCentral

PowerShell

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-09-24

New Redgate University Courses to Advance your Skills

by Additional Articles

Redgate

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

PowerShell and Secure Strings

by Additional Articles

SimpleTalk

PowerShell

Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.

2019-09-23

Learn the fundamentals of Redgate Products

by Additional Articles

Redgate

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

SQL Server Permissions List for Read and Write Access for all Databases

by Additional Articles

MSSQLTips.com

database permissions

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

How to Stop a SSIS Package Execution from Code

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

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

Backup Techniques Available Exclusively When Using Azure VMs

by Additional Articles

SQLServerCentral

Backup

Learn backup techniques available exclusively when using Azure VMs to host SQL Server-based workloads.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2019-09-18

All authors

Additional Articles

SQL Change Automation 4.0: Collaborative Database Development Across Visual Studio and SQL Server Management Studio

New: SQL Monitor 9.1 - control and refine the alerts for your growing estate

Sort Alphanumeric Values in SQL Server

Using PowerShell to Generate Logins, Server and Database Permissions

New Redgate University Courses to Advance your Skills

PowerShell and Secure Strings

Learn the fundamentals of Redgate Products

SQL Server Permissions List for Read and Write Access for all Databases

How to Stop a SSIS Package Execution from Code

Backup Techniques Available Exclusively When Using Azure VMs

Blogs

A New Word: Gnossienne

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

Forums

When the Token Meter is Zero

Understanding Temp Tables and Table Variables in SQL Server

The Data API Builder MCP Server Tools

Question of the Day

The Data API Builder MCP Server Tools