This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL error in reporting tool.

SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword

January 30, 2017
Pinal Dave
SQL Tips and Tricks
JSON, SQL Error Messages, SQL Scripts, SQL Server

Why does a JSON path that doesn’t match return NULL? Add the STRICT keyword to get an error instead. A follow-up on JSON NULL values in SQL Server 2016.

Read More
A square wooden piece passes through a brass adapter and emerges as a round piece

Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107

January 29, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Performance, SQL Scripts, SQL Server

Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.

Read More
A wooden ladder leaning against a whitewashed wall with one rung missing near the top.

SQL SERVER – Script level upgrade for database ‘master’ failed – There is already an object named ‘DatabaseMailUserRole’ in the database

January 23, 2017
Pinal Dave
SQL Tips and Tricks
Database Mail, SQL Error Messages, SQL Scripts, SQL Server, Starting SQL

After patching, script level Upgrade for master failed: there is already an object named ‘DatabaseMailUserRole’. Here is what caused it and how to fix it.

Read More
A freshly sealed reserve barrel stands in front of older stored copies

When was Database Last Backed Up in SQL Server? – Interview Question of the Week #107

January 22, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Backup and Restore, SQL Scripts, SQL Server

When was each database last backed up? Here is the script I share in training that lists full, differential and log backup history for your server.

Read More
SQL SERVER - Understanding JSON Use is Case-Sensitive

SQL SERVER – Understanding JSON Use is Case-Sensitive

January 19, 2017
Pinal Dave
SQL Tips and Tricks
JSON, SQL Scripts, SQL Server, SQL String

My daughter explores every new toy, and that is how I play with JSON in SQL Server 2016. One surprise: JSON paths are case-sensitive, as this example shows.

Read More
SQL AlwaysOn AG replication status.

SQL SERVER – AlwaysOn AG (Availability Group) and TDE Error – Please Create a Master Key

January 18, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Encryption

A TDE enabled database would not synchronize in an AlwaysOn availability group, and ERRORLOG said please create a master key. Here is what I found.

Read More
One connected copper supply pipe feeds three separate bowls

How to Query Multiple SQL Server with a Single Query? – Interview Question of the Week #106

January 15, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Management Studio

A senior DBA needed to check SQL Server 2016 SP1 on every server. Here is the neat way he used to query multiple SQL Server instances with a single query.

Read More
Previous 1 … 134 135 136 137 138 139 140 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com