SOLVED: Everything You Need To Know About the Windows Internal Database (WID)

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 was codenamed “Yukon” (which was SQL 2005) and the discussed publicly as “SQL Server Embedded Edition”.   The Windows Internal Database (WID) actually supports more than…

SOLVED: VIDEO: How To Migrate Your GoDaddy WordPress Site To A Different SQL Server

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 WordFence changing to one of the default WordPress themes (like 2015, or 2016) contacting your host’s technical support team – note that we are a…

SOLVED: What Are The Limits of SQL Express 2016 and Can SQL Express Be Used In Production?

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 difference between SQL Standard and SQL Express are performance and backup. SQL Server Standard provides a very high level of performance that many applications will not need. …

SOLVED: SQL Database Hung on RESTORING

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. After selecting the MASTER database to run the query against, the command is: RESTORE DATABASE <database name> WITH RECOVERY As you can see this fixed…

SOLVED: Cannot Send Email From SQL Database Mail Even Though The Account is Setup

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 PUBLIC option click on DEFAULT PROFILE (Yes, I know it does not appear to be clickable… but it is) and set it to YES SQL…

SOLVED: How to Export SQL 2008 2012 Table Schema

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 an name save the file You can then open the resulting SQL file with either Notepad or SQL QUERY Bingo… there is your schema! [ContactName]…