Data Mining: Part 15 Processing Data Mining components with SSIS
In this lesson, we will show different components to Administer the Data Mining Models with SSIS.
Reverse Engineering Disasters
Preparing a disaster recovery plan means more than just trying to prevent a few specific disasters. It means turning around the way you view the world.
SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test
The first test of AlwaysOn in SQL Server 2012 is successful, but after testing to swing back again to your primary replica, you find out that automatic failover works only the first time. How come? Carla Abanes explains.
Questions about T-SQL Expressions You Were Too Shy to Ask
Nobody seems to ask questions about SQL Expressions in forums, even though expressions can cause all sorts of problems. It's time for some straight-forward Q&As, and who better than Robert Sheldon to give the A?
Smooth Database Deployment at SQL in the City 2014
SQL in the City is coming this fall to London and Seattle.
SQL Server Service Engine fails to start after applying CU4 for SQL Server 2008 SP1
After performing an update on SQL Server, SQL Server Engine and SQL Agent stop responding.
Big Data Technologists Transition to Customer-Facing Roles
As the enterprise embraces big data, management assumes that staff sizes will decrease. What should be done with those unneeded technologists? One answer: convert them into technology consultants that collaborate and coordinate with the lines of business. In other words, give them customer-facing roles.
SQL Saturday #340 - San Diego, CA
SQL Saturday is coming to San Diego on September 20, 2014. This event has a great speaker line-up which includes Itzik Ben-Gan, Grant Fritchey, and many others. Register while space is available.
Auto Generating Multiple XML Files Using SSIS
An SSIS package that can generate an XML file for each record in an XML column in a SQL Server Database using the Source Script Component in a Data Flow Task.
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers