Monday, July 10, 2017

SQL Server Configuration Manager error: Cannot connect to WMI provider Permission Denied

›
1. Open CMD as Administrator 2. Change Directory to cd C:\Program Files (x86)\Microsoft SQL Server\110\Shared --- ENTER 3. mofcomp sqlmgm...
Wednesday, June 14, 2017

Perfmon how to resize counter frame at bottom of the window

›
Workaround: When Performance Monitor opens, one or more default counters are in the legend pane and only the first is visible. The legend p...

Father's Day this Sunday

›
Shop Amazon Devices: Echo Father's day deals starting at $39.99

Visual Studio 2017 Rocks

›
Just switched over to Visual Studio Professional 2017 and it rocks!!!
Monday, June 05, 2017

JavaScript Refresh Time

›
There are 7 basic types in JavaScript. number for numbers of any kind: integer or floating-point. string for strings. A string may have one...
Tuesday, April 11, 2017

How to catch an error and send via email and log to the server (aka simple text file not event log). (VB.NET)

›
Catch ex As Exception             'Log to exception table             Dim strError As String             strError = Now().ToString() ...
Thursday, February 23, 2017

Count Columns in Table in SQL Server

›
SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = 'DbName' AND TABLE_SCHEMA = 'dbo' AND TAB...
Thursday, February 16, 2017

IIS App Pool Recycle Logs

›
If you need to view information about application pool recycle set a custom view in Windows Event Viewer. 1. Start Search Event Viewer 2...
Thursday, February 02, 2017

SQL Tips

›
http://sqlhints.com/2012/05/03/how-to-set-default-database-in-sql-server-mangement-studio-a-time-saving-tip/ Great new site I found above....
Monday, October 17, 2016

Regular Expressions

›
To match a string that contains  only  those characters (or an empty string), try "^[a-zA-Z0-9_]*$" This works for .NET regula...
Thursday, October 13, 2016

Page size calculation formula

›
Commit charge: 1. Run Performance Monitor (Perfmon) 2. Go to Data Collector Sets\User Defined 3. Right click on User Defined and sele...
Tuesday, September 06, 2016

DBA Secret KeyStroke by Jason "CPT SQL" Miller

›
ALT+F1 with Object Highlighted in SSMS all you ever wanted to know (aka Table Definition) and if your other developers never teach you this,...
Friday, July 22, 2016

Rest hiberfil.sys by Alex --- Awesome article. Source - http://thetechcookbook.com/reset-hiberfil-sys-file/

›
Reset hiberfil.sys file by  Alex   September 5, 2014   Windows 7   Comments:  1 If the Hiberfil.sys file located on your local har...
Wednesday, July 06, 2016

Microsoft Azure - www.mmwebs.biz

›
On the 4th I have moved www.mmwebs.com to use Microsft Azure, still some configuration to go, but thus far everything is running.  Custom do...
Monday, June 27, 2016

.NET Authorization note to self

›
Authorize only 1 person(s) and deny all others and anonymous. <authorization>                <allow users="you@email....
Tuesday, May 24, 2016

Moojjoo - nuget.org Package CyberSource Akamai

›
https://www.nuget.org/packages/UnofficialCyberSourceByMoojjoo/
Thursday, May 19, 2016

First NuGet Package Published

›
Feeling pretty good about my career with my first NuGet Package.  I hope this helps out other .NET Developers with CyberSource Transition on...
Friday, May 06, 2016

Update Incrementer with T-SQL instead of using a cursor

›
SQL TIP: Auto Increment in an UPDATE statement. - Credit -  http://haacked.com/archive/2004/02/28/sql-auto-increment.aspx/  DECLARE @ c...
Friday, April 29, 2016

Thank you XML and NotePad++

›
Use the  XML  Tools plugin for  Notepad++  and then you can Auto-Indent the code with Ctrl + Alt + Shift + B .For the more point-and-click...

Windows 7 - Change Login Screen

›
Reference and Credit -  http://www.tomshardware.com/forum/52395-63-change-windows-splash-screen-lock-screen click start type regedit and h...