What a DBA team actually deals with There are many issues a DBA team faces, from servers going down to login access not being requested on time. These are not glamorous problems, but they are the problems that stop everyone else doing their jobs. In a modern environment you would expect a lot of the […]
Every SQL Server instance contains a database that most people never query, never back up, and never even see in Object Explorer. Yet, without it, SQL Server would not start. Enter the SQL Server Resource database.
And bring a towel. If you don't know what I'm talking about, you have homework. You know with that lead in I'm going to talk about AI. Sorry, can't help it. It's on my mind quite a lot. It's in the news, oh, a whole lot. The majority of those stories can be summed up […]
Acting with confidence is great, but how do you decide when there are potential impacts and concerns about your actions? Steve has a few thoughts today.
Generating temporary passwords is a common requirement in many applications. Users may need to reset a forgotten password, new accounts may require an initial password, or developers may generate test credentials. While password generation is often implemented in application code, doing it directly in SQL Server provides clear advantages. It centralizes the logic, ensures consistency […]
In software development, DevOps promises faster delivery, increased collaboration, and more reliable deployments. However, many teams unknowingly fall into anti-patterns.
Code reviews can be challenging in many places, and with AI, could be even more of an issue in the future.
Learn more about dbt in this next article on Data Engineering in Fabric.
SQL queries can take a long time to run, especially on large tables if not properly indexed. Full table scans can be costly operations when all a user wants is to fetch a few rows based on multiple columns and a WHERE filter. How can we properly index our tables to support multi-column queries?
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
WhatsApp:0838-3161-8008 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota...
WA CS:08218154392 Jl. Khp Hasan Mustopa No.108, Padasuka, Kec. Cibeunying Kidul, Kota Bandung, Jawa...
Hello everyone , I am planning to migrate a database from SQL Server 2014...
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers