Using SQL Source Control projects in Azure Data Studio
David Atkinson describes how developers who were previously writing and managing SQL source code in SSMS can make a smooth transition to Azure Data Studio.
2020-07-09
Additional Articles
Simple Database Development with SQL Change Automation
SQL Change Automation makes automation simple enough that it can adapt to suit many different approaches to SQL Server database development. Phil Factor describes a project to update the Pubs database, using it in combination with a PowerShell function and to maintain in source control the build scripts, migration scripts and object-level scripts, for every version of the database.
2020-07-08
Using a Public Web Service to Consume SQL Server Build Numbers
Keeping SQL Server instances patched can be a time-consuming task for DBAs. In this article, Alejandro Cobar explains how he created a service in Azure that anyone can use to retrieve the build information for SQL Server.
2020-07-08
Automating Oracle Database Deployments using the Hybrid Approach
Learn how to use the 'hybrid' approach in the Deployment Suite for Oracle to automate Oracle database deployments. In this approach, the team maintains the current state of the database in version control during development, then, at key stages, generates and tests the migrations script that will be used to deploy the new database changes safely.
2020-07-07
Monitoring SQL Server with PowerShell Core Object Setup
In this series of tips we will introduce PowerShell scripts with T-SQL code that can be used to monitor your SQL Server environment. This first set of scripts creates the core objects needed for this solution.
2020-07-07
How to Create an Ubuntu PowerShell Development Environment – Part 3
Running SQL Server in a container may seem daunting at first, but it’s easy once you understand the handful of commands needed. In this article, Robert Cain demonstrates how to run SQL Server in a Docker container on Ubuntu.
2020-07-06
SQL Server Licensing and SQL Monitor
How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use SQL Monitor to find out.
2020-07-06
Azure Data Factory vs SSIS vs Azure Databricks
In this article we cover some things you should consider when determining whether to use Azure Data Factory, SSIS or Azure Databricks.
2020-07-03
The importance of remote monitoring
Monitoring should be able to happen no matter where you are located. This year organizations around the globe had to adapt to many new challenges including a distributed workforce and managing their estate when they can’t be in the office. This blog outlines the reasons and benefits of adopting remote monitoring.
2020-07-03
Easily manage SQL Server licensing with SQL Monitor 10.1
SQL Monitor 10.1 now gives you a comprehensive overview of your SQL Server licensing, so you know which licenses are in use, and which versions are on which servers. This simplifies license auditing and lets you unearth misconfigurations that could potentially cost you money. The new version also integrates with Microsoft Teams and Splunk, and supports complex Active Directory environments.
2020-07-02
Blogs
SQL Server 2025 RegEx and AI
By Steve Jones
One of the language changes in SQL Server 2025 that I’ve seen a lot...
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Forums
Columnstore index question
Hi experts, I’ve been going through several articles and videos about Columnstore indexes, but...
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Member was not found in the cube when the string
Hey, I've not done a cube for many years but I find myself supporting...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers