Tag Archive: Database

Apr 11

How to: Configure Remote SQL Server Logging for TMG 2010

How to: Configure Remote SQL Server Logging for Microsoft’s Thread Management Gateway (TMG) 2010 Microsoft’s Thread Management Gateway is a solution that aims at providing advanced firewall and reverse proxy capabilities to the enterprise. Unfortunately Microsoft won’t be releasing new versions in the future so I haven’t been writing much about it lately; However, many …

Continue reading »

Feb 12

How to: Get the size of your Databases in MySQL Query Browser

How to: Get the size of your Databases in MySQL Query Browser Imagine you want to transfer data from one server to another and you need to know the size of the databases you are thinking of transfering. Unlike Microsoft SQL Server which graphical interface allows you to see the size of the database files …

Continue reading »

Dec 21

MySQL: How to list all available tables in the system

MySQL: How to list all available tables in the system Because sometimes you just need to know (the available tables are out there so you can use that list in a script). If you are running MySQL Workbench you can execute the following SQL Query and export the results to a file: select table_name from …

Continue reading »

Dec 10

How to: Reset the Auto Increment value for a MySQL table

How to: Reset the Auto Increment value for a MySQL table Although this is something most people won’t need to do, there are some scenarios where you want to reset the ID value you have in a column. In my case for example, I am working with WordPress and the blog ID is set based …

Continue reading »

Nov 07

How to: Connect to a MySql server using SSL from a WordPress Site

How to: Connect to a MySql server using SSL from a WordPress Site Truly you could title this post simply How to Connect to a MySql server using SSL from a PHP application. The key is in the connection construct, which by default in WordPress it looks sort of like this: $this->dbh = mysql_connect( $this->dbhost, …

Continue reading »

Nov 06

How to: Improve the performance / speed of WordPress sites running in IIS

How to: Improve the performance / speed of WordPress running in IIS To be entirely honest I am still struggling with this topic. However I have identified a few points that should help improve the performance / speed of a WordPress site running in IIS. Now, if a distinction should be made it would be …

Continue reading »

Nov 01

Resolve: DPM 2012 R2 Installation error “DPM configuration failed (ID: 4081)”

Resolve: DPM 2012 R2 Installation error “DPM configuration failed (ID: 4081)” When installing Data Protection Management on a remote SQL server you might come across a few issues like the running credentials on a SQL server and configuration error 4081. In the first case you are asked to run SQL Server Services under either computer …

Continue reading »

Oct 27

What is: Circular Logging in Microsoft Exchange Server

What is: Circular Logging in Microsoft Exchange Server I had some issues with an Exchange Server and had to perform a restore operation. While doing so I noticed that even though the user mailboxes were not huge, the size of the mailbox store was. As I read more about it, Exchange maintains the Mailbox Database …

Continue reading »

Aug 20

SQL Server 2012: How to copy a database from one server to another using the Copy Database Wizard

SQL Server 2012: How to copy a database from one server to another using the Copy Database Wizard I was provisioning my SQL box when I found I didn´t need an already provisioned Windows Server box I had used for Exchange 2013. Lazy enough I installed SQL Server 2012 on my already installed Windows box. …

Continue reading »

Older posts «

Fetch more items