Database Fundamentals #1: Install SQL Server
To get started with SQL Server, you need to install it. However, I’m not going to teach you how to...
2017-06-05
542 reads
The Scary DBA
Database Fundamentals
One of my favorite things about being a technologist is constantly learning new things, but, this can lead us to...
2017-06-15 (first published: 2017-05-31)
2,796 reads
Technology Gender Gap By State
This is my first ever guest blog post. Take it away Hazel Garcia.
Though the gender gap narrows by the year,...
2017-06-02 (first published: 2017-05-22)
1,429 reads
MySQL and Backups As A Service
With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...
2017-05-10
610 reads
General Notes on Security in Azure SQL Data Warehouse
I’m still learning about Azure SQL Data Warehouse (ADW, cause I’m lazy). ADW is a deceptively deep topic. Initially you...
2017-05-22 (first published: 2017-05-08)
1,184 reads
Redgate Alexa Contest Winners!
A couple of weeks ago we had a small contest here to pick a skill for Alexa. The entries were...
2017-05-05
488 reads
Food On Your Table
I was asked, “Who here thinks that PASS helps people put food on the table?” To my shame, I initially...
2017-04-25
408 reads
Query Hash Values, Plan Guides and the Query Store
I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does...
2017-05-08 (first published: 2017-04-24)
1,330 reads
The Age of Data and Software Development
I am so excited to be a data professional in the modern era. Yeah, 15-20 years ago, it was cool...
2017-04-17
418 reads
Alerts From Azure Automation
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
647 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