Manish Kumar is a Microsoft certified Solution Expert in ‘Data Management and Analytics’ and work as a Sr. cloud solution architect at Microsoft. He is a thought leader in modern data platform which includes solutions involving relational and non-relational databases, data lakes, advanced analytics, MPP, big data and hybrid cloud implementations. He has over 22 years of IT experience working as Software developer, SQL Server DBA, Solution/Data Architect, Cloud Solution Architect and extremely passionate about blogging and public speaking.
Manish Kumar's Sessions
Mastering Azure SQL PaaS: A 100-Minute Journey from Novice to ExpertSQLBits 2024
Welcome to a comprehensive deep dive into the world of Azure SQL Platform as a Service (PaaS). In this 100-minute session tailored for beginners to intermediate SQL Server professionals, we will embark on a transformative journey, transitioning you from a novice to a hero in Azure SQL. Whether you have limited understanding or are new to Azure SQL, this session is your gateway to mastering key concepts, deployment options, and advanced techniques in a condensed, informative, and engaging format. Session Highlights: 1. Introduction to Azure SQL: Overview of Azure SQL: Understand the fundamental concepts of Azure SQL, including its architecture, benefits, and integration with the Azure ecosystem. Deployment Models: Explore various deployment options, including Single Database, Elastic Pool, and Managed Instance, understanding the best use cases for each. 2. High Availability and Business Continuity: Business Continuity: Delve into high availability and disaster recovery features in Azure SQL, such as Geo-Replication, Automatic Failover Groups, and Backup and Restore options. We will discuss strategies for ensuring business continuity, data resilience, and fault tolerance in Azure SQL deployments. 3. Migration of SQL Server to Azure SQL: Assessment and Planning: Learn the essential steps for assessing existing SQL Server databases and creating a migration plan tailored for Azure SQL. Migration Tools: Explore practical migration tools and methods, ensuring a smooth transition from on-premises SQL Server to Azure SQL. 4. Admin Tasks and Performance Optimization: Administering Azure SQL: Dive into administrative tasks such as configuring database file layout, time zones, backup and restore, maintenance tasks etc. Performance Optimization: Understand performance monitoring and optimization techniques in Azure SQL. 5. Security and Compliance: Data Security: Explore Azure SQL built-in security features Compliance: Discuss compliance standards and practices, ensuring your Azure SQL deployments meet regulatory requirements and industry best practices. Who Should Attend: SQL Server Professionals: Database administrators, developers, and architects seeking to enhance their skills and knowledge in Azure SQL. Beginners to Intermediate: Individuals with little or moderate understanding of Azure SQL, aiming to build a strong foundation and expertise in the platform.
Empowering SQL: Mastering Intelligent Query Processing in 20 MinutesSQLBits 2024
Dive into the heart of database optimization with our 20-minute session on Intelligent Query Processing (IQP) in SQL Server and Azure SQL. In this power-packed talk, we will demystify IQP, the driving force behind accelerated query performance. We'll begin with a quick overview, highlighting the pivotal role of IQP in query optimization and database efficiency. Then, we'll dive into key IQP features focusing on their impacts through real-world examples, any overheads or best practices you must be aware to ensure efficient execution.
Managed Instance Link - Seamless migration to AzureSQLBits 2023
We, the cloud solutions architects from Microsoft, will be talking around SQL migration journey from on-prem to Azure SQL in general, taking you through all available Microsoft's migration tools like DMA, DMS, Azure Migrate, ADS, etc, and then focus on migration to Managed Instance using SQL MI Link. You should take away with you the understanding of when to use which tool and how the newly available Azure SQL Managed Instance Link can help you to achieve a minimum downtime migration of on-prem SQL Server to Azure SQL Managed Instance.
The Power of Polybase with SQL - True data VirtualisationSQLBits 2023
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server. Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.
Performance Tuning of Azure SQL DBSQLBits 2019
Manish Kumar from Microsoft will take you through various performance tuning measures you should take before increasing service tier of your database. The session will be packed with tons of information, steps and demos.