Does File Exist Check in SSIS
A very common need in SSIS is to check to see if a file exist before you run what could be...
2009-08-11
15,181 reads
Blog Posts
Passed The 70-251 Microsoft Exam
I took the final, non-BI Microsoft SQL Server 2008 Certification Exam on Friday, so now I have finished all of...
2009-08-11
545 reads
Review: Motorola H710 Headset
Last week I posted about getting a new bluetooth speakerphone, so I thought I’d follow up with some notes about...
2009-08-11
520 reads
Security is a Zero-Sum Game...
but I don't mean with respect to privacy. But I do mean with respect to the time it takes securing...
2009-08-11
710 reads
Some Statement Start Times!
I thought I had captured statement start times within the DMV sys.dm_exec_sessions. I was absolutely wrong. However, this has sparked...
2009-08-11
957 reads
The Joy of Data Modelling.
You may think that the task of teasing out the exact nature
of the data and processes within a company...
2009-08-11
2,496 reads
24 Hours of PASS
Rick Heiges has put together an interesting event coming up on Sep 2, 2009 called 24 Hours of PASS. As...
2009-08-10
838 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-10
82,276 reads
Good News for IT professionals? - Ray of Economic Light Shines in July........
Here's some upbeat info to share as the week kicks off to a new start!
Data just recently released by the Department of...
2009-08-10
692 reads
Interview on SQLAuthority.com
Well-known Indian SQL MVP Pinal Dave has posted a short interview he did with me recently. Pinal is the founder...
2009-08-10
563 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