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
A concertina file of folded papers on a desk with one sheet folded the wrong way so the file cannot close.

SQL SERVER – Fix Error Msg 13603 working with JSON documents

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

Msg 13603 appeared when I used a custom path with FOR JSON PATH, because the column alias had an invalid character. Here is how to fix it.

Read More
SELECT Cast As Date.

SQL SERVER Puzzle – Conversion with Date Data Types

January 1, 2017
Pinal Dave
SQL Puzzle
SQL DateTime, SQL Scripts, SQL Server

Converting values with CAST can round in ways you don’t expect. A puzzle on Date Data Types: guess the output of each query before you run it.

Read More
A brass hose coupling of the wrong size lying on a concrete floor beside a pipe end it will not fit.

SQL SERVER – Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server

December 31, 2016
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Error Messages, SQL Scripts, SQL Server

Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 showed up only from the client machine. Here is why and the fix.

Read More
Gouache painting of a locked chest with a red key beside it and an identical locked chest with no key on another table

Why an Encrypted Column Shows NULL on a Subscriber

December 29, 2016
Pinal Dave
SQL Tips and Tricks
SQL Replication, SQL Scripts, SQL Server Encryption, SQL Server Security

An encrypted column shows NULL on a subscriber when the subscriber’s symmetric key doesn’t match the publisher’s key. This post reproduces the symptom with two demo databases, compares key_guid in both and shows the fix. It also explains what replication copies and what it leaves behind.

Read More
A hand press has produced a stack of identical clay tiles through repeated work

How to Find Number of Times Function Called in SQL Server? – Interview Question of the Week #104

December 25, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Function, SQL Scripts, SQL Server, SQL Server 2016

A function was causing CPU spikes. How many times was that function called, and at what cost? The SQL Server 2016 DMV dm_exec_function_stats shows it.

Read More
A padlocked iron gate across a loading bay lit by one amber wall lamp

SQL SERVER – FIX – Error – Msg 4928, Level 16, State 1. Cannot Alter Column Because it is ‘Enabled for Replication or Change Data Capture’

December 24, 2016
Pinal Dave
SQL Tips and Tricks
Change Data Capture, SQL Replication, SQL Scripts, SQL Server

Msg 4928 blames Replication or Change Data Capture on a database that has neither. Reproduced on SQL Server 2025, with the flags to check and the fix.

Read More
A shared bookbinding press is busy while another stack waits for its turn

What is Memory Grants Pending in SQL Server? – Interview Question of the Week #103

December 23, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Memory, SQL Scripts, SQL Server

What is Memory Grants Pending in SQL Server? A short interview-style answer: what the counter shows, what value you want to see and why it matters.

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

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