"Surely this one will get a clustered index scan."
In which SQL Server stubbornly insists on doing key lookups way, way past the tipping point.
Lack of Memory
It seems that many SQL Servers can be lacking memory. Adding more is one way to improve performance, but Steve has other ideas.
Workplace Encounter: Effects of TLS 1.2
In this article we share a recent experience we had with implementing TLS 1.2 ONLY support on our databases and particularly with respect to its effect on Transaction Log Shipping sessions.
SSRS Reporting Basics: When is SSRS the Right Tool?
SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in companies large and small. In this article, Eugene Meidinger recounts the history of SSRS and explains when it’s the best tool to use.
Working with SQL Server Stored Procedures and .NET
Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.
Review Minimum SQL Server Security Practices
In this tip we look at different things you should consider when developing your database systems to ensure you are also thinking about security best practices as well.
Generate a SSIS-package that reads from Twitter using Biml
Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter.
Real-time performance monitoring for Azure SQL Database Managed Instance
This article was co-authored by Dimitri Furman and Denzil Ribeiro Reviewed by: Danimir Ljepava, Borko Novakovic, Jovan Popovic, Rajesh Setlem, Mike Weiner Introduction In our ongoing engagements with the SQL DB Managed Instance preview customers a common requirement has been to monitor database workload performance in real time.
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers