Data Mining: Part 16 Automating Data Mining Processes
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
Data Mining: Part 16 Automating Data Mining Processes
In this chapter we will learn how to automate Data Mining Tasks using the SQL Agent.
Misconfiguration is a Problem
The configuration of server systems matters. Not just to ensure software runs smoothly, but also for security.
Silicon Valley Code Camp
Code Camp is a community event where developers learn from fellow developers. This year's event will take place on October 11-12 in the Los Altos Hills in California. Speakers include Steve Jones, Nik Molnar, Anthony van der Hoorn, Mike Wood, and more. Register while space is available.
SQL Server Reporting Services Basics: Customizing SSRS Reports
While the Reporting Wizard and basic report tables will do for prototyping, very soon we'll want to add some finesse to our reports, and allow our report users to create different views of the same data, dynamically. Kathi Kellenberger shows us how it's done.
RegEx for DBAs
RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions
Titles Matter – Part 2
In a followup to his previous piece, Andy Warren looks at job titles again and they can affect the people he works with.
The Community Cloud
The 'Community Cloud' sounds, on first impression, like marketing-speak for some untried novelty, but in fact it is already around, and working well for governments and healthcare in particular. Bob Sheldon investigates, and is encouraged to find groups of organisations who have cooperated to create secure and resilient cloud-based services.
Pairing Data Vault and Biml for DW Agility
Agile data warehousing can be challenging. Pairing the right methodologies and tools can help. Here is how my team met the challenge by using Data Vault methodology and BIML scripting.
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers