2018-02-07
290 reads
Kenneth Fisher
SQL Homework – February 2018 – Work with security
This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts
Create a SQL login and a Windows authenticated login....
2018-02-05
309 reads
The difference between blogging about something you know, and something you are learning (Love blogging! Live!)
Close but you need to blog about learning while blogging about the difference of blogging when you are learning something...
2018-01-31
512 reads
How To: Install SQL Server on an Azure VM
Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is...
2018-01-29
616 reads
What’s dbo?
Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems...
2018-01-29 (first published: 2018-01-22)
1,982 reads
Who should own the database?
TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and...
2018-01-25 (first published: 2018-01-15)
2,710 reads
Help it takes forever to open the SQL Server Log!
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the...
2018-01-24
442 reads
How to read a technical blog
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If...
2018-01-17
310 reads
Fun with sp_rename
Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in...
2018-01-11
1,444 reads
2018-01-10
246 reads
Blogs
Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python
Most apps that call an LLM send every request to the same model. That...
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Forums
ALAMAT KANTOR BCA KCP Kramat Jati Telp:083831618008
WhatsApp:0838-3161-8008 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers