drsql@hotmail.com


SQLServerCentral Editorial

What is time?

There was a post on X I read today about valuing your time. The gist was that since this person had waited 9 minutes to save $4, they valued their time at $27 an hour. I get the point being made. Time is valuable and you need to set the value of your time. It […]

You rated this post out of 5. Change rating

2025-03-01

75 reads

SQLServerCentral Editorial

Technical Pain Behaviors

In my family’s history of the past 10+ years, we have become well versed in nagging, ongoing, non-debilitating pain. In some ways, the lessons we have learned about physical pain correlate all too well to the types of pain that we technical people are involved with daily. But there is a huge difference, even if […]

You rated this post out of 5. Change rating

2025-01-25

73 reads

SQLServerCentral Editorial

Subscribing to a Great New Year

It is December 27, and the most significant day of the year for reviewing your life is quickly approaching. New Year’s Day is probably the most positive day of the year when people, in all manner of situations, think back to the previous rotation around the earth and decide what they will do better this […]

You rated this post out of 5. Change rating

2024-12-28

46 reads

SQLServerCentral Editorial

Lies You Should Believe - Anything is possible

We have all heard the saying I based this week's editorial on. It has been credited to Benjamin Franklin and goes like this, “You can do anything you set your mind to”. This is such a powerful way of thinking when you are starting a task. “I can do it, no matter what anyone says.” […]

You rated this post out of 5. Change rating

2024-11-30

94 reads

SQLServerCentral Editorial

PASS Summit Time

As the Simple Talk Editor, I have had the privilege of attending numerous conferences these past few years, and all of them have been somewhere between great and amazing. Still, there is something a bit more special about the PASS Summit. Even before I started this position, I have been to the PASS Summit events […]

You rated this post out of 5. Change rating

2024-11-02

34 reads

SQLServerCentral Editorial

Being an extroverted introvert at a conference

As I start this editorial, I am sitting at a PostgreSQL conference in New York City during the nighttime reception. The sound of 100 voices is not quite deafening, but it is certainly loud and understanding anyone in this group would be hard. It is also hard because I only know about four people at […]

You rated this post out of 5. Change rating

2024-10-05

63 reads

SQLServerCentral Editorial

Knowing What You Don't Know

I used to think I knew everything. I felt like I had the world all figured out. But then, when I went to kindergarten, I realized that I didn't know much at all. As I grew older and finished college, I regained confidence in my knowledge and again felt like I knew everything about the […]

5 (1)

You rated this post out of 5. Change rating

2024-09-07

109 reads

SQLServerCentral Editorial

Do You Have the Gifts to Be a DBA?

This editorial was originally published on Jul 13, 2019. It is being re-run as Steve is out of town. I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. […]

3 (2)

You rated this post out of 5. Change rating

2024-08-21 (first published: )

588 reads

SQLServerCentral Editorial

Getting and keeping fit

Don't worry, this is a technical editorial, but the initial analogy starts a bit personal. For the past decade, I've been on a journey to get fit, facing setbacks along the way, such as surgery complications and broken bones, torn cartilage, and, most recently, broken metal implants. Throughout this time, my overall physical fitness has […]

You rated this post out of 5. Change rating

2024-08-10

77 reads

SQLServerCentral Editorial

The Danger of Safety Assistance Tools

During a speaker dinner the other week, a lot of topics were swirling around and a few caught my ear. One of these topics dovetailed nicely with a mistake I recently made. More on that later. The discussion was on the effect on safety that all the new safety-based tech is having on driving. Some […]

You rated this post out of 5. Change rating

2024-07-13

69 reads

Blogs

Who are you? Building an identity map.

By

I admit that until I read the article, Who are you as a Leader?,...

Call a Fabric REST API from Azure Data Factory

By

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...

Distributed Availability Group Dashboard

By

The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...

Read the latest Blogs

Forums

temp table columns not showing up in CTE

By DBA_318

I'm new to the development side of the house and stuck on a CTE...

SSAS Cube Migration to Azure cloud

By bala2014

Dear All, I am currently working on a Proof of Concept (POC) where I...

create a table with data capture for next 3 years

By anug

Hello, I would like to build a table capturing data starting from 1st day...

Visit the forum

Question of the Day

Local Storage Options

I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?

See possible answers