drsql@hotmail.com


SQLServerCentral Editorial

You Are An Inspiration

Hero, Champion, Inspiration. These are words that are bantered around about people regularly. Joe was a hero when he saved that puppy. Betty was the champion runner and won the race. Pat was an inspiration; they work so hard. Hero and champion are universally understood as positive things. Inspiration is typically used as a positive, […]

You rated this post out of 5. Change rating

2023-11-25

44 reads

SQLServerCentral Editorial

A rose by any other name would not be a rose

William Shakespeare once wrote in the play Romeo and Juliet: “What's in a name? That which we call a rose, by any other word would smell as sweet.” It is a beautiful sentiment in that context, and even still you might say that there is some truth to this saying in a lot of ways.  […]

You rated this post out of 5. Change rating

2023-11-04

63 reads

SQLServerCentral Editorial

Confidence

Today, I want to blog about something I have only limited knowledge of … confidence. Okay, I understand what confidence is, and I have seen it before in the real world and not just in biographical movies. In fact, I have met quite a few highly confident people. In almost every case, it was immediately […]

5 (1)

You rated this post out of 5. Change rating

2023-10-07

63 reads

SQLServerCentral Editorial

What Counts For a DBA: Manners

When most people were young, they had someone telling them to "Mind your manners." Such classics as: "Keep your elbows off of the table," "Use a fork," "Put on deodorant," as well as "Don't chew with your mouth open" were bandied about like there were laws of nature. However, manners differ significantly from laws in […]

5 (2)

You rated this post out of 5. Change rating

2023-08-12

97 reads

SQLServerCentral Editorial

Keep your Resume Reasonable

The other day, I was in a Twitter discussion interviewing people for technical positions. This reminded me of one of my favorite things to do in interviews… reading the list of qualifications/skills and asking questions about its contents. If you put it on the resume, I assume you know something about it and are willing […]

You rated this post out of 5. Change rating

2023-07-15

94 reads

SQLServerCentral Editorial

Software Flexibility (Avoiding the next hack)

As computer scientists, it often feels like our job is to tell the business user, "No, we can't do that because the software you asked for, and we built, doesn't allow it ..." Then, after a long and relatively silly meeting where your soul dies a little, the business user typically gets 80% of what […]

5 (2)

You rated this post out of 5. Change rating

2023-06-10

88 reads

SQLServerCentral Editorial

Empathetic Design

An old sport saying goes like this “I could beat them with one arm tied behind my back.” Well, after six weeks with my arm in a sling, I am in awe of whoever tries that because everything is a lot harder. Like washing your hand and then drying it, becomes more of a challenge […]

5 (1)

You rated this post out of 5. Change rating

2023-05-20

80 reads

SQLServerCentral Editorial

Review Early and Often

Several years ago, I was brought in on a project to review a database design. I was provided a time for a meeting. No written requirements were available, but I generally knew what the system was supposed to do. No before/after schema images showed what was being changed were available. Still, I was assured that […]

4.75 (4)

You rated this post out of 5. Change rating

2023-03-25

83 reads

SQLServerCentral Editorial

Consider Sharing Your Knowledge At User Groups and Conferences

The first time I spoke in front of a group of people over 20 years ago about a programming topic, I was scared to death. I could barely sleep the night before, obsessing about the material and practicing it repeatedly. When I finally did sleep, it felt like minutes before I awoke, and it was […]

You rated this post out of 5. Change rating

2023-02-25

65 reads

SQLServerCentral Editorial

Fear of "What If"

Fear and aging. Two of the things that most human beings have in common is that we are scared and getting older. Most of us we fear getting older, but that is a very different conversation altogether. I want to talk about the fear of what if. Today I have two things I am keenly […]

5 (2)

You rated this post out of 5. Change rating

2023-02-06 (first published: )

171 reads

Blogs

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Read the latest Blogs

Forums

txt file Pipe

By juliava

Hello, I need to put data from table to txt file as pipe on...

Case statement to insert a new line in query output??

By jbalbo

Hi I need to insert a new line of my output when a condition...

Database Mail to work on Azure VM

By terry999

Trying to get Database mail working sending via  outlook.office365.com or smtp.office365.com port 587 using ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers