SQL Server DBCC CHECKDB
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
385 reads
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
385 reads
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...
2017-03-28
1,004 reads
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...
2017-03-27
314 reads
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...
2017-03-24
392 reads
A non-technical post but something I have been asked about few times so I thought that I would put pen...
2017-03-22
451 reads
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...
2017-03-20
325 reads
My database is in the recovery pending state and I want to get in and extract the data out into...
2017-03-15
371 reads
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...
2017-03-14
388 reads
This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new speakers (https://sqlbek.wordpress.com/2016/10/25/t-sql-tuesday-84-growing-new-speakers/ – thanks Andy) and I have...
2017-03-10
395 reads
If you ever need to move a copy of a SQL database in Azure across servers then here is a...
2017-03-07
359 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