Important: System Objects/Views/DMV/DMF
Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored...
2010-06-17
1,012 reads
Finding SQL Server Client Ports
I saw a post recently asking if there was an easy way to find the port a client was using...
2010-06-17
1,566 reads
PASS Update #33
It’s been almost a month since my last update, too long! I’ve put up separate posts on my unplanned and...
2010-06-17
703 reads
Building a PASS Voting Solution – Part 1
Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst...
2010-06-17
516 reads
Strange but True: Reporting Off of Cubes with Parameters Creates Hidden Datasets
I know, it is strange, but it is true...When you create Reporting Services reports that run off of an Analysis...
2010-06-17
999 reads
What is the Ideal SQL Server Test Box?
I’m thinking about setting up a SQL Server test box in my home office for doing some extensive, real-world SQL...
2010-06-17
423 reads
24 HOP Available
Just a quick note. PASS has made the 24 Hours of PASS available via streaming video. You can check it...
2010-06-16
474 reads
24 Hours of PASS Recordings Now Available
Our most recent 24 Hours of PASS celebrated the SQL 2008 R2 launch. 24 great sessions, 23 of which were...
2010-06-16
586 reads
My PASS Session Abstracts
The 1992 Dream Team
When you hear the phrase “All-Star Lineup”, what comes to mind? The New York Yankees? The 1970's...
2010-06-16
330 reads
So I Won't Be Going to the Summit This Year
As the deadline for abstracts to be submitted to the PASS Summit came due, I made the hard decision not...
2010-06-16
646 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