Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
 
The Voice of the DBA
 

I Can't Make You Learn

Oh, how I wish I could. How I wish I could coach, guide, inspire, or even bribe you to learn more about your job, or things related to your job, or even things in life. I wish all of you would improve your skills, but more, I wish you would want to improve your skills. I find lots of people who do want to get better, but far too often, people aren't trying to improve because they want to coast along at their jobs.

I get it. You're stressed and busy at work, though hopefully not too often. You have challenges at home, kids to raise, parents getting older, financial stresses, concerns about politics or sports or exercise or diet or just about anything in the world. We all have things that take mental energy in our lives. How/why/when should I add another thing to the list?

My view in the past has been that I invest in my knowledge and my skills because that helps me in the future. Whether that's learning to write better T-SQL, or it's learning a new thing about T-SQL, or it's learning how to find information about the new thing in T-SQL. Or it's something completely different. In the past, I've spent time learning to write better with a blog, knowing this might lead to a future job, but also to experiment and decide how much I liked writing. I've learned to organize presentations better, partially because I wanted to interest people in a user group, but also knowing this would help me argue for a raise or communicate well in an interview for a new job.

I thought about this recently as a fan switch went out at the ranch. We have a whole house fan that cools the house at night. Someone else installed it years ago, but the switch stopped working. My wife wanted to call someone right away, as none of us are a) electricians, or b) have worked on a hard-wired fan. However, I thought this couldn't be difficult. It's worth a small experiment. I ordered a part that was vaguely familiar to the broken switch, not having much confidence that it would work.

My son and I found the breaker (which was an adventure) and disabled it. We disassembled the switch, matched up wires, and replaced the switch. We turned on the breaker and were excited that the fan worked. We of course, had another adventure putting it back together as the first time things didn't work when we enabled the breaker, but we solved the issue. A couple of hours in total and $40 for a switch when it would have been easy to call someone and (likely) spend $150 or more.

I always ask questions when work is being done. Whether that's a tradesperson doing building or repair work or a fellow tech professional writing code, or a fellow marketer authoring content. I want to learn to be self-sufficient and more capable. Even if there are things I'd really never do and happily pay someone to do them, I want to know how they are done.

At the very least, I want to be able to judge future quality. That's a skill I need with electricians and AI technology.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 
 Featured Contents
SQLServerCentral Article

Why Your SQL Permissions Disappeared

deepeshdhake from SQLServerCentral

When you change a schema owner in SQL Server, all object-level permissions vanish instantly. There is no warning. Here's how to prevent it and fix it when it happens.

External Article

Correct SQL Server Always On Availability Group Not Synchronizing

Additional Articles from MSSQLTips.com

We had an issue with a SQL Server database in an Always On Availability Group (AOAG) where it was not synchronizing the secondary replica even though it was using the “Synchronous commit” Availability Mode for the secondary replica. This article explains how to troubleshoot and resolve:

Blog Post

From the SQL Server Central Blogs - Automatic Index Compaction

Jeff Taylor from Jeff Taylor

Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.

Blog Post

From the SQL Server Central Blogs - Setting Up a Mac for Data Engineering and AI Work

epivaral from SQL Guatemala

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac with Apple Silicon is genuinely one of the best machines you can have as a...

Architecting Power BI Solutions in Microsoft Fabric

Steve Jones - SSC Editor from SQLServerCentral

Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

BIT_COUNT II

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID  UserPermissions
15
23
37
4       NULL
What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Checking the Error Log I

On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?

Answer: sp_readerrorlog

Explanation: The current way to do this from T-SQL is with sp_readerrorlog. This replaces the undocumented xp_readerrorlog. Ref: sp_readerrorlog - https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-readerrorlog-transact-sql?view=sql-server-ver17

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


Editorials
Cognitive Coverage - Comments posted to this topic are about the item Cognitive Coverage
SQL Server Still Wins - Comments posted to this topic are about the item SQL Server Still Wins
Is Fabric a Reliable Service or a Ripped Resource? - Comments posted to this topic are about the item Is Fabric a Reliable Service or a Ripped Resource?
I Want to Use My Brain - Comments posted to this topic are about the item I Want to Use My Brain
Spending Time in the Office - Comments posted to this topic are about the item Spending Time in the Office
Article Discussions by Author
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About - Comments posted to this topic are about the item SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About, which is is not currently available on the site.
How We Handled a Vendor Retry That Loaded Twice in Snowflake - Comments posted to this topic are about the item How We Handled a Vendor Retry That Loaded Twice in Snowflake
Getting the Average - Comments posted to this topic are about the item Getting the Average
DBCC CHECKDB Limits I - Comments posted to this topic are about the item DBCC CHECKDB Limits I
Parameter Sniffing in Production: How a 200ms Query Became a 90-Second Outage - Comments posted to this topic are about the item Parameter Sniffing in Production: How a 200ms Query Became a 90-Second Outage
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values - Comments posted to this topic are about the item SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
BIT_COUNT I - Comments posted to this topic are about the item BIT_COUNT I
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments - Comments posted to this topic are about the item Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Multiple Values Inserted - Comments posted to this topic are about the item Multiple Values Inserted
SQL Server 2022 - Development
locking down agent for new user on our dev machine - hi , a new user wants to be able to add sql agent jobs on our dev machine.  i stood up a db there for him and will make sure his rights are on that db only.   how can i give him rights to set up and run agent jobs but with the constraint that […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -