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
Gouache painting of a vermilion music box with its lid opening on a table in a music room

Startup Stored Procedures in SQL Server: Uses and Risks

July 23, 2018
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, Starting SQL

Startup stored procedures run every time SQL Server starts, which makes them useful and easy to forget. This post covers good uses, the risks, a wait that gives up instead of looping forever, and how to list and remove the startup stored procedures already on a server. The setup steps are in a separate post.

Read More
Growth rings in an established oak log beside a young sapling

How Old Version of SQL Server Running on Server? – Interview Question of the Week #183

July 22, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Patch, SQL Scripts, SQL Server

Is your server on an old version of SQL Server? Run SELECT @@VERSION to see the build and the date the patch was created, a check I often run during a Health Check.

Read More
Sas Tool Window.

SQL SERVER – Backup to URL – Script to Perform Striped Backup using Shared Access Signature (SAS)

July 18, 2018
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server

A reader wanted a striped backup to Azure Blob Storage. Here is my script to take a striped Backup to URL across several files using a SAS token credential.

Read More
SQL SERVER - Backup to URL - Script to Generate Credential and Backup using Shared Access Signature (SAS)

SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)

July 17, 2018
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Scripts, SQL Server

Backup to URL can connect to Azure storage with a SAS token. I share a script that generates the credential and the backup command using a Shared Access Signature.

Read More
Execution plan size and type.

SQL SERVER – Execution Plan Ignores Tabs, Spaces and Comments

July 14, 2018
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Scripts, SQL Server, SQL Stored Procedure

Many teams skip comments in stored procedures, fearing bigger execution plans. My demo shows SQL Server ignores tabs, spaces and comments when it builds a plan.

Read More
Execution plan of a query with a single row and single table.

SQL SERVER – Puzzle – Why Such a Complicated Execution Plan for a Single Row, Single Table Query?

July 13, 2018
Pinal Dave
SQL Puzzle
Execution Plan, SQL Scripts, SQL Server

A simple puzzle: why does SQL Server show such a complicated execution plan for a single row, single table query on WideWorldImporters? Try to solve it.

Read More
SQL SERVER - Backup to URL - Script to Generate the Create Credential and Backup Command using Access Keys

SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys

July 9, 2018
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

Backup to URL can use a SAS token or access keys. Here is a script that builds the CREATE CREDENTIAL and BACKUP commands from your Azure storage access keys.

Read More
Previous 1 … 95 96 97 98 99 100 101 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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