Database administrator with 14+ years of hands-on experience in database management and database design.

At today's kickoff for Microsoft Ignite, the company announced that SQL Server 2025 is finally coming. No timing was announced for the release, but based on prior versions, I would expect to see a ...

SQL Server Management Studio or SSMS allows you to connect to the SQL server and execute queries. In this tutorial, we will see how you can install and configure SQL Server Management Studio in ...

You may encounter the SQL Server Error 18456 if the server could not authenticate the connection and this can be caused by the non-availability of the administrator ...

Most development is maintaining and enhancing existing systems. Often times these systems do not have a way to recreate the database structure, but we need these structures to setup local development, ...

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

SQL Server 2016 and Azure SQL Database both give you tables that automatically keep track of the history of your data. Here's how to retrieve that historical data. In an earlier column, I showed how ...