Category Archives: SQL

SQL PowerShell to check and repair Ad-hoc distributed queries Vulnerability

Posted on January 4, 2021 by Saravanakumar Ramesh

Introduction Ad hoc distributed queries use the OPENROWSET and OPENDATASOURCE functions to connect to remote data sources that use OLE DB. As the name suggests, ad-hoc distributed queries should only be used with infrequent access to data sources. For the … Continue reading →

Posted in PowerShell, Security, SQL, T-SQL, Uncategorized, Vulnerability | Tagged , , , , , | Leave a comment

Import Local SQL Server Database to Azure – Pick the Best Method

Posted on June 11, 2019 by Andrew Jackson

It is not unknown to the SQL users that some of the SQL Server versions have become outdated. This is the main reason why most of the SQL Server users are migrating SQL server database to Azure. Along with this, … Continue reading →

Posted in SQL | Tagged , | Leave a comment

Microsoft SQL Server Error 5243 – Top 3 Ways To Fix This Issue

Posted on May 21, 2019 by Andrew Jackson

Maintaining the SQL server database is always the first priority of the SQL administrators. But sometimes SQL database users have to face Microsoft SQL server error 5243 and error 5242. These are common errors. Due to this problem, the SQL … Continue reading →

Posted in SQL, T-SQL | Tagged | Leave a comment

Restore SQL Server 2014 Database from Backup – Step By Step Guide

Posted on May 6, 2019 by Andrew Jackson

Microsoft SQL server database contains the most crucial data of organizations. But while using MS SQL server many users often face problems like abrupt termination, database connection errors, transient errors, malicious software attacks. In order to save their important SQL … Continue reading →

Posted in SQL, SQL Server Backup | Tagged | Leave a comment

Know How to Repair SQL Database Marked as Suspect Mode in SQL Server

Posted on April 30, 2019 by Andrew Jackson

Repair SQL Database Marked as Suspect Mode MS SQL server is a widely used relational database management system developed by Microsoft. It is a software product which primarily helps to store and retrieve the data of other applications. SQL database … Continue reading →

Posted in SQL | Tagged , | Leave a comment

How to Change Suspect Mode to Normal Mode in SQL Server Database

Posted on January 7, 2019 by Andrew Jackson

If you are reading this, you are desperately looking for solutions to change suspect mode to normal mode. It also means that your database has gone into the suspect mode. In that case, you have already experienced one of the … Continue reading →

Posted in SQL | Leave a comment

Automation to list all TCP static and dynamic ports of SQL Server instances using PowerShell

Posted on December 27, 2018 by Prashanth Jayaram

I was asked by the reader on how to get all the port information of SQL Servers instances. As you all know that PowerShell is built on .Net automation framework. I would prefer PowerShell to design any such requirements than … Continue reading →

Posted in SQL | Tagged , , | Leave a comment

How to automatically Discover SQL Server instances

Posted on December 17, 2018 by Prashanth Jayaram

DBAs have plenty of day-to-day tasks to do as part of the administration, but one overarching task is managing the entire SQL Server environment. To do this, the full SQL Server estate must be discovered and inventoried. To accomplish that … Continue reading →

Posted in SQL | Tagged , , , , | Leave a comment

SQL Date functions in SQL Server

Posted on December 4, 2018 by Prashanth Jayaram

SQL date format functions like the DateDiff SQL function and DateAdd SQL Function are oft used by DBAs but many of us never took the time to fully understand these extremely useful features. For professionals just getting started with SQL … Continue reading →

Posted in SQL | Tagged , | Leave a comment