The Idea Book
How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be...
2015-03-25
777 reads
Tim Mitchell
Fix Inconsistent Line Terminators in SSIS
There is a flat file processing issue I’ve run into a number of times over the years, and it’s come...
2015-03-23
2,358 reads
Iterating Through Excel Worksheets with Biml
Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in...
2015-03-25 (first published: 2015-03-16)
7,756 reads
On Failure: Getting Up
In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...
2015-02-16 (first published: 2015-02-06)
5,952 reads
Advanced SSIS Training in Dallas
I’m very excited to offer a new course entitled “Advanced SSIS” in the Dallas area this spring. My friend and...
2015-01-21
719 reads
On Failure
The first rule of blogging is that you should write about topics you know a lot about. And I know...
2015-01-09
696 reads
Six practical tips for social media success in 2015
Social media is the new résumé. In many ways, it’s even better than a résumé – a person’s social media stream...
2015-01-09 (first published: 2015-01-02)
6,053 reads
[OT] Blog is in maintenance mode
I’m spending part of this holiday break repaying some technical debt on my website. Among other things, I am importing...
2014-12-21
645 reads
On Perspective
Perspective can make or break a career. Maintaining a proper perspective is very often the differentiating factor between a good...
2014-12-10 (first published: 2014-12-03)
5,657 reads
SSIS Parent-Child Architecture in Catalog Deployment Mode
This is the third in a series of posts about SSIS parent-child architecture. You can find the index page here.
In...
2014-12-05 (first published: 2014-12-01)
7,337 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers