Boemo Mmopelwa in Tools Boosting Database Development Efficiency Using AI SQL Code Generators Database development has become more complex over the years due to the introduction of new data and storage formats by... 20 September 2024 11 min read
PowerShell Greg Moore in PowerShell Building an ETL with PowerShell There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to... 22 September 2021 11 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Connecting to a SQL Server Docker Container Running in macOS Since SQL Server is supported in containers, you can now run a SQL Server instance in your macOS without dual-booting... 22 June 2020 14 min read
Editorials Kathi Kellenberger in Editorials Key Insights from the 2020 State of SQL Server Monitoring Report This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This... 20 May 2020 3 min read
PowerShell Greg Moore in PowerShell SQL Server and Undocumented Extended Procedures Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented... 03 March 2020 11 min read
Tools Edward Pollack in Tools Knowledge Sharing with SQL Notebooks SQL Notebooks, based on Jupyter Notebooks, is one of the best things about Azure Data Studio. In this article, Edward... 03 March 2020 16 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Managing SQL Server Docker containers in macOS In the second article of this series, Carlos Robles explains how to manage Docker images and containers.… 21 January 2020 11 min read
Editorials Kendra Little in Editorials SQL Server Management Studio is as Relevant as Ever After fifteen years of heavy usage by developers and DBAs, it might seem like Microsoft’s free tool, SQL Server Management... 24 September 2019 3 min read
Containers and Virtualization Carlos Robles in Containers and Virtualization Creating Your First SQL Server Docker Container in macOS The use of macOS by developers and IT professionals has gained popularity the past few years. Running a sandboxed SQL... 13 May 2019 14 min read
Database Administration Prashanth Jayaram in Database Administration Mount SQL Server DMVs and Custom Queries Using DBFS on Linux With SQL Server now supported on Linux, traditional SQL Server DBAs will need to learn how to work with Linux,... 20 March 2018 14 min read
Tools Robert Cain in Tools A Walk Around SQL Operations Studio SQL Server Management Studio has been the default tool for working with SQL Server for over a decade. It’s not,... 18 December 2017 13 min read
Tools Grant Fritchey in Tools Automated Database Provisioning for Development and Testing If your development team needs to work on anonymised copies of the current production database, and if changes are being... 02 August 2017 10 min read
Tools Richard Macaskill in Tools Clone, Sweet Clone: Database Provisioning Made Easy? One of the difficulties of designing a completely different type of development tool such as SQL Clone is that you... 21 June 2016 8 min read
Phil Factor Automatically Creating UML Database Diagrams for SQL Server SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in... 03 May 2016 20 min read
Edward Elliott Connected Development with SQL Server Data Tools Although SQL Server Data Tools (SSDT) encourages 'disconnected' database development, it also provides the SQL Server Object Explorer (SSOX) tool... 26 January 2016 8 min read
Edward Elliott SQL Server Data Tools (SSDT) and Database References SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database,... 16 November 2015 12 min read
Phil Factor Routine SQL DML Testing for the Unenthusiastic Tester There are more exciting things in life than unit testing SQL Statements, checking the results, timings, and execution plans. Phil... 03 November 2015 16 min read
Adam Aspin SQLXML Bulk Loader: The Sequel SQLXML isn't exactly new technology, and parts of it aren't pretty, but if you need to heave vast quantities of... 25 September 2015 24 min read
Adam Aspin SQLXML Bulk Loader Basics SQLXML isn't exactly new technology, but like the even more venerable BCP, it remains the quickest and most reliable way... 02 June 2015 26 min read
Grant Fritchey SQL Enlight for SQL Server Management Studio The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that... 10 December 2013 17 min read
