Essential SQL Server Development Tips for SQL Developers

Hi friends. Finally, after months of hard work, I’m proudly announcing the release of my new online course, titled: “Essential SQL Server Development Tips for SQL Developers“. In this course, via a combination of lectures, downloadable resources and over than 30 live demos/hands-on guides, you will learn many useful SQL Server database programming hands-on tips, … Read more…

How to Suppress the “N Row(s) Affected” Output Message in SQL Server

Sometimes, when working with T-SQL scripts, you might want to skip the message “(N row(s) affected)” message. This article explains how to suppress the “N Row(s) Affected” output message in SQL Server.   About the N Row(s) Affected” output message in SQL Server You get this message when you execute T-SQL statements or stored procedures … Read more…

The STRING_SPLIT Function in SQL Server

A long-awaited string function added to SQL Server 2016 (and later) the is STRING_SPLIT function. Read on to better understand this cool function and see examples of how you can use it.   What does the STRING_SPLIT Function in SQL Server do? As the name implies: this function splits the given character expression using the separator … Read more…

Built-In JSON Support in SQL Server and Azure SQL Database

In this article, we will discussing about built-in JSON support in SQL Server and Azure SQL Database.   What is JSON? JSON stands for JavaScript Object Notation and it is widely used for data representation in the data services world. With built-In JSON support in SQL Server and Azure SQL Database, you can format query … Read more…

How to Import and Export Unstructured Data in SQL Server – FILESTREAM

A few weeks ago I posted an article on how to import and export unstructured data in SQL Server by using the “image” data type. In this article I will show how you can manipulate unstructured data in SQL Server 2008 or later by using the FILESTREAM feature. FILESTREAM allows storing unstructured data (i.e. music, … Read more…

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…