2021-01-14
46,092 reads
Articles
Dynamic Power BI Slicer Using DAX Logic
Learn how to create dynamic data slicers in Power BI with this step by step example to show how this can be done.
2021-01-14
Getting your SQL Server Development Data in Three Easy Steps
Phil Factor takes a staged approach to generating development data, creating one project that simply copies data from an existing database, another that copies most data but generates any personal or sensitive data, and a third that starts from 'anonymized' data and then generates other columns entirely and increase the number of rows for testing.
2021-01-14
SQL Server 2012 Build List
A list of the builds of SQL Server 2012. Updated with CU16 for SP2 and CU8 for SP3.
2021-01-13 (first published: 2012-04-17)
52,016 reads
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.
2021-01-13
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?
2021-01-13
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 […]
2021-01-12
2,696 reads
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
2021-01-12
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.
2021-01-12
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 […]
2021-01-11
2,186 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers