Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – dbForge Object Search for SQL Server

Pinal Dave
SQL
Devart, SQL Scripts, SQL Server, SQL Utility

SSMS is a nice tool for database developers. However, it is far from being ideal, and this is because some routine operations in SSMS are extremely inconvenient to perform. Let us learn about dbForge Object Search for SQL Server.

Very often, developers face the challenge of searching a database for all occurrences of an object, column, variable, or search simultaneously all the objects, in which a search value occurs. If you happen to solve a similar problem, then you must know that this problem is not the most trivial and Ctrl + F will not help here.

Read More

SQL SERVER 2016 – IF EXISTS Function on SQL Azure Databases and More

Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Function, SQL Scripts, SQL Server, SQL Server 2016

The experimentation of working with the next release of SQL Server is always fun and when I wrote the blog T-SQL Enhancement “Drop if Exists” clause, lesser did I know such capabilities are already existing with Azure SQL DB. When I was presenting at one of the local user groups, I told most of the capabilities come to Cloud first, get test and the very reason that it scales without problem on cloud gives one the confidence that it would work in our enterprise. One of the attendees asked, has all features first introduced to cloud only? Let us learn about IF EXISTS Function on SQL Azure Databases and More.

Read More

SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’

Pinal Dave
SQL
SQL Error Messages, SQL Scripts, SQL Server, SQL Upgrade, System Database

I do apply patches to my SQL instances as and when they are released by Microsoft. This is important because I always feel keeping the bits up-to-date is essential because I don’t want to get infected as I travel quite a bit. Since I play a lot with my SQL Server, there are more chances that things are going to break sooner than your production server. Here is one such incident. Let us learn about how to fix script level upgrade. 

Read More

SQL SERVER – Fixing Annoying Network Binding Order Error – Notes from the Field #112

Pinal Dave
SQL
Computer Network, Notes from the Field, SQL Error Messages, SQL Function, SQL Server

[Note from Pinal]: In this episode of the Notes from the Field series database expert Ryan Adams explains a very critical error user receive when binding network error. Ryan is one guy who spends more time with real world issues with SQL Server than anything else. He has mastered the art of resolving complex errors and document them so easily that one can’t find anywhere else. In this blog post Ryan addresses a very interesting error related to binding network error. Read the experience of Ryan in her own words.

Read More

SQL SERVER – FIX: Msg 4335, Level 16, State 1 – The specified STOPAT time is too early

Pinal Dave
SQL
SQL Error Messages, SQL Scripts, SQL Server

While trying to prepare for a demo, I ran into some interesting error. When I searched for error about STOPAT on the internet, there were not many clear answers so I thought of sharing on my blog. Actually, my demo was all about point in time restore feature of SQL Server. I was trying something similar given in my earlier blog.

Read More

SQL SERVER – Live Query Statistics in 2016 … and More! – Notes from the Field #111

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Function, SQL Server

[Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell explains about Live Query Statistics in SQL Server 2016. Statistics are heart of SQL Server. They play a very powerful role when SQL Server Engine needs help to build a new execution plan for a query. In earlier version of SQL Server we had the only privilege to see statistics after the query is executed. However, with the advancement of SQL Server 2016, the scenario has been changed. Here is a very interesting new feature of SQL Server 2016 which can help every performance tuning expert. Read the experience of Mike in his own words.

Read More