Data Mining Part 22: Analyze the Data Mining Data with Excel
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
Data Mining Part 22: Analyze the Data Mining Data with Excel
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
How Often Does Production Drift?
Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.
The Salesforce Platform: The Return of the Citizen Programmer
The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?
Generate SSRS reports from a SSIS Package
Learn how to invoke SSRS reports from an SSIS package after the data load is completed.
Real World T-SQL Tricks
This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.
Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask
It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.
Achievement Unlocked: Balance 0
Steve Jones completed a task this year that he's rarely completed in the past.
Distribution Database Migration
This article shows a step-by-step guide to move the distribution database to a new SQL Server instance.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers