A SQL Server query is suddenly running slowly, for no obvious reason. Grant Fritchey shares a 5-point plan to help you track down the cause and fix the problem.

Hacking the DTSX (SSIS XML file) to Change Defaults

by Steve Rezhener

SQLServerCentral

Introduction According to Microsoft, DTSX is an XML-based file format that stores the instructions for the processing of a data flow from its points of origin to its points of destination, including transformations and optional processing steps between the origin and destination points. In a nutshell, when you are creating your SSIS package, the SQL […]

Your Code Is Your Standards

by Steve Jones

SQLServerCentral

software development

Your code should look like you want it to look.

Checking for Missing Module References in a SQL Server Database Using Flyway

by Additional Articles

Redgate

Vendors/3rd-party Products

There are certain checks that need to be done after a database migration is complete. One good example of this is the check that a migration script, such as one that merges changes from a branch into main, doesn't cause 'invalid objects' (a.k.a. 'missing references') in your databases. I'll show you how to run this check, using sp_RefreshSQLModule, and incorporate it into a Flyway "after" migration script.

Exploring the Capabilities of Azure Synapse Spark External Tables

by Additional Articles

MSSQLTips.com

Azure

In this article we explore additional capabilities of Azure Synapse Spark and SQL Serverless External Tables.

Key findings from the 2021 State of Database DevOps report

by Additional Articles

Redgate

Vendors/3rd-party Products

Redgate has just published the 5th annual State of Database DevOps report, In this blogpost, Andrea Giardina explores key insights across four trends: DevOps adoption, performance & DevOps, the rise of cloud & cross-database, and the impact of the pandemic.

Scripts to Automate Creating and Loading a SQL Server Table

by Additional Articles

MSSQLTips.com

T-SQL

Use these T-SQL strategies for dropping, creating, and populating tables in custom schemas across different SQL Server versions from SQL Server 2019 back to SQL Server 2005.

Comparing Two Geospatial Series with Python

by Prashant Tyagi

SQLServerCentral

Learn how to use Python and pandas to compare two series of geospatial data and find the matches.

Email Issues with SQLServerCentral

by Steve Jones

SQLServerCentral

We are experiencing some email issues with our sender. There are some spam reports for our newsletter, which are causing us issues. If you have any questions, please contact the webmaster@sqlservercentral.com.