Curb those Cursors !
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
689 reads
“One of the Pack to Top Dog”
My first guest editorial published !
http://www.sqlservercentral.com/articles/Editorial/70725/
Would appreciate any comments you have.
2010-07-15
580 reads
Scanning Without Wires - Epson Workforce 610
We are trying to buy another property here at the ranch. My wife had to leave town in the middle...
2010-07-15
747 reads
MDX Puzzle #3 Solution
Download Script
Sorry that it’s taken me so long to write this post, but I have been a little busy with...
2010-07-15
698 reads
Pruning the Blog List
I went through the exercise months ago where I tried to re-organize my blog reading to be more efficient at...
2010-07-15
840 reads
Making Choices Narrows Your Remaining Options
I’ve had variations of this conversation a couple of times lately and thought it was worth writing down some thoughts....
2010-07-15
511 reads
SQL Saturday Advice - Build a Foundation
I think this is a good idea, and I’ll give you some reasons, but every SQL Saturday ought to consider...
2010-07-15
977 reads
Defensive Db Programming Chapter 02
This is the review of the second chapter of the book Defensive Database Programming. The title of this chapter is...
2010-07-15
1,825 reads
Building My New Home, SQL Server IO
April of 2009 I decided it was time to blog about my SQL Server experiences in earnest. Steve Jones (twitter|blog)...
2010-07-14
537 reads
Retrieving last backups of the databases
The script below is a simple and quick way to find out the last backup performed successfully to the databases...
2010-07-14
766 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