Rants about Connect
The site connect.microsoft.com is a wonderful concept: you can provide feedback about the Microsoft products, report bugs and give suggestions...
2013-07-29
711 reads
Blog Posts
SQL Server – Import text file using xp_cmdshell
There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK...
2013-07-29
1,061 reads
SQL Server Management Studio Rainbow Edition
Reblogged from The SQL Pro: Ever wanted to know the reason behind the Database color scheme in SQL Server Management...
2013-07-29
694 reads
What I’m sayin’ is…everything is fine.
Let’s say you are a member of the development team. Your team got a new project in the works, so...
2013-07-29
636 reads
SQL Saturday #252, Christchurch New Zealand
TweetSQL Saturday #252 Christchurch, New Zealand
G’day,
Well, these are exciting times for the Christchurch SQL SERVER User Group.
After a period of...
2013-07-28
1,174 reads
SQL Saturday Sacramento was terrific
This year’s SQL Saturday #222 in Sacramento was a blast. This event was certainly the high point of my summer,...
2013-07-28
783 reads
Go ahead. Laugh.
I came across one of my twitter friends @DBAReactions tumblr site and gosh! I cannot stop laughing! Here is one...
2013-07-27
535 reads
Security Questions: Recommended Security Book
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-27
718 reads
Disaster Recovery - Part 1 - Possibly Almost Everything But the Kit
Over the years I have been fortunate or unfortunate enough, depending on who you are to have experienced several disasters...
2013-07-26
1,057 reads
Hardware 201: Selecting and Sizing Database Hardware
On July 25, I had the opportunity to present Hardware 201 for the PASS Performance Virtual Chapter. You can download...
2013-07-26
1,112 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
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...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
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