Speaking this Fall
I’ve been at home through the whole month of August, restingworking hard, but it’s time to get on the road...
2013-08-21
864 reads
Blog Posts
SQL Server Three Valued Logic and Ansi Nulls
SQL Server uses a three valued logic with True, False, and Unknown. And, normally, SQL Server Nulls are not comparable....
2013-08-21
1,293 reads
SSIS Deployment with PowerShell: Adding Environment References
With the release of the revamped Integration Services in SQL Server 2012, a bunch of new deployment methods were introduced...
2013-08-21
7,739 reads
The Podcast is in the Windows Store
If you’ve got a Windows Phone, or any of the Windows devices that support podcasts, the Voice of the DBA...
2013-08-21
1,317 reads
Webcast Presentation Materials: Building Security Audits with Extended Events
Earlier today, I presented a session for Pragmatic WorksTraining on the T’s; which occur every Tuesday and Thursday. In the session,...
2013-08-21
1,030 reads
A placement firm’s “guaranteed” replacement
I have heard large placement firms say they are better than smaller firms because “They offer the client a guaranteed...
2013-08-20
624 reads
Data Purity issue after upgrading SQL 2000 to later versions
In SQL Server versions prior to 2005, it was possible to have invalid data values into a database. That can...
2013-08-20
927 reads
Fixing Page Life Expectancy (PLE)
What is Page Life Expectancy (PLE), what makes it drop, and how can I manage memory better? Abusing disks slows...
2013-08-20 (first published: 2013-08-19)
4,778 reads
Interview Candidates for Skills, Aptitude, Maybe Both
Over the years I’ve been primary a skills interviewer. In theory I know what skills are needed and in theory...
2013-08-20 (first published: 2013-08-15)
2,446 reads
PASS Summit 2013 - You Ain't From Around Here Are Ya?
I know what y'all are thinkin', what's Charlotte got to do with SQL Server? Just hear me out. There's a...
2013-08-20
1,293 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
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
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...
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