Architecture for Auditing
The way in which auditing is build into our systems isn't the best way to implement the practice.
Data Mining Part 28: Programming with AMO and VB
In this article we will use VB.NET to connect to our Mining Models.
Data Mining Part 28: Programming with AMO and VB
In this article we will use VB.NET to connect to our Mining Models.
The Importance of Database Indexing
In this article, James Munro demonstrates an example of a simple query without an index and then that same query again with the index. A simple introduction to database indexing.
What Not To Say
Steve Jones has some advice for data professionals today. These are a few things that your boss doesn't want to hear, and you probably don't want to say.
Query Folding in Power Query to Improve Performance
In this tip Koen Verbeeck discusses query folding, how you can take advantage from it and how to make sure query folding takes place.
Finding Production Drift
The changes made to production can be problematic at times. Steve Jones notes we can't prevent them, but we can look for them.
Cybercrime - the Dark Edges of the Internet
Criminal activity is a growing menace on the internet: This inevitably means more diligence is required by legitimate users in the face of an increasingly sophisticated criminal threat. Robert Sheldon describes some of the emerging threats and risks.
Take our SQLServerCentral Users Survey
Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.
The MidnightDBAs release Minion Backup
The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup. We created Minion Backup (or MB, for short) to be the most flexible, feature-rich backup solution possible.
Blogs
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
Forums
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Seeding a Fabric Warehouse with dbt for Visual Studio Code: The Fabric Modern Data Platform
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Doing the Little Things
Comments posted to this topic are about the item Doing the Little Things
Question of the Day
Historical Data Tracking
If I want to track historical data values, which mechanism should I use?
See possible answers