Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks. On the professional level, it can be purely technical like SQL Server...
2020-09-03
33 reads
SQL Server 2017 (compatibility 140) brought us many Intelligent Query Processing (IQP), formally known as Adaptive Query Processing, features that improve performance on workloads straight out of the box...
2020-09-02
40 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-02
32 reads
The Call for Speakers for the 2020 Fall edition of GroupBy is open, but it closes in just 3 days! We’re currently using Sessionize to help us organize this...
2020-09-02
64 reads
Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....
2020-09-02 (first published: 2020-08-25)
620 reads
Two years ago I wrote a post that got a lot of traction in the comments at the time. Last month there was renewed interest because one of the...
2020-09-02
40 reads
Did you know it is possible for SQL Server Agent to alert you of problems if something goes haywire with your Agent? Have you ever had an issue with...
2020-09-02 (first published: 2020-08-25)
419 reads
Following on from my posts about using Secret Management Good bye Import-CliXml and running programmes as a different user, I have another use case. After creating Azure SQL Databases...
2020-09-01 (first published: 2020-08-21)
569 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-09-01
33 reads
I recently published my color contrast report in the Power BI Data Stories Gallery. It allows you to enter two hex color values and then see the color contrast...
2020-09-01 (first published: 2020-08-20)
432 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
WhatsApp:0817819444 Jl. Suryakencana No.260 C & D, RT.01/RW.05, Babakan Ps., Kecamatan Bogor Tengah, Kota...
WhatsApp:0817819444 Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, RT.5/RW.7, Krukut, Kec. Taman Sari,...
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers