Gatekeeping and Accessibility
In my final post about gatekeeping in technology, I have to come clean about something. Let’s go through this journey together. In the first post we spoke about what...
2019-09-25
14 reads
Blog Posts
Hot Patching sqlservr.exe in Azure SQL Database
An amazing blog post by Microsoft describing the idea of hot patching the database engine in Azure SQL Database to allow for minimal downtime when applying patches to SQL...
2019-09-25
31 reads
Losing Another Day
I’m going to lose today again. This time I’m headed back to Australia and in flight. I wonder if I’ll get used to this, as I expect between work...
2019-09-25
13 reads
Running SQL Server containers as non-root
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on Github. This dockerfile was under the mssql-server-linux-non-root directory and (you guessed it) allows SQL Server...
2019-09-25 (first published: 2019-09-18)
992 reads
OLDEST_PAGE Log Reuse Wait type
Do you frequently use the “log_reuse_wait_type_desc” column in the [crayon-5f297eff3d7ff981952735-i/] view? Have you ever seen the type of OLDEST_PAGE? You are not the only one!! Recently I was troubleshooting...
2019-09-24
1,199 reads
Restarting SQL Server after adding a new SQL login
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
321 reads
Restarting SQL Server after adding a new SQL login
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
9 reads
SQL Server Quick Tips
Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the...
2019-09-24 (first published: 2019-09-17)
996 reads
SQL Server’s “Wrong” Math
Watch this week’s video on YouTube! A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with...
2019-09-24
58 reads
SQL Server's "Wrong" Math
Watch this week's video on YouTube
A couple of weeks ago I decided to rebuild my recording studio by getting rid of my fabric backdrop and replacing it with a...
2019-09-24
4 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
SQL Server Auditing: Track Changes by Specific Users on Specific Database Tables
Hello Everyone! My organization is looking to implement a solution in SQL Server (2019...
Experimental Verification of the NKTg Law on 8 Planets (NASA 2024 Data, SQL)
Nguyen Khanh Tung Email: traiphieu.com@gmail.com ORCID: 0009-0002-9877-4137 -------------------------------------------------------------------------------- Abstract This article presents a numerical...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers