Category: Articles

  • Query Editor – Azure Portal

    An interesting new tool (in preview) added to Azure SQL database. Now Azure portal provides flexibility to query azure sql database from a browser!! Interesting! you can simply connect to Azure portal from any browser, view the database and then launch this tool to get connected to the database.  When you are in support this is […]

  • Always Encrypted – An Over View – Part 1

    Always encrypted is a new feature introduced to encrypt the  in rest as well as during transport. It’s been quite long time the feature has been released to general public. In this encryption method the encryption will be done at the client side. Encryption keys can be stored in Azure vault, Windows certificate store in client server or in hardware module. […]

  • SSIS 2014 Execution Error while validating Script Component

    It’s been so long after my last article. Looks like I been lazy for few years now 🙂 I assume lot of people using  SSIS package deployment utility after they support project deployment model. I always use the ispac for easier deployment though it doesn’t support environments variables in deployment. Today we deployed a project to our environment […]

  • Clear Procedure Cache in SQL Azure database

    When we were working on performance baseline or performance improvement we might be clearing down the procedure cache to get the exact statistics of the stored procedure. Many of them are already aware how to do it in hosue SQL Server. We might be using anyone of the below command to clear the procedure cache.

  • SQL Server 2016 – Truncate Table Supports Partitioning

    SQL Server 2016 – Truncate Table Supports Partitioning

    It’s been a month after the new year started. Hope everyone is having a wonderful time. This is my first post for this year and it’s a simple one but most of them are looking around for this option quite from SQL Server 2012.