Combine Multiple SQL Server Query Results with Registered Servers
Learn how to configure and use SQL Server Management Studio to do run the same query against many different SQL Servers and consolidate the results.
Customizations in SQL Prompt
In this brand new course on the Redgate University Grant Fritchey walks you through the many ways in which SQL Prompt can be customized to suit your specific needs.
When Do We Ask for Help?
When do we ask for help? It's a tough balance to strike between asking too soon or waiting too long.
Power BI Smart Narrative
A new feature in Power BI is the Smart Narrative that allows you to add a textual narrative to your reports to help provide additional information to the user.
Why is my SQL Server Query Suddenly Slow?
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
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 […]
Checking for Missing Module References in a SQL Server Database Using Flyway
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
In this article we explore additional capabilities of Azure Synapse Spark and SQL Serverless External Tables.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCU SUBANG Telp:Cs,0817781222
Wa:0817781222 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Alamat Kontak Resmi BCA KCU DAGO Telp:Cs,0817781222
Wa:0817781222 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
BCA KCU BEKASI Telp:Cs,0817781222
Wa:0817781222 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers