It’s a Problem When a SysAdmin Can’t Log In
I showcased a demo recently that looked at a potential issue with an application where a user used a simple...
2015-01-20 (first published: 2015-01-12)
6,538 reads
Blog Posts
Outlier Detection with SQL Server, part 3.3: The Limitations of the Tietjen-Moore Test
By Steve Bolton
…………The Tietjen-Moore test may have the coolest-soundest name of any of the outlier detection methods I’ll be surveying...
2015-01-20
1,276 reads
SQL Script to find the databases size
Sometimes we need to find out the size of the database on a server. Below SQL Scripts can be used...
2015-01-20
593 reads
SQL Script to find the list of all the jobs failed yesterday
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below...
2015-01-20
2,452 reads
SQL Script to find the tables created from a given date
Below is the SQL query which can be used to find out the tables which are created or modified on...
2015-01-20
653 reads
SQL Script to search stored procedures containing a given text
Sometimes we need to find out how many stored procedures contains a given text. Below SQL query can be used...
2015-01-20
667 reads
SQLSaturday #362 – Austin, TX – Let’s Get Weird
I used to spend the 4th of July weekend (or week) in Austin with some buddy’s when we were in...
2015-01-20
925 reads
Windows policy Lock Pages in Memory option and SQL Server instance in VM
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in...
2015-01-20
1,950 reads
Windows policy Lock Pages in Memory option and SQL Server instance in VM
As we know, this Windows policy Lock Pages in Memory option determines which accounts can use a process to keep data in physical memory, preventing the Windows operating system from paging...
2015-01-20
5 reads
A Healthy SQL Server
T-SQL Tuesday has come and gone and I missed the boat due to some ongoing work constraints. With that said...
2015-01-19
552 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
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
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...
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