Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
11 reads
Josef Richberg
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
12 reads
Working with Excel Destinations in SSIS - 0xC0202025, 0x80040E21
Working with Excel in SSIS is not fun and something I whole-heartedly discourage. With that said, I had a not...
2012-12-12
1,510 reads
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query....
2012-11-10
1,040 reads
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate
what SQL Server does in a query. Here I am going to show you how to...
2012-11-10
58 reads
Existence Check Deconstructed -- SSIS Lookup Transformation
There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query. Here I am going to show you how to...
2012-11-10
15 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so...
2012-04-27
2,823 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune
the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it places them into...
2012-04-27
201 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it...
2012-04-27
12 reads
SSWUG Expo..I'm up!
I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...
2012-04-26
334 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