Your choices are:

• Windows Authentication, or
• SQL Server and Windows Authentication (aka 'Mixed Mode')

There no such thing as 'SQL Server only' authentication.

Aliases can get you pretty far once you set up a little automation.

Aliases are stored in the Windows Registry (at least on Windows machines). Once you've created an Alias, you...

The above example could be turned into a single statement:

-- Note:uses the #XMLParse table from the previous post

-- These two values would be passed in as parameters
DECLARE...

You can pull this off with a few extra steps to split the input XPath into separate variables for each level in the XPath, and then performing the node test...

How do you explain anything to the chiefs? Use their language.

MONEY

There are costs associated with both your approach and the one taken.

There are financial benefits to be realized from both...

The contents of "attributes" is an array, so you must further shred each row by passing the "attributes" array into another OPENJSON call through OUTER APPLY. This produces one row...

from https://techcommunity.microsoft.com/blog/azuresqlblog/hosting-ssrs-databases-in-azure-sql-managed-instance/1700197

If your SSRS reports are pulling the data from databases hosted on Azure SQL Managed Instance, consider hosting report server databases on the same instance, thus minimizing the database...

To pull off multiple aggregations in a single pivot, just code it yourself:

WITH CountsAndSums AS (
  SELECT County, DiagnosisGroup, 
      ...

Any connection accessing a database will, at the very least, hold an S (Share) lock on the database. That S lock prevents others from taking exclusive control of the DB...

• This reply was modified 10 months, 3 weeks ago by Eddie Wuerch. Reason: added BOL link to sys.dm_tran_locks

Upgrading a cryptographic provider can be accomplished without restarting the instance or dropping the provider, with the key provision that this only works if the name of the provider file...

When you declare @id, its initial value is NULL. When you concat NULL to any other string, the default CONCAT_NULL_YIELDS_NULL connection setting will result in a NULL string.

Initialize @id with...

Also check what the product is doing - I've been places where threat scanning involved a product throwing a laundry list of known exploits at each of the SQL Servers...

There's a free SQL database option: https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql

100,000 vCPU minutes/month, 32GB max DB size. You can set the "Behavior when free limit reached" option to 'Auto-pause the database until next month'...

You're working too hard. You can do decimal math on datetime values; 1.0 = one full day, 0.5 = 12 hours, etc:

SELECT getdate() AS [Now], getdate() +...

ADF feels like 'the next version of SSIS, but in the cloud', IMHO. SSIS/SSDT are free; if you have access to materials to help you learn the on-prem tools, then...