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, in this post, we will be discussing about how you can resolve the SQL Server CTE Error: Incorrect syntax near ‘)’. What are Common Table Expressions (CTEs)? In SQL Server and more specifically in T-SQL, a CTE is a temporary named result set, from which you can then select records. CTEs are … Read more…
Check our Tip of the Week, where in this week, we discuss about the benefits of using database stored procedures. Tip of the Week #18 Using stored procedures in your database processes, can be very beneficial, not only for performance, but also for security and code reuse. Below, we list some of the main benefits, … Read more…
In this article, we will be discussing about the error message [The OLE DB provider “Microsoft.ACE.OLEDB.12.0” has not been registered] and how you can easily resolve it. Importing Data from Excel to SQL Server via SSMS In most of the cases, you might get the [OLE DB Provider “Microsoft.ACE.OLEDB.12.0” has not been registered] error … Read more…
When developing in SQL Server, under certain circumstances, you might get the error message: Operand type clash: int is incompatible with uniqueidentifier. In this article, we will be discussing about, why you got that message, what’s wrong in your T-SQL script and how to fix it. About the above “Operand type clash: error … Read more…
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…
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…
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…
Check our Tip of the Week, about JSON support in SQL Server. Tip of the Week #2 With JSON support in SQL Server 2016 and later, you can format query results as JSON by adding the FOR JSON clause to a SELECT statement in SQL Server. Also, you can convert JSON data to rows … Read more…
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…
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 great 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…
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…
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…