Upcoming Presentations: #24HOP & #SQLSAT46
Blogging has been a bit quiet of late. That’s because I’ve been spending a lot my spare time getting ready...
2010-08-30
767 reads
SQL or MDX query trace in SSRS - trick of imagination or a real thing?
I sometimes have ghost memories - I remember some things that had never in fact happened. And I was wondering if ...
2010-08-30
3,319 reads
Convert Several Columns in SSIS With Fewer Clicks and Confusion
I've had this one in my toolbox for a while now, decided to publish it on CodePlex a while back,...
2010-08-30
719 reads
Testing for NULLS in a Dataset Filter
Some seemingly simple filtering logic can be more difficult to achieve when using
a dataset filter rather than the WHERE clause...
2010-08-30
624 reads
PASS Update #42
Our most recent board meeting was in Nashville on Aug 19, 20. We had originally discussed meeting in Seattle/Redmond/Vancouver, but...
2010-08-30
973 reads
NetFlix and Null
There are some progressive companies out there, and I think they are doing some very interesting things with how they...
2010-08-30
1,569 reads
MDX Puzzle #7
I have presented you with a couple of easy puzzles in the last few posts. So, let's step it up...
2010-08-29
479 reads
Dynamic SQL and Cached Query Plans
Over the many years that I’ve been dealing with SQL Server, I’ve always been told and read about how using...
2010-08-29
610 reads
Restarting SQL Server using a Batch Script
In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...
2010-08-29
13,344 reads
Restarting SQL Server using the GUI
Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...
2010-08-29
489 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