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
Two hands lifting an old wooden strongbox onto a moving trolley, its iron key tied to the handle with red string.

Moving SSRS Reports to a New Server

April 13, 2014
Pinal Dave
SQL Tips and Tricks
Reporting Services, SQL Backup and Restore, SQL Migration, SQL Reports, SQL Server

Moving SSRS reports to a new server requires the ReportServer databases, encryption key, data source checks, and subscription rehearsal.

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
SQL SERVER - Drop All the Foreign Key Constraint in Database - Create All the Foreign Key Constraint in Database

SQL SERVER – Drop All the Foreign Key Constraint in Database – Create All the Foreign Key Constraint in Database

April 11, 2014
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts

Need to drop all the foreign key constraints in a database and create them again? Here is a script by SQL expert Swastik Mishra that does both.

Read More
SQL SERVER - Finding Jobs Shrinking Database Files - Notes from the Field #023

SQL SERVER – Finding Jobs Shrinking Database Files – Notes from the Field #023

April 10, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, Shrinking Database, SQL Backup and Restore

Many shops have had jobs shrinking database files for years. Tim shares a simple script to find those jobs so you can deal with them.

Read More
MySQL - Finding First day and Last day of a Month

First Day and Last Day of a Month in MySQL and SQL Server

April 9, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL DateTime, SQL Function, SQL Server

Finding the first day and last day of a month in MySQL takes LAST_DAY and a little date arithmetic. This post checks leap years and timestamp filters, then repeats the task in SQL Server with EOMONTH and DATETRUNC, tested on SQL Server 2025.

Read More
SQL SERVER - What is SSAS Tabular Data Model and Why to Use it

SQL SERVER – What is SSAS Tabular Data Model and Why to Use it

April 8, 2014
Pinal Dave
SQL Tips and Tricks
SQL Analysis Services

Tabular mode is new in SQL Server 2012 Analysis Services. Here is what the SSAS Tabular Data Model is, why to use it over multidimensional and how to start one.

Read More
A fridge door standing open at night, its light spilling across an empty kitchen

SET XACT_ABORT ON: Stopping Timeouts From Leaving Open Transactions

April 7, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Lock, SQL Server, SQL Transactions

Use SET XACT_ABORT ON to prevent client timeouts from leaving transactions and locks open, with TRY CATCH and a sleeping-session query.

Read More
SQL SERVER - Fix - Error 1759 Computed column in table is not allowed to be used in another computed-column definition

SQL SERVER – Fix – Error 1759 Computed column in table is not allowed to be used in another computed-column definition

April 6, 2014
Pinal Dave
SQL Tips and Tricks
SQL Error Messages

Error 1759 appears when a computed column is used in another computed-column definition. Here is a simple repro of the error and how to avoid it.

Read More
SQL SERVER - Unable to ALTER Computed Column in SQL Server - How to ALTER Computed Column

SQL SERVER – Unable to ALTER Computed Column in SQL Server – How to ALTER Computed Column

April 5, 2014
Pinal Dave
SQL Tips and Tricks

Want to ALTER computed column logic in SQL Server? You cannot, it throws Msg 156. Here is how to drop and recreate the computed column instead.

Read More
Three different protective cases hold a complete arrangement, additional pieces and a sequence of linked fittings.

SQL SERVER – Last Full Differential and Log Backup Finish Times

April 4, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

I check backup time separately for full, differential and log backups. One latest timestamp cannot describe the entire recovery chain.

Read More
Previous 1 … 306 307 308 309 310 311 312 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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