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

In this article, we will be discussing about, how to import and export unstructured data in SQL Server, using the IMAGE datatype.   Introduction 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, … Read more…

Windows Internal Database (SSEE)

In this article, we will be discussing about the Windows Internal Database (SSEE), what it is and how you can access it via SQL Server Management Studio.   About the Windows Internal Database The Windows Internal Database is a special variant of Microsoft SQL Server 2005 Express. It is included with Windows Server 2008, Windows … 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…

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…