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 - Error: 45207 - SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid

SQL SERVER – Error: 45207 – SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid

October 4, 2018
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Log, SQL Scripts, SQL Server, SQL Server Security

After a cleanup on my Azure SQL VM, I hit Msg 45207: SQL Server Managed Backup to Microsoft Azure cannot configure the database. Here is how I fixed it.

Read More
Tongs select individual fruit while a shovel would scoop everything

How to STOP the Usage of SELECT * For Views? – Interview Question of the Week #193

September 30, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Error Messages, SQL Scripts, SQL Server, SQL View

How do you stop people from using SELECT * in views? A slow query in a Health Check came from SELECT * over a wide view, so here is one way to prevent it.

Read More
Gouache painting of calendar cards arranged through the seasons

Formatted Date Alias in ORDER BY: Sort by the Real Date in SQL Server

September 28, 2018
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Order By, SQL Scripts

A formatted date alias can change ORDER BY from a date sort into a text sort. The tests here reproduce the wrong order, show three ways to sort by the real date, and explain the two errors you hit when you try to be clever with the alias.

Read More
A small sample dish holds selected tiles beside a larger populated source tray.

SQL SERVER – Selecting Random n Rows from a Table

September 24, 2018
Pinal Dave
SQL Tips and Tricks
SQL Random, SQL Scripts, SQL Server

To select random-looking n Rows, I can sort by NEWID and use TOP. A developer wanted ten AdventureWorks Product rows.

Read More
Two matching brass clips hold a ribbon safely inside a wooden frame

How to Escape a Single Quote in SQL Server? – Interview Question of the Week #192

September 23, 2018
Pinal Dave
SQL Interview Questions and Answers
Quotes, SQL Scripts, SQL Server

How do you escape a single quote in SQL Server? A college student asked me at a Bangalore user group, a few people laughed, and here is the simple answer.

Read More
Selected cabinet fittings and blank patterns are reviewed for a differently shaped destination.

SQL SERVER – Restoring SQL Server 2017 to SQL Server 2005 Using Generate Scripts

September 21, 2018
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server, SQL Server Management Studio

I used generate scripts for a historical SQL Server 2017-to-2005 migration. It was a logical migration rather than a backward backup restore.

Read More
Gouache illustration of the first and last day of the current date's month, using the first and last sheets between two bookends.

SQL SERVER – Simple Method to Find FIRST and LAST Day of Current Date

September 20, 2018
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

I calculate the FIRST and LAST Day of Current Date using explicit date boundaries. The historical sample starts on October 28, 2017.

Read More
Previous 1 … 89 90 91 92 93 94 95 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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