Blog Home Page - Page 336 of 831 - SQL Authority with Pinal Dave

Nov26

SQL SERVER – Availability Group and the Six Critical Steps for DBAs to Follow – Notes from the Field #104

Mike’s, “now what am I supposed to do?”, face. [Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell explains about Availability Group and the Six Critical Steps for DBAs to Follow. A few weeks ago, I asked questions in conferance, how many people…

Nov25

SQL SERVER – What Resource Wait Are We Seeing?

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I have been a big supporter of the Activity Monitor capability inside SQL Server Management Studio. And I have written a number of articles before in this blog. Please take a moment to look at: SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries One of the…

Nov24

SQL SERVER – How to Create Linked Server to PostgreSQL?

Pinal Dave

SQL

Linked Server, PostgreSQL, SQL Scripts

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

Nov23

SQL SERVER – New features in SQL Server 2016 Setup Wizard

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server 2016, SQL Server Installation, SQL TempDB

In this world of change, the SQL Server product is also changing. One thing which is very clear is that Microsoft is listening to feedbacks from customers and enhancing the setup experience also. Some of the classic feedback implementation can be seen in the setup of the next version of SQL Server 2016. In this blog post, I will try to bring out some of the enhancements that are being incorporated in the Setup UI. Some are critical and worth making a note. Let us learn about SQL Server 2016 Setup Wizard.

Nov22

Interview Question of the Week #046 – How @@DATEFIRST and SET DATEFIRST Are Related?

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

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…

Nov21

SQL SERVER – Inserting into ColumnSet with SPARSE Columns

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index

There are a number of blogs around using SPARSE columns here. Here are few of them for reference and can be used as a great learning experience. SQL SERVER – 2008 – Introduction to SPARSE Columns SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2 SQL SERVER…

Nov20

SQL SERVER – InMemory Table Creation Error Message: Msg 41337

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I had recently gone to my hometown to visit my parents as it was holidays for my daughter because of festival. These are relaxing times and hardly try to get in front of my computer during these 2-3 days of family time. But who said that happens always. In this…

SQL SERVER – What Resource Wait Are We Seeing?

SQL SERVER - InMemory Table Creation Error Message: Msg 41337 PG-Linked-01-619x319

SQL SERVER – How to Create Linked Server to PostgreSQL?

SQL SERVER - InMemory Table Creation Error Message: Msg 41337 sql2016-setup-01-619x472

SQL SERVER – New features in SQL Server 2016 Setup Wizard

Interview Question of the Week #046 – How @@DATEFIRST and SET DATEFIRST Are Related?

SQL SERVER – Inserting into ColumnSet with SPARSE Columns

SQL SERVER – InMemory Table Creation Error Message: Msg 41337

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.