.

Use the ISNULL() function.

ISNULL(<value_to_test>, <result_if_null>)

-- sample data
CREATE TABLE #IsNullTestr(EmpID char(3), TermDate datetime);
INSERT #IsNullTestr(EmpID, TermDate)
  SELECT 'AAA', NULL UNION ALL 
  SELECT 'AAB', '2021-01-01' UNION ALL
...

You'll need to create two AD groups, one for standard users, who should not see the sensitive columns, and one for privileged users, who can.

Drop the 'all logins' group from...

GETDATE(), GETUTCDATE(), etc., are niladic nondeterministic functions.

A niladic function has no parameters. A nondeterministic function returns different values with the same inputs (the exact results of a GETDATE() call cannot be...

If you're running in a Windows domain, and looking for a way to have auto-password management for app service accounts, then look into Managed Service Accounts, such as Group Managed...

...

The Licensing Guide can be downloaded from https://www.microsoft.com/en-us/sql-server/sql-server-2019-pricing

You'll quickly note in that doc that there are a variety of ways to buy the licenses with several different enterprise...

Every value that is being sorted (and there are a LOT of them) are shown as 'Expr1140', 'Expr1141', etc. Those aren't the names of the columns in your tables (I...

Test failures are not included on your public transcript, nor is the score on tests you passed.

After you've reviewed the topics listed on the Microsoft page for the test, you...

Another key point is that you don't use SET inside a SELECT statement to assign a value to a variable, you just assign a value:

DECLARE @MyVal varchar(64);
SELECT...

You can't encrypt a read-only database. You can store a read-only database's files in an encrypted file system, though.

You have a few options:

• Use SQL Server TDE to encrypt the...

My question is, where did all memory go since buffer pool is size of 300+GB. Where should I be looking into?

At a basic level, SQL Server prefers to keep 75%...

Element names may not have spaces in them.

When the parser looks at <Shipper Reference> it sees an element named Shipper and an attribute named Reference, for which it is expecting...

Are you looking to transfer ownership (which does NOT change the schema), or to change the schema of the view from [viewschema] to [tableschema]?

If you wish to change [viewschema].[viewName] to...

What is the result of the query when run on Node B? Is the encryption showing progress in any of the AG replicas? The secondary replica will show 0% until...