Closing Fast – SQLSaturday #49 – Orlando
Well, the event is closing in fast, less than 2 weeks away! We have over 300 registered, a great schedule,...
2010-10-06
547 reads
An Organizer's Recap of SQL Saturday #48 - Columbia, SC
This past Saturday, October 2nd, we hosted Columbia, SC's first ever SQL Saturday. By the feedback we've received, both during...
2010-10-06
821 reads
A Surprising Result from Ident_Current
If you haven’t used it (and I rarely do myself), Ident_Current (‘tablename’) returns the last identity value generated across all...
2010-10-06
975 reads
5-Weeks to PASS Summit 2010 Countdown
With 5-weeks until the PASS Summit it’s time to start getting ready for the event. As I’ve discussed a couple...
2010-10-06
743 reads
Determine if Directory Exists using xp_cmdshell
Recently, I came across a forum post from a user trying to determine if a directory existed in the file...
2010-10-06
14,373 reads
PASSMN Board of Directors Nominations
It’s that time of the year again. Time to get in some nominations for the 2011 PASSMN Board of Directors. ...
2010-10-06
1,101 reads
Tip: OVER and PARTITION BY
Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful…
OVER
OVER allows you...
2010-10-05
2,642 reads
It’s Implied
This has been on my radar now for a little over a week. I ran across a request in the...
2010-10-05
756 reads
SQL Saturday New England: The Date
Mark your calendars. Make your travel arrangements. Plan on being in the Boston area on April 16th, 2011. Three of...
2010-10-05
544 reads
How Do I Spot Identity Columns That Are About to Max Out?
Every so often, usually in the middle of the night or on a holiday weekend, an identity column will hit...
2010-10-05
1,353 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