Posts Tagged ‘database’

Why does allocating large databases take so long by default with Microsoft SQL?

A common problem which occurs when going to allocate a new database in Microsoft SQL is an extremely long operation which will occur by default due to a disk zeroing operation that is performed when creating a new database. By default this will take a very long time even on the most powerful of database servers.

Memcached

Memacached is a high performance caching system mainly used for MySQL. It is used to speedup the dynamically loading web-pages by reducing the load on MySQL. Why it is important and how it works Suppose you are having a dynamic website which mainily works with databases. Each time a user accesses the website, database is [...]

Realize high availability of your Exchange 2010 mailbox database with a DAG

What is a DAG?  A DAG or database availability group is a new feature introduced in Exchange Server 2010 that enables high availability of Exchange mailbox databases.  So what’s so great about a DAG?  In previous versions of Exchange, high availability was possible, but required Exchange servers to be clustered when initially installed, required dedicated hardware [...]

Edit Sharepoint lists in Access

Sharepoint comes with a fair amount of functionality built in for creating and editing lists.  However, Sharepoint also allows users to open up a list in Access.  Access has many more features for editing database lists.  I found it most helpful recently for migrating data off of an old Access database for tracking inventory to a new Sharepoint [...]