Clustering data for insights
Clustering data gives quick insights into large unstructured data. In this article, Naveed Janvekar explains clustering and provides a quick demo.
Creating Flyway Migration Files using Redgate Schema Comparison Tools
How to use Redgate's schema comparison engines to generate object-level scripts for every database version that Flyway creates, and then use them to create ad-hoc, Flyway-compatible migration files.
What will convince you to upgrade?
You’ve probably heard that SQL Server 2022 is on the way, and, assuming the name doesn’t change, it will be later this year. That is great news for folks in the data platform community as features and improvements they’ve been hoping for are added. I’m not currently supporting any production SQL Servers, but I’m still […]
Azure Data Studio and Version Control
This article examines how you can use Azure Data Studio with your git Version Control System.
Gathering Data Through Life
Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than […]
Finding deeper insights with Topic Modeling
Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre walks you through an example using Python.
Webinar | Gain the competitive edge with a monitoring tool
Robust database monitoring is at the heart of ensuring business continuity, customer satisfaction and protected revenue, and this webinar with Chris Yates, Senior Vice President, Managing Director of Data and Architecture at Republic Bank, will clearly demonstrate why.
7 DB Forge SQL Studio Features Discovered in Less Than 2 Hours
dbForge SQL Studio gives you a few advantages over SSMS. See what Kenneth discovered during his first use of the tool.
Migrating a Large Database
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
SQL Server Crib Sheet Compendium
As a developer, DBA or manager, you may not really want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is with the 'jungle roof' view of each topic that this Crib Sheet compendium provides.
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers