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 Server 2014 RTM and Windows Server 2012 R2.

SQL SERVER – Proof of Concepts with Windows Azure – Notes from the Field #056

November 27, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Azure, SQL Backup and Restore

Building proof of concepts is harder than it looks. John Sterrett shows how DBAs and developers can build them faster and get more out of Windows Azure.

Read More
A hand checking the soil of one red window box on a tall apartment building

Azure SQL Database Wait Stats: Reading sys.dm_db_wait_stats

November 4, 2014
Pinal Dave
SQL Performance
SQL Azure, SQL DMV, SQL Performance, SQL Wait Stats

Read Azure SQL Database wait stats with sys.dm_db_wait_stats, identify log-rate governance, and compare resource percentages before scaling.

Read More
Click Here.

SQL SERVER – Connecting to Azure Storage with SSMS

September 20, 2014
Pinal Dave
SQL Tips and Tricks
SQL Azure

Connecting to Azure Storage from SSMS takes a few simple steps from Object Explorer. I also show where to find your storage account name and key.

Read More
Restore database tool.

SQL SERVER – Backup to Azure Blob using SQL Server 2014 Management Studio

June 24, 2014
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore

SQL Server 2014 Management Studio has a new URL option on the backup screen. Here is how to use backup to URL to take a database backup to Azure Blob storage.

Read More
Sealed glass jars of preserved peaches on a stone cellar shelf, with one jar opener hanging on a nail beside them.

Backing Up to Azure Blob Storage

April 19, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Backup and Restore, SQL Server

Backing up to Azure blob storage with SQL Server requires scoped SAS credentials, block blob targets, tested striping, and a real restore drill.

Read More
A parcel on a doormat before a closed blue door with a brass knocker, a gloved hand stepping back after knocking once.

Connection Retry Logic for Cloud Databases

April 12, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, Developer, SQL Azure, SQL Connection

Connection retry logic handles transient cloud database faults through bounded backoff, safe transaction retries, and driver connection resiliency.

Read More
A small one-person tent and a large family tent side by side at a campsite

Azure SQL Database or Managed Instance

February 23, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Migration, SQL Server Agent

Azure SQL database or managed instance is a choice about compatibility, cross-database work, Agent, networking, and the cost of each service.

Read More
Previous 1 … 7 8 9 10 11 12 Next
  • Books
  • Testimonials
  • Privacy Policy

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