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…
In this article, we will be discussing about how you can change the Database Owner in a SQL Server Database. About the “dbo” User in SQL Server In SQL Server, the dbo (Database Owner) is a special user that has all the necessary permissions to perform all activities in the database. This user exists … Read more…
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…
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…