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
An apartment block of bare balconies where only one is furnished with plants and a red awning

Running SQL Server on an Azure Virtual Machine

February 22, 2014
Pinal Dave
SQL Tips and Tricks
Cloud Computing, SQL Azure, SQL Backup and Restore, SQL Server, Virtualization

SQL Server on an Azure virtual machine keeps instance control while moving storage and hosting to Azure; learn disk, backup, and sizing checks.

Read More
An open tortilla press beside dough disks with progressively smaller thickness differences

Exponential Backoff: How SQL Server Estimates Several Filters

February 21, 2014
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Performance, SQL Statistics

The plan guessed 89 rows and 500 came back. Here is the rule behind that guess, and what to do about it.

Read More
SQL SERVER - Finding the Last Backup for All Databases - Notes from the Field #016

SQL SERVER – Finding the Last Backup for All Databases – Notes from the Field #016

February 20, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

When did you take your last database backup? Tim Radney shares a simple script that shows the last backup for all databases on a server.

Read More
A split pomegranate on a garden table, a hand lifting out one chamber full of red seeds

Querying Nested JSON Arrays With OPENJSON

February 19, 2014
Pinal Dave
SQL Tips and Tricks
JSON, SQL Function, SQL Scripts, SQL Server

Query nested JSON arrays with OPENJSON, preserve element positions, pass inner arrays with AS JSON, and handle missing or strict paths.

Read More
Rows of closed paint tins, each lid dabbed with its color, a hand reaching for the tin with the red dab

Indexing JSON Properties With Computed Columns

February 18, 2014
Pinal Dave
SQL Performance
Computed Column, JSON, SQL Index, SQL Server

Improve indexing JSON properties with typed computed columns, matching paths, required SET options, and plan checks on your workload.

Read More
A hand pressing the lid of a compartment lunchbox that will not close over a squashed sandwich.

The Native JSON Data Type in SQL Server 2025

February 17, 2014
Pinal Dave
SQL Tips and Tricks
JSON, SQL Datatype, SQL Server

Use the JSON data type in SQL Server 2025, reject invalid documents, read and change properties, and choose where relational columns fit.

Read More
The query SELECT @@system_time_zone; with its result, a single row with the column @@system_time_zone and the value India Standard Time

Time Zone Name in MySQL: How to Detect the Current One

February 16, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Command, SQL DateTime

Need the current time zone of the MySQL server you are connected to? One simple query with @@system_time_zone returns the time zone name.

Read More
Time Zone name dialog.

SQL SERVER – Get Current TimeZone Name in SQL Server

February 15, 2014
Pinal Dave
SQL Tips and Tricks
SQL DateTime

What is the current TimeZone of the server where SQL Server is installed? Here is the short xp_regread script I use to read it.

Read More
MySQL - When to Use TIMESTAMP or DATETIME - Difference Between TIMESTAMP or DATETIME

MySQL – When to Use TIMESTAMP or DATETIME – Difference Between TIMESTAMP or DATETIME

February 14, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL DateTime

Confused about TIMESTAMP or DATETIME in MySQL? I explain the two factors, starting with supported range, that help you decide which one to use.

Read More
SQL SERVER - Expanding Your Skills - Notes from the Field #015

SQL SERVER – Expanding Your Skills – Notes from the Field #015

February 13, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore

Busy day job but want to grow your career? Brian Kelley shares his advice on expanding your skills and keeping up with new technology.

Read More
Previous 1 … 311 312 313 314 315 316 317 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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