You very nearly had me jumping out of my seat until I remembered the date.  It's a real shame that MS hasn't fixed this.  I've had an open issue for...

You very nearly had me jumping out of my seat until I remembered the date 🙂  Its a real shame that MS hasn't fixed this.  I've had an open issue...

Hi,

As per the MS documentation (The highlighting is mine).

<mixed_page_allocation_option> ::=

Applies to: SQL Server (Starting with SQL Server 2016 (13.x))

Controls whether the database can create initial pages using a mixed...

• This reply was modified 10 months, 4 weeks ago by  Jeff_C.

You should have posted it anyway.  Then your status as a clairvoyant would have been confirmed 🙂

Looking forward to this becoming a reality as per SQL on Linux many years ago - 🙂

• This reply was modified 2 years, 8 months ago by  Jeff_C.

Due to things like auditing requiring an explicitly compatible version,  I had to create, a number of years ago, a function to explicitly load and then return a server object.  hope the...

We implemented AD Groups to manage access years ago and have a leavers process that ensures that people are removed from groups on the day of the departure / transfer. ...

Hi Alan,

Nice post. Very informative.  Generally I find that the smo objects are more easily interpretable than trying to access the information via TSQL,  so I had a...

We recently had to perform some backup and restore tests in order to estimate the impact of compressed vs non compressed backups and the effect they would have on our...

Hi John,

Great script. I just noticed though that the final output does not show deleted windows users. If you add a coalesce statement as below I think that...

I don't disagree, however in a number of companies, the DBAs provide container support and have no control over the actual implementation of the application. In that case we...

I think we are discussing two entirely different requirements here. One relates to a company / legal requirement to ensure that various activities are traced in their entirety irrespective...

lol - I had but thanks 😀

Agree totally!

One of the most frustrating things about the default tracee was the fact that one can not change the size and number of the rollover files. This meant...