DevOps and the DBA
Michael Fal is a huge advocate of automation and many ways it can improve the lives of developers and DBAs alike, but you can’t just automate all your problems...
Free Guide: Eight Steps to Effective SQL Server Monitoring
This free guide includes worked examples, practical advice, and covers the hows and why of SQL Server monitoring. Download the guide and get a 26 monitoring tips as well.
A Complex Database Project in Visual Studio SSDT
One Way to Handle a Very Complex Database Project with Several Databases and Cross References
Database Source Control Workshop - London, UK
Redgate's workshops are coming to London on July 8, 2015. In this workshop, you'll learn how to source control your database, deploy your databases from source control, and monitor and track database changes across development, testing, and production environments. Register while space is available.
Testing SQL Server Backup Performance with Trace Flag 3042
Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.
Awareness
This week Steve Jones looks back at the T-SQL Tuesday blog part and its theme of monitoing.
Testing Simple Calculations and UDFs with tSQLt
This article will give you a basic look at how you can test your user defined functions with the tSQLt framework.
Documenting your SQL Server Database
One of the shocks that a developer can get when starting to program in T-SQL is that there is no simple way of generating documentation for routines, structures and interfaces, in the way that Javadocs or Doxygen provides. To embed the documentation in the source is so obvious and easy that it is a wrench to be without this facility. Phil Factor suggests a solution.
SQL Saturday #407 - Vancouver
SQL Saturday is coming to Vancouver, British Columbia on June 27 2015. Join us for a free day of SQL Server training and networking. Register while space is available.
Searching for Plans
Would you want a query optimizer that searches for the best plan for your code? Steve Jones thinks this might not be a bad idea.
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