AS400 Program from SSIS
If you need to call an AS 400 program from an SSIS package this can easily be accomplished with an...
2013-06-03
1,035 reads
Blog Posts
Building a SharePoint 2013 BI Demo Environment Part 3 – Installing the OS
This part of the series will focus on installing the Windows Server 2012 OS on the virtual machine. In most...
2013-06-03
1,120 reads
Have you configured Database Mail to utilize multiple SMTP Accounts ?
Lets start discussing about this subject by closely looking at the term Redundancy. What is redundancy all about ?
Wikipedia defines redundancy as “In engineering, redundancy is the...
2013-06-03 (first published: 2013-05-24)
2,303 reads
How Your DBAs Are Granted VMware vCenter Access
A while back I wrote a blog post at the House of Brick technical blog that details talking points and...
2013-06-03
708 reads
Last Weeks Top “Reading” Links #35
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-03
708 reads
Microsoft announce SQL Server 2014
As the world is going green, Microsoft announced today that it is going “Blue”. Confused? I’ll explain all in a...
2013-06-03
1,267 reads
Microsoft Teched 2013 Keynote
Welcome to Teched 2013
We’re starting off with some type of James Bond video. Chase scene with a really cool car....
2013-06-03
875 reads
Notes from the First Day of the 2013 Techno Security Conference
The Techno Security & Forensics Security Conference is held in conjunction with the Mobile Forensic Conference each year in Myrtle Beach,...
2013-06-03
1,188 reads
Pattern searches beyond ‘%string%’.
I was asked today to take a table with a social security column and put all 0s if the column...
2013-06-03
916 reads
SQL Logical Query Processing Order
This probably applies more to beginners or people who have been using SQL for a while but have been wondering...
2013-06-03
505 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
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...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Imagine the Physical World
Comments posted to this topic are about the item Imagine the Physical World
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