How to Resolve Merge Conflicts in Git for SSIS Projects
In this part of the tip, we'll show you how to simulate a merge conflict when using Git for an Integration Services project.
Optimize SQL Server estate monitoring with Redgate's SQL Monitor
How can we balance our need to monitor SQL Server performance and operational processes across hundreds of SQL Servers, but also save time by focusing on the highest priority issues?
Analyze Azure Cosmos DB data using Synapse Link and Power BI
Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]
Reassess Your Configuration
It's a good idea for anyone managing systems to periodically check them and see if anything needs to change.
Database version control: Getting started with Flyway
Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works
How to Check SQL Server Version When Service is Not Running
In this article we look at several ways to find the version of SQL Server that is installed when the SQL Server service is not running.
Data Element Names and Scoping Rules in SQL
How you name data elements in databases and applications programs has often been a matter of personal taste. Decades ago, when I worked for state government, there is a COBOL programmer who would pick a theme for his programs. The paragraphs and variables would be named based on the current theme. One of his programs […]
The Responsibility for Bugs
Today Steve wonders who should be responsible for software bugs, something of which we have no shortage of in our industry.
Import Data from PDF to SQL Server
In this article we look at how we can use R and SQL Server to import lottery numbers from a PDF document into a SQL Server table.
Masking Data in Practice
Phil Factor takes a strategic look at common SQL data masking techniques, and the challenges inherent in masking certain types of sensitive and personal data, while ensuring that it still looks like the real data, and retains its referential integrity, and distribution characteristics.
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers