This is a session about new features in SQL Server Management Studio and runtime data exposed via showplan. Microsoft’s goal is to make showplan, one stop shop for query performance troubleshooting. I presented the session to following user groups and events.
SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which also enabled rapid enhancement to Graphical Execution Plan (Showplan).
Do you know that ‘Vulnerability Assessment’ per Database and Availability Group …
This is a session about Azure Automation service and how you can perform some of SQL Agent functionality against Azure SQL Database using runbook. I presented the session to following user groups and events.
You want to migrate your on-premise SQL Database to cloud, taking advantage of PaaS offering of Azure SQL Database. Soon you recognize the SQL Agent is not available. You heard the promise of spinning up databases on demand and …
I want to acknowledge that my learning goal will change with time and it happens every year. My first priority is my employer. I need to learn, improve and implement what the company need. Beside that I also want to learn things that are of my personal interest.
Microsoft Professional Program for Big Data track
This is a session about cardinality estimation, a phase during query optimization. I presented the session to following user groups.
SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query …
This is a session about migrating on premise SQL database to Microsoft Azure SQL V12. I present the session to following user groups.
There are many tools available to successfully migrate your on-premises relational database to Microsoft Azure SQL V12 database. Do …