I was reading through some of the enhancements introduced with SQL Server 2016 and I stumbled upon an interesting addition. The T-SQL construct introduced has been something very common and on the pending request for years I suppose.
SQL SERVER – How to Create Linked Server to PostgreSQL?
The databases world is expanding and I have been fortunate enough to learn and share my experiences around databases like MySQL, PostgreSQL apart from working with SQL Server. I always try to expand my horizon and try various database products. In case you don’t know, I have course on Pluralsight about PostgreSQL
Interview Question of the Week #046 – How @@DATEFIRST and SET DATEFIRST Are Related?
Question: How @@DATEFIRST and SET DATEFIRST are related? Answer: The master database’s syslanguages table has a DateFirst column that defines the first day of the week for a particular language. SQL Server with US English as default language, SQL Server sets DATEFIRST to 7 (Sunday) by default. We can reset any day…
Read MoreInterview Question of the Week #044 – What is the difference of performance between SELECT and SET?
Question: What is the difference of performance between SELECT and SET? Answer: SELECT : Designed to return data. SET : Designed to assign values to local variables. While testing the performance of the following two scripts in query analyzer, interesting results are discovered. SET @foo1 = 1; SET @foo2 =…
Read More
SQL SERVER – What is the OVER Clause? – Notes from the Field #101
[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Over clause. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server because her writing has instigated love for this technology in me. Today she brings a relatively interesting topic for database experts. Read the experience of Kathi in her own words.
Interview Question of the Week #043 – What is the Difference Between EXCEPT operator vs. NOT IN
Question: What is the Difference Between EXCEPT operator vs. NOT IN. Let us learn the answer to this question in this blog post.
SQL SERVER – To Find Events Mapped to Channels in Extended Events
I have outlined a number of blogs here that point to the basics of working with Extended Events. Some of them also detail you some specific scenarios that you can use inside your environments.