use $($variablename) to see if it solves your issue.

As to password protected spreadsheets, I've not had to work on such things before.  I'll have to do a test to find out if the "ACE Drivers" have a...

Converting these excel files to csv files isn't much too much of an issue as I recently came across a powershell script which helps me to automate this piece...

you can retrieve the object_id of that object and then get the name form sys.objects for the returned object.

as a string replacement alone - do a replace of both brackets...

why do other uses need to see who can login on a server? that is on its own a security risk and should not be exposed by default.

If it is...

• This reply was modified 3 years, 11 months ago by frederico_fonseca.

Would there be any advantage(speed) to strip my backup even though my drive that I'm backing up to is part of a San where it's not on it own...

reading the manual is normally advisable as it does contain the information one is looking most of the of the times.

https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/export-csv?view=powershell-7.2

using columnstore is potentially one of  your other issues - while it is GREAT for space saving and for aggregation style SQL it can perform badly for plain joins to...

Jeff - I do believe that the sample supplied with 2 digits and "." as separator  is only how its displayed and not how its stored.

I would query why that is a requirement - in a properly designed cube a good analysis tool that can accomplished that within the tool (SSAS or similar) using their...

and do be aware that Data Masking in SQL server can be broken very easily if you can do queries directly to the DB - so avoid at all cost.

you can download the older versions - see https://visualstudio.microsoft.com/vs/older-downloads/

note that limit is per database - nothing preventing the developer to have 20 databases - and the big tables each on their own databases, and a master/driver database with...

adding to this - the more complex queries are also using tables without ANY index at all - so lots of table scans (HEAPS to be more precise) - so...

do you mind running this again and ensuring that the dbname is correct

select snapshot_isolation_state
     , snapshot_isolation_state_desc
     , is_read_committed_snapshot_on
 ...

• This reply was modified 3 years, 11 months ago by frederico_fonseca.