Hi Jeff,

Thanks for your reply. The script i included here is just a part of the long script. I did not see any other way to achieve what i...

You'll just love...

Hi everyone

I am getting error

Arithmetic overflow error converting expression to data type smallint

The calculation I am doing is producing very small numbers like 0.0000005328.

How can I fix the calculation...

Why are you doing this in PowerShell?

Correct.  That's why I have them witness the runs.  And, as a DBA, I...

READ THE ARTICLE AND YOU'LL KNOW AS LEAST ONE WAY!

We need a reference value to see which scripts has a high popularity because we didnt want to search in more than thousand scripts. We only want the scripts...

No plans to update the execution plans book...

When a backup starts, a marker is placed in the transaction log. Any transactions that are completed when the backup is done, are then backed up. Any transactions that...

Thanks for taking the time to write this article, Kathi.

What's even worse than what you mention is that the quality of the "official" documentation has totally tanked as...

-- here are the basic DDLs for my two tables:

CREATE TABLE [portman].[dbo].[AgentHours](
[LoginEntryID] [int] IDENTITY(1,1) NOT NULL,
[DOMAIN] [varchar](4) NOT NULL,
[DATE] [date] NOT NULL,
[LOGIN TIMESTAMP] [datetime2](0) NULL,
[LOGOUT TIMESTAMP]...

Grant,

Didn't you say that you were coming out with the 4th Edition sometime in the first half of next year (2022)?

I was having a look at some of the raw files to upload to the tables and realised that I missed pointing out that some of the source files...

Thanks, Jeff. Truly appreciate your help with this!

The only thing that I remembered was that the files were built from Excel files.  What I didn't remember was that you...

Did you update your SSRS and migrate your reports, as well?