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 round wooden piece fits its matching opening while other shapes need different openings

How to check the ANSI Compatibility of SQL Server Queries? – Interview Question of the Week #221

April 21, 2019
Pinal Dave
SQL Interview Questions and Answers
Compatibility Level, SQL Scripts, SQL Server

How do you check the ANSI compatibility of SQL Server queries? A client asked me this unique question, and the FIPS standard helps keep your code portable.

Read More
Gouache painting of a balcony with a cracked pot, a fresh pot and a vermilion planter box full of soil

Docker Volume for SQL Server: Keep Your Data Across Upgrades

April 20, 2019
Pinal Dave
SQL Tips and Tricks
Docker, PowerShell, SQL Data Storage, SQL Scripts

A Docker volume keeps SQL Server data outside the container, so you can replace the container and keep every database. This post creates a named volume, copies a backup into it and upgrades by starting a newer image on the same volume. It also covers the cautions that protect your data.

Read More
A row of full fish crates on a quay at dawn, one crate at the end holding only a few fish

Spotting Unusually Small Backups Against Each Database’s Average

April 17, 2019
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Monitoring, SQL Scripts

Flag unusually small backups against database-specific history, use aggregate filtering, and investigate alerts without assuming data loss.

Read More
Three bowls with equal heaps of toffees, one last toffee resting in an open palm above them

Splitting an Amount Across Rows Without Losing a Cent

April 16, 2019
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Datatype, SQL Scripts, SQL Server

Make splitting an amount preserve every cent by checking rounded shares, allocating weighted remainders, and documenting deterministic ties.

Read More
Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 - HTTP Error Message: This Request is Not Authorized to Perform This Operation

Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 – HTTP Error Message: This Request is Not Authorized to Perform This Operation

April 9, 2019
Pinal Dave
SQL Tips and Tricks
Computer Network, PowerShell, SQL Azure, SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts, SQL Server

A runbook cleaning old backup blobs in Azure failed with (403) Forbidden: This request is not authorized to perform this operation. Here is the fix.

Read More
An empty theatre stage is prepared for a performance that has not begun

How to Compile Queries and Not Execute Them? – Interview Question of the Week #219

April 7, 2019
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Scripts, SQL Server

How do you compile queries and not execute them? SET NOEXEC ON validates the syntax without running the statement, as this simple SSMS example shows.

Read More
Script Level Upgrade for Database 'master''s SSISDB Database.

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151

April 6, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration, SSIS, TraceFlags

Another SQL Server upgrade failure: upgrade step SSIS_hotfix_install.sql hit error 15151 because a user did not exist. Here is how I fixed it.

Read More
Previous 1 … 75 76 77 78 79 80 81 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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