Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory
This article discusses the data flow formatters, Flatten, Parse, and Stringify, which can be useful when dealing with JSON data.
DevOps is Mostly About People
Steve says the secret to DevOps is teamwork, which means that people matter. The tools help, but the humans determine the success level.
Metrics that matter for IT organizations on an agile journey
Measuring the wrong things is worse than not measuring anything. In this article, Mallika Gunturu explains the right things to measure for agile.
Searching a Flyway Database
As a database gets larger, and development more complex, so it becomes increasingly necessary to be able to search for strings in the source files and the database itself. Maybe you need to find when a table first got created, when a foreign key was added, or to find out which tables lack documentation. I'll show you how to answer these sorts of questions by running simple 'wildcard' searches on your Flyway migration files, or source files, as well as more targeted searches on certain parts of your database model.
Stairway to Columnstore Indexes Level 3: Building The Columnstore
The performance increase columnstore indexes grant when reading data from the index is offset by the expensive process required to build the index. In this Stairway level, Hugo Kornelis walks you through the steps SQL Server takes when building (or rebuilding) a columnstore index.
Database DevOps: Standardize, Automate, Monitor & Protect
See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.
Python Built-in Statistics Functions using SQL Server Data
Learn how to use statistical functions in Python with data from a SQL Server database along with several different examples.
Business Analytics from Application Logs and SQL Server Database using Splunk
Learn how Splunk can be used to get information from application logs or a SQL Server database.
Look Beyond What You See
One of the sales managers at Redgate Software posted an origin story about how he came to work at Redgate Software. It's an interesting story, and while I don't work in sales or have the same origin story, I don't know that I could have seen the place I'm in now early in my career. […]
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 KALIMALANG Tlp/Wa:0817839777
Tlp/Cs: 0817839777 Jl. Tarum Barat Blk. E No.5, RT.4/RW.10, Wil. Kota, Kec. Duren Sawit,...
Alamat Kantor BCA KCU SITUBONDO Telp:0817839777
WhatsApp: 0817839777 Jl. Diponegoro No.68, Palraman, Dawuhan, Kec. Situbondo, Kabupaten Situbondo, Jawa Timur 68311
Alamat Kantor BCA KCU TUBAN Telp:0817839777
WhatsApp: 0817839777 Jl. Panglima Sudirman No.35, Baturetno, Kec. Tuban, Kabupaten Tuban, Jawa Timur 62314
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers