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

This tutorial shows you how to copy all text as a table from a screenshot in Snipping Tool on a Windows 11 PC. For this, we will use the Copy as table feature. It’s a new feature that generates ...

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 ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

Microsoft's relational database engine has had the same licensing model since 2012. The new version released this week brings significant changes that brings SQL Server closer to Azure SQL's licensing ...

Often we may be required to get the names of all columns in a table in SQL server. In this post we will see the different options available in SQL server to fetch the column names. 1) We can use the ...

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, ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...