Scripting in SSIS
Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...
2009-08-06
2,239 reads
Blog Posts
The effects UNION in a SQL query
In a recent blog, I shared some of the natural but sometimes unanticipated consequences of adding DISTINCT to a SELECT...
2009-08-06
595 reads
August 2009 Baton Rouge SQL Server User Group – Near Real-time Data Warehousing 1.0
Fresh off of my presentation of the SQL Profiler at SQL Saturday #17 in Baton Rouge this past Saturday, I...
2009-08-05
412 reads
Call For Speakers – SQL Lunch Live Meeting
The Baton Rouge Area SQL Server User Group hosts Bi-Monthly Live Meetings that are 15-30 minutes long the consist of...
2009-08-05
1,473 reads
Review of Bluetooth Speakerphone
I was visiting Compusa recently looking for a couple small things and noticed the Samsung Bluetooth Speakerphone for $24.99 (can...
2009-08-05
396 reads
SQL Saturday #17 – Baton Rouge Wrapup
My presentation went well at the Baton Rouge SQL Saturday with about 30 people attending. It was the early morning...
2009-08-05
363 reads
Agile Practices Meet Database Development: Intro
I think the database developer role is on the rise and that it's better suited for agile practices - but guidance...
2009-08-04
3,496 reads
Another Reason To Install Service Pack 1 CU3 on SQL Server 2008
Microsoft has a new KB article describing a problem where the MAXDOP setting that you specify (whether at the instance...
2009-08-04
822 reads
Disaster Recovery Scenarios with HP Data Protector
Let's say it is a late Monday morning, because something always comes up before you are required at your vocation,...
2009-08-04
7,948 reads
Looking for Good (and Bad) SQL Server Blogs
I was asked to do an hour presentation during the 24 Hours of PASS, which takes place on Sept 2,...
2009-08-04
516 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