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 Complete - Smart Code Completion and SQL Formatting

SQL Complete – Smart Code Completion and SQL Formatting

August 3, 2016
Pinal Dave
SQL Tips and Tricks
Devart, SQL Server, SQL Utility

My impressions of dbForge SQL Complete 5.5: SSMS 2016 integration, support for the new SQL Server 2016 syntax, smarter code completion and SQL formatting.

Read More
SQL SERVER - Delayed Durability, or The Story of How to Speed Up Autotests From 11 to 2.5 Minutes

SQL SERVER – Delayed Durability, or The Story of How to Speed Up Autotests From 11 to 2.5 Minutes

July 20, 2016
Pinal Dave
SQL Tips and Tricks
Devart, SQL Memory, SQL Server

My friend Sergey Syrovatchenko shares how Delayed Durability helped speed up autotests from 11 to 2.5 minutes on a SQL Server 2014 project.

Read More
Locked antique box and keys on a detective desk at night

The Tale of the Cunning Dev, Encrypted Procedures, DAC and God Mode = ON – Experts Opinion

April 22, 2016
Pinal Dave
SQL Tips and Tricks
Devart

My friend Syrovatchenko Sergey from Devart tells a detective story about a free tool, Encrypted Procedures, DAC and God Mode. A creative read you will enjoy.

Read More
SQL SERVER - View Dependencies on SQL Server: Hard & Soft Way

SQL SERVER – View Dependencies on SQL Server: Hard & Soft Way

February 16, 2016
Pinal Dave
SQL Tips and Tricks
Devart, SQL Constraint and Keys, SQL Scripts, SQL Server, SQL Utility

Most databases I meet as a consultant have no up-to-date documentation. Here is the hard way and the soft way to check SQL SERVER – View Dependencies yourself.

Read More
SQL SERVER - Dedicated Database Development with SQL Source Control

SQL SERVER – Dedicated Database Development with SQL Source Control

January 18, 2016
Pinal Dave
SQL Tips and Tricks
Devart

Should each developer have a dedicated database of their own? Andrey Langovoy from Devart explains dedicated database development with SQL Source Control.

Read More
SQL SERVER - The Best Time to Buy - Devart Christmas Price Fall

SQL SERVER – The Best Time to Buy – Devart Christmas Price Fall

December 21, 2015
Pinal Dave
SQL Tips and Tricks
Devart

The Devart Christmas price fall gives 20% off all Devart licenses from 16 December 2015 to 16 January 2016, including dbForge tools for SQL Server.

Read More
SQL SERVER - Fix SQL Server Index Fragmentation with dbForge Index Manager

SQL SERVER – Fix SQL Server Index Fragmentation with dbForge Index Manager

December 14, 2015
Pinal Dave
SQL Tips and Tricks
Devart, SQL Index, SQL Scripts, SQL Server

Index fragmentation slowly hurts performance. Here is how to find and fix it with dbForge Index Manager, after a quick look at autogrow events.

Read More
Previous 1 2 3 4 5 6 Next
  • Books
  • Testimonials
  • Privacy Policy

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