connectionstrings.com suggested a slightly different syntax, but both are valid:

https://www.connectionstrings.com/mysql/

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Connection Timeout=5;

i think you can just modify the connection string in your shared data source.

by default, it looks something like this, just a servername and a databasename, but you can modify...

it depends on what you are after. one of the most common requests is to change every  other row for readability.

an example:

https://www.mssqltips.com/sqlservertip/3490/alternate-row-background-color-in-sql-server-reporting-services-tablix-and-matrix/

so in that example,the rownumber*() function needs teh...

• This reply was modified 5 years, 5 months ago by  Lowell.

without access to SQL, no you cannot find out.

if you have access to view server state, the DMV's for index stats has the last time an index was used to...

• This reply was modified 5 years, 5 months ago by  Lowell.
• This reply was modified 5 years, 5 months ago by  Lowell.

a pair of examples. if you are only looking for items that are 6 chars and start with P, vs stuffing a bunch of zeros into it no matter what...

i prefer the alter authorization command:

ALTER AUTHORIZATION ON DATABASE::[WSS_Content]  to  [MyDomain\SharePointServiceAccount];

i think you need to execute a script after the dacpac deployment.

a dacpac will create tables and objects, but there's no scripting involved, so no, no script can be appended...

holy crap the new format of the website plays holy hell with code i took a lot of time to comment well and make sharp looking.

here is an older example i used to use, that assumes you have a list of server sin Central Management Servers

for each server, i may run a query per server,...

• This reply was modified 5 years, 5 months ago by  Lowell.
• This reply was modified 5 years, 5 months ago by  Lowell.
• This reply was modified 5 years, 5 months ago by  Lowell. Reason: updated to working tested code with query provided

the six month/180 day evaluation is not that painful in a lab.

it is great practice to build machines over and over, join them to your lab's domain, and ideally, you...

oops i missed the variable value request.

you need the data type and the value:

$node.VariableValue.DataType

$node.VariableValue.'#text'

this was an interesting request for me.

i was able to do to this via powershell and shredding the xml of each dtsx package.

the script below scans a whole folder and...

auditing inserts is "excessively repetitively redundant", i would only audit updates and deletes, as you have the original data in the table, if no updates occurred. do you REALLY need...

• This reply was modified 5 years, 6 months ago by  Lowell.

I may be jaded on this one.

I have seen three separate start-and-fail-to-implement initiatives to use Master Data Management at my current work location,and a total of half a dozen implementations...

first thing i would look at was HEAP tables. unless you get a table lock, you could have rows that were deleted but never returned their space back to the...