Tagged: sql

databases 1

An Overview of Continuous Integration of SQL Server Database

Continuous integration (CI) is the practice of integrating the isolated databases as soon as they are pushed into an ordinary source control repository. During the early stage of the continuous integration concept, the rule of thumb followed by database admins was of daily integration. However, lately, it is widespread that constant integration is done many...

sql recovery - SysTools SQL Recovery 0

SysTools SQL Recovery

Repair Corrupt MDF & NDF SQL Server Database & Export into SQL Server Database The SysTools SQL Recovery tool, a versatile and useful solution to resolve the corruption issue of SQL database files (MDF) effectively. Get the software to recover SQL file with the option to fix corrupt SQL database here and know how the tool works...

Computer 0

Relational to JSON With SQL

Oracle started adding JSON support to Oracle Database with version 12.1.0.2. The earliest support was targeted at storing, indexing, and querying JSON data. Version 12.2 rounded out that support by adding features for generating, exploring, and processing JSON data. See the JSON Developer’s Guide for a comprehensive overview of what’s now available. In this post,...

Computer 0

Code You Should Never See in PL/SQL

If you ever run across any of the following, apply the suggested cleanup or contact the owner of the code…or run for the hills. I am pretty sure many of my readers will have suggestions for other code that should never appear in your PL/SQL programs. Let me know in the comments and I will...

Computer 2

SQL Database Corruption: Causes, Prevention, and Fixing Techniques

“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I try to attach the file, I am receiving following error message :The header for file ….\MSSQL\DATA\xxxx_data.mdf’ is not a valid database file header. The FILESIZE property is incorrect. (SQL Server Error 5172). After surfing a...

Computer 1

Why You Should Migrate SQL Server 2008 to the 2017 Version

Are you using Microsoft SQL Server 2008 and want to migrate SQL Server 2008 database to 2017? Then no need to look further. In this post, we are going to step through a reliable way to move SQL Server 2008 database to 2017. Before we move on to the migration procedure, let’s look at some...