If you'd like to find out how long it is until next Sunday (or how many days have passed since last Sunday), simply use the property DayOfWeek. It...
posts
Launching Applications with Alternate Credentials
If you must run an application with a different identity, Start-Process offers the parameter -Credential. This would launch the Notepad editor using...
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 ......