i think it is the query that is passed to the send mail task...that query gets executed in a different context.
change this:
SET @alert_query = ';WITH event_data AS...

tempdb is used internally to handle things that require sorts...ORDER BY in a select that is not satisfied by an existing index, or sorting the data first, in order to do...

it's the Modulus operator
0 / 3 = 3 (integer returned, as 3 goes into ten three times, with one left over
10 % 3 returns 1(the remainder)

in...

this was really neat Bill, I like it;
the thing i wanted was to also see a perfect score alongside the actual score, since longer strings would return larger scores

If there were no known changes, I would assume that the Primary Domain Controller was not available for a moment, and just rerun the job.
if it fails again, that's...

;WITH MySampleData([ScheduleID],[Location],[StartDate],[EndDate],[Site])
AS
(
SELECT '1','LocationA',CONVERT(date,'8/3/2017'),CONVERT(date,'8/4/2017'),'Site1' UNION ALL
SELECT '2','LocationA','8/3/2017','8/4/2017','Site2' UNION ALL
SELECT '3','LocationA','8/5/2017','8/6/2017','Site1' UNION ALL
SELECT '4','LocationA','8/5/2017','8/6/2017','Site2'
)

select Location, StartDate, EndDate, MIN(Site) AS Site

AES encryption results in an encrypted string that is still text, so that might require only an enlargement of the field size, and not a data type change.

I demoed...

a public site means you do not know or care who is connecting. you are presenting a limited set of data to the end users.

so the web page,...

there is more script more than just the logins!
Have you created any server roles(i have a server role to allow read any db for auditors and junior dbas)
How about any...

is your source a stored procedure call, or a query?
a stored procedure call would need SET NOCOUNT ON as, multi statements, like workign with temp tables, affects the way...

how are you determining that CDC is not capturing changes?
CDC reads the log asynchronously, but it reads the log, so it cannot really miss any changes, right?
are you...

sp_help_revlogin works all the way through SQL2016 and beyond, so stick with that, or it's enhanced user-contributed cousin sp_help_revlogin_roles[/url]

as far as changing domains, if you can guarantee that mydomain\lowell...

I don't have a psotgres linked server any more, but the key was how adding or subtracting to a date is different.
CURRENT_TIMESTAMP and CURRENT_DATE give you GETDATE() or getdate() with no...

Something additional I'm noticing: for the seven tables that have inaccurate row counts when compared to actual counts,
Those are tables that are populated with a TSQL MERGE statement from a staging...

I've had a couple of aha moments, and like Kevin3F noted, it for things that are outside of SQL servers control, but inside the DBA's sphere of responsibility.

the first big...