SQL Server 2019 Query Store And SSMS
While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis...
2019-07-17
52 reads
While not specific to SQL Server 2019 (I was using this version to do some testing) I was struggling to find how to change the time period of analysis...
2019-07-17
52 reads
The purpose of an Elastic Job is to execute a T-SQL script that is scheduled or executed ad-hoc against a group of Azure SQL databases. Targets can be in...
2019-07-11
186 reads
It is always a dark art trying to suss out why he/she is an MVP? Do they deserve it? What does it take? Why can’t I get it? The...
2019-07-05
29 reads
I had a good question from JP via a comment on my blog about whether you can use the MAXDOP query hint in Azure SQL Database. The answer? Yes....
2019-06-24
39 reads
Using Graph DB is a good way to show relationships between entities (more specifically a vertex and edges). This is why you would use this approach over classic SQL...
2019-06-24
40 reads
Let’s use the Azure portal to build a globally distributed Cosmos DB. Before doing this, why would you ? what are the benefits? Regional based. By this I mean...
2019-06-18
69 reads
Technically you do not have to create a cosmos DB and incur costs to test cosmos DB based applications, you could use the local emulator. This means that you...
2019-06-11
101 reads
Cosmos DB falls into the “NoSQL” technology group, call it a buzz word if you like but it is very different to classic Relational Databases such as SQL Server....
2019-06-10
221 reads
Quite simply the objective as follows: Move data from Azure SQL Database to Azure SQL DW via Azure Data Factory v2 (ADF). Overview Before I begin, what exactly is...
2019-05-22
220 reads
Quite a significant change has taken place within the Azure SQL Database space, more specifically the development of Azure SQL Database Serverless. Currently in preview mode this “compute” tier changes...
2019-05-14
340 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