What Is the Windows Internal Database: Microsoft introduced the Windows Internal Database (WID) with Server 2008 and it has been included with every version of Windows Server since. It is designed to be used exclusively for use by Microsoft products and can not be purchased or downloaded separately. During its development it Read more…
If you are having unexplained performance problems with your WordPress Site and you have already tried: disabling ALL your plug-ins – 99% of the time Add-In’s) are the problem with WordPress sites installing a AntiVirus and running a scan on the site – we strongly recommend the free version of Read more…
It is a common misconception that SQL Express 2016 cannot or should not be used in production environments. SQL Express 2016 (and SQL Express 2014 and 2012 and…) are most certainly licenced to be used in production at no cost. In fact, for most small and medium applications the only significant Read more…
If you have a SQL database stuck on RESTORING (see screen shot) the answer is likely to run a RESTORE command against the MASTER database. In my case I had been restoring one database over another (Production database into a Test database) and one of them got stuck… not funny. Read more…
If your SQL applications can’t send email using database mail (I assume you already have DBMail Account and Profile setup), there are two things to set: SQL MANAGEMENT STUDIO > MANAGEMENT > DATABASE MAIL > right click and select CONFIGURE… > select MANAGE PROFILE SECURITY > put a check on Read more…
There are several ways to produce the schema of a SQL 2008/2012 table but the on I use is: Open SQL SERVER MANAGEMENT STUDIO Expand DATABASES Expand the database in question Expand TABLES Right Click on the table in question Select SCRIPT TABLE AS Select CREATE TO Select FILE Enter Read more…
Microsoft cautions against “administration” of the Windows Internal Database (WID, formerly named SQL Server Compact Edition or CE) in articles like THIS one. However, there are time when you may want to gain access to it for things like: database moves (because the SQL WID is installed on C: whether Read more…