TSQL Challenge 82 - Find elements that uniquely make up a group
The challenge is to find the Tax Code based on Price. Each sales amount is uniquely made up by the sum of one or more prices. Based on this you should assign the tax code to each price.
Distributed Computing - Hybrid Systems Considerations
When the Cloud was new, it was often presented as an 'all or nothing' solution. Nowadays, the canny Systems Architect will exploit the best advantages of 'cloud' distributed computing in the right place, and use in-house services where most appropriate. So what are the issues that govern these architectural decisions?
SQL in the City - New York 2012
Come join Grant Fritchey, Steve Jones and others for a free day of training in New York City on Sept 28, 2012.
A Quick Count
This Friday Steve Jones wants to know if your career is also helping your wardrobe. (This editorial was originally published on Aug 23, 2007. It is being re-run as Steve is on vacation.)
Red Gate Software announces speaker line up for US SQL in the City tour
SQL in the City is a free, full day training and networking event for database professionals. After the success of last year’s event, Red Gate has expanded the event to cover six cities from sea to shining sea, including: New York, Austin, San Francisco, Chicago, Boston, and Seattle.
Why doesn’t ISNUMERIC work correctly? (SQL Spackle)
Another in our series of articles to help you fill in the cracks in your knowledge with SQL Spackle. MVP Jeff Moden shows us how IsNumeric works and how you should use it.
Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services
This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.
More CPU Means More Data
Faster CPUs allow us to perform more complex modeling and analysis of variables, and hopefully come up with better decisions. However that more complex analysis means more data.
SSC Clinic: Finding the rogue query
When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.
Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test
The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the one being tested. In retrospect, after using tSQLt for a while, what are the 'gotchas'; those things that you'd have been better off knowing about before you get started? David Green lists a few tips he wished he'd read beforehand.
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers