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.
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.
Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools. There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data streams from MySQL databases, etc. Each data extract or report is created by a BI or DB Development Team member. Often […]
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.
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.
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.
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.
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Jl. Raya Sawangan No.32, Rangkapan Jaya, Kec. Pancoran Mas, Kota Depok, Jawa Barat 16436
Dekat, Jl. Imam Mahbud No.30 4, RT.4/RW.1, Duri Pulo, Kecamatan Gambir, Kota Jakarta Pusat,...
Komp. The High End City Korea Town, Jl. Kayu Putih Raya Blok D 3,...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers