Announcement of SQL Server on Linux – Public Preview

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 […]

Read more
Capturing Current Workload of SQL Server – Part1

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 […]

Read more
Verifying SQL Server Instance workload

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, […]

Read more
The Secret of the Database Boot Page#9 – Part1

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 […]

Read more