TroubleshootingSQL

I recently wrote an Azure Data Studio Notebook on how to setup TDE for SQL Server 2019 Standard Edition (yes, SQL Server 2019 Standard Edition has TDE) using Azure Key Vault. I ran into a few iss...

https://troubleshootingsql.com/2019/11/05/addressing-sql-server-and-tde-with-akv-errors/

The next week of November is going to be an action packed week for me with two back to back conferences: Microsoft Ignite 2019, Orlando, Florida and PASS Summit 2019, Seattle, Washington. Below a...

https://troubleshootingsql.com/2019/10/29/upcoming-sessions-at-microsoft-ignite-and-pass-summit/

It is that time of the year when I get to meet the SQL Family. It is always wonderful to put a face to that Twitter handle that I exchanged #sqlchats with or connected with on LinkedIn. SQL PASS ...

https://troubleshootingsql.com/2017/10/31/sql-pass-summit-2017/

There is a plethora of Data Platform subject matter experts who will be descending at Portland this weekend to mingle with data professionals. What’s more a number of them will be surfacing a w...

https://troubleshootingsql.com/2017/10/27/sql-saturday-686-upgrade-your-sql-server-like-a-ninja/

PostgreSQL and MySQL are ubiquitous names in the world of open source relational databases. These databases engines have been widely embraced by developers in recent years. Microsoft’s Azure cl...

https://troubleshootingsql.com/2017/08/18/managed-postgresql-and-mysql-for-azure/

I will be speaking at the Data Platform Summit happening at Bangalore from Aug 17-19, 2017. I will be delivering sessions on achieving a million predictions/sec using SQL Server and introduce our...

https://troubleshootingsql.com/2017/08/13/data-platform-summit-2017/

Last Saturday, I presented a session on how to use R-Services with SQL Server to build an analytical workflow for banking solutions. I talked about how our customer, Jack Henry & Associates, an S...

https://troubleshootingsql.com/2017/04/17/sql-saturday-613-building-1-million-predictions-per-second-with-r-services-and-sql-server-2016/

My last contribution to a book was in 2012. With the advent of the cloud and my continuing work with SQL Server, I jumped at the opportunity when my friends and colleagues, Pranab Mazumdar and S...

https://troubleshootingsql.com/2017/02/06/book-on-azure-and-sql-server/

If you are looking to upgrade your SQL Server replication topology, then you can look at the post that I published on the Tiger blog.

https://troubleshootingsql.com/2017/02/02/upgrading-a-replication-topology-to-sql-server-2016/

I published a blog post on the Tiger blog on a recent change that was introduced for SQLVID. You can also use the SQL Server Backup Simulator which is available on our tigertoolbox GitHub reposit...

https://troubleshootingsql.com/2017/01/29/introducing-vdc_complete-for-backup-and-restore-applications-using-sqlvdi/