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

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.

The Multi-skilled Developer

by Phil Factor

SQLServerCentral.com

Editorial

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.

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.

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.

Is Data the Future of the Vibrant Web?

by Steve Jones

SQLServerCentral

Data Privacy and Protection

There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.

Stairway to SQLCLR Level 1: What is SQLCLR?

by Solomon Rutzky

SQLServerCentral.com

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.

Redgate need users looking to do CI/CD for Oracle Databases

by Press Release

Redgate

Oracle

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!

Using PowerShell to Generate Logins, Server and Database Permissions

by Additional Articles

Database Journal

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.

Best WordPress Security Practices for 2020

by anastasia.stefanuk

SQLServerCentral

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.

Working in Smaller Teams

by Steve Jones

SQLServerCentral

Career Growth

Steve likes working in smaller teams and has some thoughts on why this is important to him.

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

The Multi-skilled Developer

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

Sort Alphanumeric Values in SQL Server

Is Data the Future of the Vibrant Web?

Stairway to SQLCLR Level 1: What is SQLCLR?

Redgate need users looking to do CI/CD for Oracle Databases

Using PowerShell to Generate Logins, Server and Database Permissions

Best WordPress Security Practices for 2020

Working in Smaller Teams

Blogs

Five Ways Redshift Serverless Quietly Eats Your Budget

A Career of Memories

Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

Forums

Midjourney, Healthcare?

Changes, Happiness, and a Few Tears

BCP on Linux

Question of the Day

BCP on Linux