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

Jan20

While trying to deploy new machines on my Hyper-V, I faced an error. Boot failure. Reboot and Select proper Boot device or Insert Boot Media in selected Boot device It was a VHD file which I downloaded from Microsoft site. I searched for the solution on many sites and they…

Jan19

SQL SERVER 2016 – InMemory OLTP support for Foreign Key

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP

When InMemory OLTP was introduced in SQL Server 2014, there were a number of limitations that restricted customers to effectively use the capability. One of the most commonly asked capability was around the ability to create Foreign Keys. On first look, I thought this was always available. But while experimenting…

Jan18

SQL SERVER – Dedicated Database Development with SQL Source Control

Pinal Dave

SQL

Devart

We all make mistake and we all wish that we have not made those mistakes. In the field of the development, there are proper solutions, but in the world of SQL, there are not many solutions. I recently asked the same question to my friend Andrey from Devart and he has provided me a wonderful blog post about how one can do dedicated database development with SQL Source Control.

Jan17

Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects

Pinal Dave

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

SQL System Table

No Comments

Sometimes questions in the interview are extremely open ended and such questions can be very useful for candidate to play around with. For example, in one of the recent interview one of the interviewer asked the candidate that what is his favorite T-SQL script as a database administrator. The answer…

Jan16

SQL SERVER – Performance counter missing! DMV sys.dm_os_performance_counters is Empty

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

The topic around performance tuning is the most sought out search on this blog. Almost every single day the top search that lands here are around performance or around some random errors one might receive from the application. If you are a DBA, the first high level tool that you…

Jan15

SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell

No Comments

Writing utility scripts are one way to become smarter when working with computers. From time to time I get asked about some tasks folks use repetitively and are being counterproductive. On this note, I wanted to paint a scenario which I saw one of the DBA’s doing on their environment…

Jan14

SQL SERVER – Live Query Statistics in 2016 … and More! – Notes from the Field #111

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Function, SQL Server

No Comments

[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell explains about Live Query Statistics in SQL Server 2016. Statistics are heart of SQL Server. They play a very powerful role when SQL Server Engine needs help to build a new execution plan for a query. In earlier version of SQL Server we had the only privilege to see statistics after the query is executed. However, with the advancement of SQL Server 2016, the scenario has been changed. Here is a very interesting new feature of SQL Server 2016 which can help every performance tuning expert. Read the experience of Mike in his own words.

SQL SERVER 2016 – InMemory OLTP support for Foreign Key

SQL SERVER - Live Query Statistics in 2016 … and More! - Notes from the Field #111 link_db_to_sc

SQL SERVER – Dedicated Database Development with SQL Source Control

Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects

SQL SERVER – Performance counter missing! DMV sys.dm_os_performance_counters is Empty

SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell

SQL SERVER – Live Query Statistics in 2016 … and More! – Notes from the Field #111

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.

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Hyper V: Error and Fix – Fix – Boot failure. Reboot and Select proper Boot device

SQL SERVER 2016 – InMemory OLTP support for Foreign Key

SQL SERVER – Dedicated Database Development with SQL Source Control

Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects

SQL SERVER – Performance counter missing! DMV sys.dm_os_performance_counters is Empty

SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell

SQL SERVER – Live Query Statistics in 2016 … and More! – Notes from the Field #111

Hyper V: Error and Fix – Fix – Boot failure. Reboot and Select proper Boot device

SQL SERVER 2016 – InMemory OLTP support for Foreign Key

SQL SERVER – Dedicated Database Development with SQL Source Control

Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects

SQL SERVER – Performance counter missing! DMV sys.dm_os_performance_counters is Empty

SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell

SQL SERVER – Live Query Statistics in 2016 … and More! – Notes from the Field #111