PowerShell ETL Presentation
My thanks to everyone in attendence and PASS AppDev VC for inviting me to speak. I’ll post a link to...
2010-06-23
993 reads
SQL Server Operating System Checklist
As a part of a new book project, I am putting together a series of checklists that DBAs can use...
2010-06-23
1,221 reads
Detecting and Reducing VLFs in SQL Server 2008/2008 R2 Transaction Log Files
One common, but often undetected issue that I see with SQL Server databases is a very high number of virtual...
2010-06-22
3,473 reads
Who2 Article Published
I just had my second article published on June 14, 2010 at SQLServerCentral. I will be posting a follow-up to...
2010-06-22
996 reads
Declare Scalar Variable
Lately I have been going through a bunch of maintenance style scripts and fixing them. Along with fixing them, I...
2010-06-22
835 reads
The Power of Indexes
Time and time again I have run into the scenario where a developer who is moving into using databases is...
2010-06-22
712 reads
MDX Puzzle #1
MDX Puzzle #1
Recently, I embarked on a mission to become proficient at writing MDX queries. This is a challenge, as...
2010-06-22
687 reads
SQL Saturday #28 (Baton Rouge) Announcements
Register: Click Here
Submitted Sessions: Click Here
Twitter: @SQLSatBR
On August 14, 2010 at Louisiana State University SQL Saturday #28 will be held. ...
2010-06-22
508 reads
Windows 2008 R2 Install Error - Using VMWare Workstation
Recently I was installing Windows Server 2008 R2 Enterprise Edition onto a virtual machine (VM) I was setting up to...
2010-06-22
2,318 reads
Building a PASS Voting Solution – Part 4
We’re almost at the end of the SQL side of things, just needing to send out notifications/reminders. I was torn...
2010-06-22
540 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