you can setup Kerberos: https://docs.microsoft.com/en-us/sql/azure-data-studio/enable-kerberos?view=sql-server-ver15

Otherwise, you have to use sql auth

Yeah, I forgot about Dragon. completely inconsistent, one time it would work perfectly and I'd feel like I was living in the future. Then it would be complete trash...

If you run RESTORE MASTER KEY, you need the password from the BACKUP MASTER KEY statement in the "decryption by password" options.

The password used in the "encryption by" is what...

And now, how to put the brakes on a migration project...

Break your wrist on a bicycle ride so you only have one hand to type with and no immediate...

EXEC sp_configure 'default language'

It's not quite clear what you want here. What would the SELECT statement include?

The scripting engine in SQL Server produces the DDL code for the object, but does not include...

You might edit the subject, as it's not clear what you want. You put in the start of a statement rather than a description like "Looking for someone to join...

Use an AND, is what I think. I'm not quite sure how you're doing this, but when you evaluate the ISNULL(), I assume you can access both the value of...

No.

The password you use when you create the master key is used to open it if you break the hierarchy of allowing the Service Master Key to automatically open it.

The...

I certainly don't recommend two jobs, and I do think if you had two dev jobs, you'd get burned out.

Last guy, well, this one is just unbelievable, but he was working for a competitor the WHOLE TIME he was with us. Like a couple of years. working...

That appears to be the issue. If I use NULLS, with this code:

CREATE TABLE ProductSample ( [ProductName] varchar(100), [ProductLevel1] varchar(20), [ProductLevel2] varchar(20), [ProductLevel3] varchar(20) )
INSERT INTO dbo.ProductSample
...

Thanks, Martin. I'll experiment with that. I wasn't sure what this meant from the docs, and when working in a Power BI Data model, it can  be hard to tell...

Re: the value of a commute.

In 2002, I was looking for a job. Just prior to starting to work FT for SSC. At the time, I interviewed with a lot...

The office cost is the big item, and I think it's like the cloud v my data center. If I own the data center and equipment, not sure the cloud...