The series of this blog provide you a complete walkthrough of SQL Server on Linux installation processes. It includes the creation of Hyper-V virtual machine, Installation of Ubuntu Server, Installation of SQL Server and SQL Server Tools on the Linux machine. The first part of the “SQL Server on Linux Installation” blog will talk about […]
Download the Sample Database Backup File on the Linux machine
Read more
A release of SQL Server 2016 was not only loaded with rich features & enhancements, but it also brought a new sample database known as Wide World Importers (WWI). Here is the official announcement link. As Microsoft has decided to end the era for the SQL Server sample database AdventureWorks, it’s time for us to […]
Zip/Unzip SQL Server Database Backup File on Linux Machine
Read more
After the fantastic announcement of SQL Server on Linux – Public Preview, I started exploring a couple of things on SQL Server on Linux. During the exploration of SSOL, I realized that If you are a new Linux System user, you might find difficulties to zip and unzip a SQL database backup file on a […]
Announcement of SQL Server on Linux – Public Preview
Read more
Finally, the first time ever SQL Server on Linux is publicly available to explore the new power of SQL Server. With this release of SQL Server, you can develop applications with SQL Server on Linux, Windows, Docker, or macOS (via Docker) and then deploy to Linux, Windows, or Docker, on-premises or in the cloud. Operating System […]
Capturing Current Workload of SQL Server – Part1
Read more
We often get a complaint from our client or application team that this particular query sometimes performs worst or at this specific time, the whole system performs very poorly. And, they want you to find the cause of performance issue. To start with basic performance troubleshooting, you need historical data which can tell you what […]
Verifying SQL Server Instance workload
Read more
As a DBA, you might be supporting different-different clients. Basically, you would be dealing with thousand of SQL Servers, and it is tough to remember which SQL Server is having what kind of workload – OLTP or DSS (aka DW). If your client reports to you performance issue on one of the SQL Servers instance, […]
The Secret of the Database Boot Page#9 – Part1
Read more
Recently, I presented on SQL Server database “Boot Page” at Singapore SQL Pass Chapter user group. It was a great knowledge sharing experience, and It motivated me to share the knowledge to a wider audience. So, I will be blogging all the part of the demos with all possible details so that you enjoy the […]