Clean up all (most) of the orphans on an instance
Recently we have been doing a number of instance moves as part of a large upgrade project. And as anyone...
2015-06-03
1,668 reads
SQLStudies
Yet one more quick and easy performance tuning setting
I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS...
2015-06-01
623 reads
Multiple Windows Groups with different default databases
A question came up at work the other day, mostly as a mind game, but you never know it might...
2015-06-08 (first published: 2015-05-28)
1,845 reads
Default database
What?
The default database is one of the options when creating a login in SQL Server. This is the initial database...
2015-05-26
1,062 reads
Adding new users & groups in windows
I do a lot of testing with security in SQL Server. And of course to do a thorough job of...
2015-05-20
704 reads
Extending your metadata with Extended Properties
Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on...
2015-05-28 (first published: 2015-05-18)
5,912 reads
Test first; Mileage may vary;
I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a...
2015-05-14
603 reads
TSQL Tuesday #66: Monitoring
If a user is going to call me about problem, I’d much rather know about it ahead of time. In...
2015-05-21 (first published: 2015-05-12)
4,893 reads
Notes on Presenting
As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of...
2015-05-06
545 reads
Building a job to monitor other jobs
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows...
2015-05-14 (first published: 2015-05-04)
6,465 reads
Blogs
A Broken Copilot Query
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Prompt AI helping with Auditing
By Steve Jones
I had a conversation with a customer asking this question: how can I tell...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
Collation errors...what is best way to deal with it?
Hi I have a SP that occasionally get this error: Cannot resolve the collation...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers