SQL Server Backup Compression
I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...
2016-11-03
485 reads
I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...
2016-11-03
485 reads
In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...
2016-11-02
596 reads
One of the benefits of twitter is that you get to hear about new tools quickly, one of the tools...
2016-11-01
684 reads
I have been using SSMS (SQL Server Management Studio) 2016 build number 13.0.15900.1 and noticed that if you wanted to...
2016-10-27
657 reads
I like row versioning– see this link for more details: https://technet.microsoft.com/en-us/library/ms189122(v=sql.105).aspx If your database is enabled for one of the...
2016-10-26
385 reads
This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt...
2016-10-25
482 reads
About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database...
2016-10-20
480 reads
The following DMVs shown within this blog post are some of the more common ones that I am finding really...
2016-10-18
492 reads
I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are...
2016-10-24 (first published: 2016-10-17)
2,004 reads
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
539 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