You should not have sa being used for SSRS, ETL, etc. It's a recipe for problems, and it's a security risk. Create separate, non-sysadmin, accounts for each access.

If you're struggling...

🙂

OK, this is a blown question. I meant to specify Azure SQL Database and did so in the tag, but not the question. I have altered that to be clear.

In...

Perhaps. I think that trade was made, but people are rethinking it....

I bet it's a split, but we get more WFH options. once companies see some things work, they will. I also think orgs will struggle to say Lynn's ex can...

Again, this isn't about whether the government should or shouldn't, but rather the challenge for us in complying and the issues we may face as data professionals.

Glad you learned something. That's most of what I'm trying to do with these.

Glad you liked it

SELECT [name], s.database_id,
COUNT(l.database_id) AS 'VLF Count',
SUM(vlf_size_mb) AS 'VLF Size (MB)',
SUM(CAST(vlf_active AS INT)) AS 'Active VLF',
SUM(vlf_active*vlf_size_mb) AS 'Active VLF Size (MB)',
COUNT(l.database_id)-SUM(CAST(vlf_active AS INT)) AS 'In-active VLF',
SUM(vlf_size_mb)-SUM(vlf_active*vlf_size_mb) AS 'In-active...

Side issue. I am more interested in the challenge of adapting quickly and maintaining adherence to legal requirements for data professionals.

Disclosure: I work for Redgate Software, and we have tools to make this easier.

https://www.red-gate.com/

However, the problem of having items in a release is really a VCS issue. I assume...

I'd set up auditing or xevents to try and capture what's happening. If this is some automated process, you should capture some items. If this is a person, they might...

I've struggled with tackling projects. I have done a bit more cleaning (no maid right now), but I also need a break.

One thing my wife has enjoyed each year is...

IIRC, it makes concurrent inserts faster since each person doesn't necessarily create as much locking. Not sure it helps with just a couple connections.

Auditors to get worried, and rightly so....

I do wonder about the future of virtual work. Depending on how this month goes, and how managers are rated afterwards (bonus, review, etc.) we may get more or less...