How to bulk enable or disable SQL Server agent jobs ?
It often happens that you need to disable or enable all jobs in SQL Server Agent in one shot. Script...
2015-06-22
2,523 reads
It often happens that you need to disable or enable all jobs in SQL Server Agent in one shot. Script...
2015-06-22
2,523 reads
I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know...
2015-06-22
932 reads
Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will frequently tell people to use is the file target....
2015-06-21
19 reads
Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will...
2015-06-21
1,796 reads
I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer...
2015-06-20
546 reads
This past Tuesday, I got a chance to speak at the Minnesota SQL Server User Group. It was a great...
2015-06-19
530 reads
Reading Time: 2 minutesMeet the SQL Master! In WOxPod!, episode # 008 – “Wayne Sheffield...
The post 008 – Wayne Sheffield – MCM appeared first...
2015-06-19
574 reads
Let’s consider a scenario where the end user require a CSV file of all the records in a table then...
2015-06-18
1,314 reads
It’s Thursday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-06-18
697 reads
Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...
2015-06-18
377 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