Working with Python on Windows and SQL Server Databases (Course Preview)

In this post, we are announcing the general availability of our online course: “Working with Python on Windows and SQL Server Databases“. Note that the course is currently available on Udemy.   What is this course all About? Python is a very popular programming language. Due to its simplified syntax, Programmers can develop a wide … Read more…

Tip of the Week No.6 – About SQL Server Temporary Tables

Check our Tip of the Week, about SQL Server Temporary Tables.   Tip of the Week #6 Local temporary tables in SQL Server, are defined by using the # (single hash) sign and they are only available for the session in which they were created in. After the session ends, local temporary tables are automatically … Read more…

Tip of the Week No.4 – SQL Server Stretch Database

Check our Tip of the Week, about JSON support in SQL Server.   Tip of the Week #4 Stretch Database in SQL Server 2016 and later, allows storing historical data in the Microsoft Azure cloud. It runs in the background and provides seamless access to both local and remote data. Among other, it can be … Read more…

Tip of the Week No.1 – SQL Server Always Encrypted

Check our Tip of the Week, about the SQL Server Always Encrypted feature!   Tip of the Week #1 With Always Encrypted in SQL Server 2016 and later, you can protect sensitive data, by encrypting sensitive data on the application side, without revealing the encryption keys to the Database Engine. To this end, through a … Read more…

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…

The set identity_insert Command in SQL Server

In this article, we will be discussing about the set identity_insert command in SQL Server.   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 … 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…