Too many Foreign Keys
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...
2016-03-10
111 reads
I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...
2016-03-10
111 reads
Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...
2016-03-09
1,030 reads
I had an incident today where a colleague was running a Wait Stats Report and the output looked like this:
As...
2016-03-15 (first published: 2016-03-09)
3,030 reads
Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...
2016-03-09
810 reads
Quick notes:
Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is...
2016-03-09
624 reads
The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very...
2016-03-09
608 reads
I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do...
2016-03-09
646 reads
This one is about spending time with my daughter – she bought some army men as a toy after a visit...
2016-03-09
534 reads
I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...
2016-03-09
487 reads
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,271 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers