A simple math expression solver
Ben Kubicek wrote a recursive function that solves simple math expressions in a select statement. Read about this creative use of T-SQL.
2011-11-21
5,918 reads
Articles
New SQL Server AlwaysOn Feature - Part 1 configuration
SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.
2011-11-21
3,145 reads
IT staff would rather pocket $100k than blast off into space
Red Gate survey asks would you take cash or trip of a lifetime?
2011-11-18
1,508 reads
Building a Scale Out SSRS 2008 R2 Farm using Windows NLB Part 4
Delivering reports is becoming more critical due to the increasing demand for business intelligence solutions. And while there are a lot of guides that walk us through building a highly available database engine, you’ll rarely see one for SQL Server Reporting Services. How do I go about building a scale-out SQL Server 2008 R2 Reporting Services running on Windows Server 2008 R2?
2011-11-18
1,790 reads
Your input needed: Help to improve Red Gate's products and win one of three $50 vouchers!
If you are a Database Administrator, Developer or IT team lead, take part in our survey and you could win one of three $50 Amazon gift certificates. It will only take you 10-15 minutes.
2011-11-18
1,260 reads
Performance Monitoring with Dynamic Management Views
In this article, Ron Johnson shows how you can use DMVs for proactive real-time SQL Server performance monitoring.
2011-11-17
13,510 reads
2011-11-17 (first published: 2010-03-10)
8,015 reads
The DBA in Space Deadline is Extended
The deadline for entering the DBA in Space competition has been extended until Nov 22, 2011, noon GMT. Enter today and get the chance to fly into space or take the vacation of your dreams.
2011-11-17
1,794 reads
Webinar: PASS Data Architecture VC presents On Beyond Zebra AdventureWorks OR where did I go wrong?
On Thursday November 17th at 8PM Eastern, Steve Simon will discuss "No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
2011-11-17
1,229 reads
New PowerPivot Forum
We have a new forum setup for your Powerpivot questions. If you are working with Powerpivot, please feel free to ask questions here.
2011-11-16
1,895 reads
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