How to Import and Export Unstructured Data in SQL Server – The IMAGE Datatype

Importing and exporting unstructured data from a database is a common practice, especially in large applications. SQL Server 2008 introduced the FILESTREAM feature that allows storing unstructured data (i.e. music, video, documents, etc.) onto the NTFS file system and manipulating it via the Database Engine. SQL Server 2012 introduced FileTables which is an enhancement to FILESTREAM. With … Read more…

There was an unexpected failure during the setup wizard

OK folks, this is a little bit “tricky” issue. The scenario is the following: You are trying to install SQL Server 2005, then you stop the installation, let’s say because you got a warning on a prerequisite that you would like to fix before proceeding. However, in the case you abort the installation, fix the … Read more…

Product Review: SQL Search – Searching for SQL Text Within SQL Server DB Objects

Some time ago Red Gate released SQL Search, a SSMS add-in that allows the user to search for fragments of text within database objects in a SQL Server instance! Yes, I know, this is cool! 🙂 There are many scenarios where the tool can come in handy. For example, imagine trying to perform a modification … Read more…

Windows Internal Database (SSEE)

The Windows Internal Database is a special variant of Microsoft SQL Server 2005 Express. It is included with Windows Server 2008, Windows Server Update Services (WSUS), Windows SharePoint Services (WSS) and other Windows Server tools. It is also referenced as SQL Server 2005 Embedded Edition (SSEE). The Windows Internal Database is used by Active Directory, … Read more…

Installing 32-bit SQL Server 2005 Reporting Services on a 64-bit machine/Windows OS

Is it possible to install 32-bit SQL Server 2005 Reporting Services on a 64-bit Computer/Windows OS while keeping the 64-bit version of the rest of SQL Server features? The answer is yes! Well, here’s the story: I recently installed SQL Server 2005 on a 64-bit Windows Server 2003 OS.This was done within the context of … Read more…

Sample Databases for SQL Server

DBAs and Database Developers always need to test new database-related work before migrating it to Production Environments. To this end, Test/Development Environments are usually set up in order to allow for testing new administration and programmability features of DBMSs (in our case SQL Server 🙂 Though, by only having such an environment set up is … Read more…

SQL Server 2005 Surface Area Configuration Tool

An important security improvement in Microsoft SQL Server 2005 is that various of its features that could be potentially susceptible to security risks are turned off by default. One of these features is that the built-in administrator of the machine on which SQL Server 2005 is installed, it is not automatically included in the SQL … Read more…

Getting table index information in SQL Server

At some time today, I had to compare the indices of various database tables.To this end, I needed a fast way of getting index information for specific tables. In SQL Server, there is a system stored procedure (hosted in the master database) called sp_helpindex. The syntax for using it is the following: EXEC sp_helpindex ‘schema.table_name’ … Read more…