Creating and Executing an SSIS Package Programmatically
One of the nice things about SQL Server Integration Services (SSIS) is its extensibility.
If you find you have need for...
2013-08-25
28,269 reads
Blog Posts
Using DMV to identify sessions in your SQL Server
More than running sp_who2, which gives you more information than the good ol’ sp_who, or querying sys.dm_exec_sessions to check all...
2013-08-24
817 reads
When and why you should use 1=1 in WHERE clause?
One Interviewer ask this question during interview of my friend.It is easy to answer but need some specific and to...
2013-08-24
1,264 reads
Who’s doing what to your SQL Server?
When doing any kind of troubleshooting in your SQL Server first thing you ask is who is currently connected to...
2013-08-24
671 reads
Authority as the Enemy: Notes on elections and perceptions in the tech community
Let’s hear a story. The story is true, but elements have been generalized and fictionalized for simplicity, and so’s not...
2013-08-23
610 reads
Decisions, Decisions. Fall Events
I was looking over my travel calendar this fall, and I’m somewhat amazed at the variety of events that are...
2013-08-23
1,144 reads
2013-08-23
721 reads
iOS v Android–A Short Term Update
I ordered my first new new phone this year. I’ve never purchased a new, unreleased model of a cell phone...
2013-08-23 (first published: 2013-08-16)
2,563 reads
Notes From The August 2012 OPASS Meeting
Luis Figueroa did a nice job presenting on Master Data Management. It’s nice to see the tools evolving, though I’ll...
2013-08-23
617 reads
Reblog: August 16 to August 22
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-08-23
827 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
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...
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