SQL Server Development

SQLArtBits: Free Online SQL Services

Three years ago, back in 2013, I founded the “SQLArtBits” community initiative. Under the SQLArtBits initiative we develop simple yet powerful data tools for the Microsoft Windows Operating System. The majority of our tools mainly interact with SQL Server, thus providing a richer user experience and enabling the user to…

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…