Permissions Needed To Force Plans in Query Store
I was recently asked what permissions were needed to force plans in query store. I’m sure I knew at one point, but at the moment I was asked, I...
2021-07-06
165 reads
Daily Coping 6 Jul 2021
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...
2021-07-06
33 reads
Server Review Essentials for Accidental and Junior DBAs—Daily Server Checks (Part 1)
Welcome back to the series “Server Review Essentials for Accidental and Junior DBAs.” So far in this series we’ve taken a look at how to set up your work...
2021-07-06
56 reads
The SQL Server community and the rising tide (and all that).
I was speaking with one of my favorite people in the SQL Server community, Grant Fritchey (blog|twitter), on twitter today. ... Continue reading
2021-07-06
112 reads
Getting the Script from the SQL Compare Command Line
In the last few posts, I’ve written about using the SQL Compare command line for a specific object and shown how to get a report. This post will look...
2021-07-05
67 reads
Daily Coping 5 Jul 2021
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...
2021-07-05
32 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
18 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
11 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
22 reads
Relaunching www.SQLpassion.at
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version....
2021-07-05
14 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
BCA KCU BOGOR Telp/Wa 085111887254
Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor, Jawa Barat...
BCA KCU LUBUK LINGGAU Telp/Wa 082371291690
Jl. Yos Sudarso No.155, Taba Jemekeh, Kec. Lubuk Linggau Tim. I, Kota Lubuklinggau, Sumatera...
Alamat Telp BCA KCP Sulawesi (+62) 838-4945-0961
Wa:083849450961 Jl. Sulawesi No.34, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan 90174
Question of the Day
The ##MS_DatabaseConnector## User
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