Category Archives: SQL Server 2016

AWS S3—>AWS Lambda —>SSM—> SQL Server Job

Scenario: Application is running on java and the database is using PostgreSQL.  Application user uploads the data and this data needs to process to analytic server as well. There is no direct access to Analytic Database server that is running … Continue reading

Posted in AWS, AWS Lambda, AWS SSM, PostgreSQL, S3, SQL Server 2016 | Leave a comment

New SQL Server 2016 Online Alter column

Over the few months i have been playing with SQL Server 2016 new features. Microsoft SQL Server 2016 introduced new alter column with ONLINE option. Let’s explore this. Create a table and insert data    Find what page has been allocated … Continue reading

Posted in Database Administration, SQL Server 2016, T-SQL | Leave a comment

New SQL Server 2016 Live Query Statistics

SQL Server 2016 introduce a new feature Live query statistics which allows us to view the  real-time insights into query without needing to wait for the query to complete. The live query plan displays the overall query progress and operator-level … Continue reading

Posted in Database Administration, SQL Server 2016 | Leave a comment

New SQL Server 2016 SCOPED CONFIGURATION

Microsoft SQL Server 2016 introduced new way of configuring some of the instance level setting to database level which gives you the ability to easily make several database level configuration changes such as Setting MAXDOP for an individual database Set … Continue reading

Posted in Database Administration, SQL Server 2016 | Leave a comment