If you must run an application with a different identity, Start-Process offers the parameter -Credential. This would launch the Notepad editor using...
blog
Configure SQL diagnostic manager for non-standard ports
SQL Server uses the port 1433 as its standard listening port. Hackers know this and will use it to more easily hack into your SQL...
Manipulating Scheduled Tasks
If you need to change and adjust settings in a registered scheduled task, there is a COM interface called 'Schedule.Service' that you can...
Dumping Scheduled Tasks
There is an underestimated option to make schtasks.exe dump scheduled tasks as CSV data. PowerShell can grab the CSV data and turn it into objects,...
Create Strongly Typed Hash Table
A hash table can store any data type. If you want more control, you can create a typed dictionary (which behaves pretty much like a hash table): $ht...
Why Back Up the Transaction Log if not Interested in Point-in-time Restore?
I’ve heard people say many times that they don’t use full or bulk-logged recovery model or backup the transaction log of their database...
Make Your PowerShell Scripts Click-runnable
If you are like me, you hate having to type in the full path to a PowerShell script to run it.Wouldn’t it be nice if you could just execute...
Is Using RECONFIGURE WITH OVERRIDE dangerous?
One of my pet peeves is the use of RECONFIGURE WITH OVERRIDE in scripts to change server options. Am I being unreasonable or is this justified? All...
Increase SQL Server Performance Using Multiple Files
By default, SQL Server databases are comprised of two files: the primary data file (or .mdf) and the log file (or .ldf). It is, however, possible to...
Getting the Permissions Wired-Up Properly When Attaching a Content Database to a SharePoint Farm
You’ve probably heard the latest news in the SharePoint world: SharePoint 2013 has been released to manufacturing (RTM)! We’ve been told...
BUMMER
USE mysql; SHOW FULL TABLES WHERE table_type = 'base table'; /* returns ... innodb_index_stats BASE TABLE innodb_table_stats BASE TABLE ......
Top MySQL Blogs You Should Be Reading
There's a lot happening in the world of MySQL and it's really vital to be up-to-date with the latest advancements in this field to stay ahead of the...
Okay, Really – What Can I Do with a SharePoint Farm Configuration Database Backup?
I’ll cut straight to the chase: no, a configuration database backpastedimage1478188484999v3.pngup is not just a fancy paperweight. The prevailing...
Don’t Forget Application Caching to Boost SQL Server Performance
When it comes to SQL Server performance, many organizations look to their DBAs to help fine-tune hardware configurations, optimize indexes, or weed...
Tips for Optimizing XML in SQL Server
I’ve worked on a project that used XML heavily inside SQL Server. We really utilized SQL Server’s XML support almost to the full extent,...
Character sets in MySQL – still not for Windows users.
Recent MySQL versions (first the chaotic series of releases that preceeded 5.5 - 5.2, 6.0 and 5.4 - and now 5.6) adds new 'character sets'...
Consider Your Collations Carefully, Or Pay Later
When first installing SQL Server, many developers and DBAs new to SQL Server may have the temptation to click Next, Next, Next on the installation...
Ensure Proper SQL Server Connection Pooling
Coming to SQL Server from both a database developer and DBA background, I maintain that while tuning SQL Server’s ability to handle your application...
Monyog Custom Counters – overcoming a problem.
In this previous Blog I described an example on how to build a Custom Object in MONyog. But there is one problem you may encounter and that is, that...
Log security and log tables.
Accidentially I came across the statement "SHOW GRANTS requires the SELECT privilege for the mysql database." in MySQL documentation...
How to add a simple Custom Object in Monyog
MySQL is developing rapidly. And today it does not only happen along a single track but in multiple directions simultaneously. This is due to both...
How to Make a Copy of a Database on Windows Azure SQL Database
Windows Azure SQL Database (previously SQL Azure) offers a unique way to make a database copy to another database using the CREATE DATABASE as COPY...
Per-database information in performance_schema, please!
This is a follow-up om my first Blog on performance_schema that appeared here: One particular request that we had frequently from our users is to...
FLUSH STATUS surprise?
What does FLUSH STATUS do? We all know that it will simply reset all status variables (except for 'uptime') to same values as immediately...