May 2015 – SQL Server Monthly Maintenance Checklist
image source
It’s time for a monthly reminder to review you SQL Server environment. Hopefully over the last few months of...
2015-05-06
676 reads
image source
It’s time for a monthly reminder to review you SQL Server environment. Hopefully over the last few months of...
2015-05-06
676 reads
Reading Time: 2 minutesMen In Black are not the only ones that can remove an...
The post Identity Removal appeared first...
2015-05-19 (first published: 2015-05-06)
6,434 reads
As you may know I’m preparing to write my first presentation. I have a great abstract and an outline of...
2015-05-06
558 reads
By David Postlethwaite
Although the concept of Cloud Computing and Microsoft Azure have been around for a number of years it...
2015-05-06
737 reads
Visual Studio is a great tool for developers, and it offers so many great features, such as IntelliSense, unit testing...
2015-05-18 (first published: 2015-05-06)
6,237 reads
This post will help you create a SQL Server job to backup all the jobs in a SQL Server Agent...
2015-05-06
195 reads
In what spare time I’ve had this week, I’ve been watching the news coming out of Microsoft Ignite (formerly Tech...
2015-05-06
4,747 reads
Most people prefer to have “sa” account as the database owner, primary reason being sa login cannot be removed/deleted unlike any...
2015-05-05
403 reads
If you’re in the Iowa City area, come to Iowa Code Camp this weekend! They have a great lineup of speakers, covering...
2015-05-05
423 reads
Intro
AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like...
2015-05-15 (first published: 2015-05-05)
6,900 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