For personal finance a really critical thing to do is make sure you get your statements when they are expected and you review and file a report if there were...

The first thing I recommend at work to get started with this process is to move the relevant parts of email into a group platform, in my case either a...

Eric, to make the discussion interesting, I'll outline benefits of modernizing your process on Windows:

1. Windocks Windows SQL Server containers are delivered as named instances, so maintain all the...

<forgot to add the quote, is there an easy way to delete this?>

• This reply was modified 4 years, 6 months ago by Robert Sterbal.
• This reply was modified 4 years, 6 months ago by Robert Sterbal.

Could you add to the conclusion the time it would take to have done the migration without log shipping?

It took us 30 minutes (versus X minutes)

This sure looked like a great list of potential SQL Smells could be derived from this list.

Here is the macro I use in my personal.xlsb that eliminates the errors I get when pasting data from SSMS:

Sub SelectAllFormatAsText()

'

' SelectAllFormatAsText Macro

'

'

Cells.Select

Selection.NumberFormat = "@"

Range("A1").Select

End Sub

If you make the sheet text only it doesn't

I think what Excel is poor on is documenting the way they process the data.

Looks like a zoom password

If you can send me a file I'll give it a whirl on how I would process it.  robert@sterbal.com

As far as I know Excel uses the same logic for converting typed, pasted and imported text. If you select a sheet can switch it all to text, everything is...

It takes less than 10 keystrokes to convert a column to text. (Ctrl + space, alt + 1, alt + C, t, t enter)

I'm getting the impression that you think...

In nearly 30 years of using excel there are very few situations that don't have a straight forward work around.

I too was surprised that this piece was about BMW and not Tesla

Just curious how many of us use case insensitive fields?