Read our high-quality articles on SQL Server development. Learn how to efficiently develop data processes in the world’s biggest DBMS, that is SQL Server.
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…
Among the many cool things in SQL Server, a very significant one is the fact that SQL Server provides many built-in tools and mechanisms that allow you to import and export data easily. One day while working with SQL Server, I thought to myself “why not creating an online course demonstrating all these cool built-in … Read more…
About the “set identity_insert” Command in SQL Server The set identity_insert command in SQL Server, as the name implies, allows the user to insert explicit values into the identity column of a table. Now, someone might wonder, “why on Earth would somebody want to do that?!” Oh well, you know, there is always a good reason! … Read more…
What is the IDENTITY_CACHE Option in SQL Server? The IDENTITY_CACHE option, is a new database scoped configuration option in SQL Server 2017 and Azure SQL Database. This option is set to ON by default. The concept of identity caching in SQL Server is that the Database Engine stores in cache a series of values for … Read more…
SQL Server Management Studio (SSMS) for some time now, is not included in the SQL Server media. Instead, it is being provided as a standalone free program which can be downloaded from Microsoft’s website. The decoupling between SSMS and SQL Server Installation Media This is a good thing and I personally agree with this … Read more…
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…
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…
Temporal tables in SQL Server 2016 and later as well as in Azure SQL Database is a new type of user table which was was introduced in ISO/ANSI SQL 2011. Read on to learn more temporal tables and see a comprehensive example that uses them. What are Temporal Tables in SQL Server and Azure SQL … Read more…
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…
This article discusses the behavior of the BCP utility when extracting data from SQL Server tables to files and more specifically to CSV files. Example: Description Imagine that you have the below table: As you can see, records 2 and 3 contain null values. Then you export the table contents to CSV using BPC: bcp … Read more…
A few weeks ago I was contacted by Webucator, an online training provider that requested my permission to include one of my articles into a free video-training series called “SQL Server Solutions from the Web“. This is one of my articles on FileTables with title: “How to Import and Export Unstructured Data in SQL … Read more…
In this article, we will be discussing about, how you can easily list all tables of a linked SQL Server database. Introduction There are many scenarios in the DBMSs world where you might need to use a linked server between two different SQL Server instances in order to execute direct queries between them. However, the majority … Read more…
Good evening (or good morning) friends all around the globe! Wherever you are, whatever you do, wishing you a nice rest of the day (or night!) 🙂 This is the last of a series of posts that deal with the task of importing and exporting unstructured data in SQL Server. The first article of this … Read more…
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…
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…