Hi There, Tomorrow (Apr 29), you can learn how to do SQL Server Health Check. Next week, you can join the Virtual Symposium having 15 sessions spread across AMERICA, EMEA & APAC Time Zone. And guess what, we are releasing DPS 2020 content each week. So here you go, check out below, whatever suits you. Finally, [...]
SQLM Bulletin #15. March 16, 2021. Hi there, SQLMaestros is coming up with a deep dive session on March 24 & 25 for the SQL folks. Session Title: 6 Techniques to Make SQL Server Speedometer Go Crazy. This session is for you if you are someone working on SQL Server Performance Tuning stuff. How to [...]
Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]
Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]
Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]
Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter Thanks for reading & watching. If you liked the content, do share it. I am on Twitter if you wish to connect. You can also subscribe to my exclusive [...]
Let’s understand a few reasons why SQL Server (sometimes) does not show missing index hints. We are using AdventureWorks2016 database for the demo. Let’s make a copy of Sales.Customer table as Sales.CustomerDup SELECT * INTO sales.customerdup FROM sales.customer Before jumping into the actual query, have a look at AccountNumber column which is of VARCHAR data [...]
The full virtual tour of DPS 2020 has been released. Watch now. Hi There, We are thrilled to announce Rohan Kumar (Corporate Vice President, Azure Data, Microsoft Corporation) as the keynote speaker for Data Platform Virtual Summit 2020. Rohan Kumar will share the latest innovations from Microsoft Data Platform and showcase intriguing customer case studies. [...]
PS: Until DPS 2020, all our bulletins by DataPlatformGeeks, SQLServerGeeks, SQLMaestros, DPS and ConnectWithAB will be combined into a single bulletin which will be sent out every Monday/Tuesday of the week. Highlight: DPS 2020 Virtual Platform First Look – Click Here. Spotlight: Microsoft blogs about DPS 2020 – Click Here. Hi There, In today’s bulletin [...]
PS: Until DPS 2020, all our bulletins by DataPlatformGeeks, SQLServerGeeks, SQLMaestros, DPS and ConnectWithAB will be combined into a single bulletin which will be sent out every Monday/Tuesday of the week. Hi There, Today’s bulletin is a lot about performance. Upcoming Session (Free) If you or your team members work with SQL Server or Azure [...]
SQLM Bulletin #11. October 08, 2020. Add SQLMaestros to your address book. Spotlight: Triple content compared to previous years. Half the price. Complimentary recordings. Microsoft Sessions Announced Learn More. Hi There, Here is the SQLMaestros Bulletin of 08 October, 2020. Highlights of Today’s Bulletin This Thursday, Virtual Symposium on Azure Analytics & Artificial Intelligence. Join Us General Sessions Part-2 announced for [...]
Date: 24 September 2020 Topic: Three Query Tuning Techniques For SQL Developers Abstract: In this session, you will learn three important querying tuning techniques that might solve 50% of your query performance issues. Trainer/Speaker: AMIT R S BANSAL
Date: 17 September 2020 Topic: Implementing SQL Server Extended Events Abstract: In this session, you will learn how to implement Extended Events the right way. You will get a comprehensive overview of XEvents, a tour of GUI and key features, and a few real-world examples of putting XEvents to production to use. Trainer/Speaker: AMIT R [...]
Date: 10 September 2020 Topic: Implementing Extended Events Part 2 Abstract: In this session, you will learn how to implement Extended Events the right way. You will get a comprehensive overview of XEvents, a tour of GUI and key features, and a few real-world examples of putting XEvents to production to use. Trainer/Speaker: AMIT R [...]
Date: 03 September 2020 Topic: Implementing Extended Events Part 1 Abstract: In this session, you will learn how to implement Extended Events the right way. You will get a comprehensive overview of XEvents, a tour of GUI and key features, and a few real-world examples of putting XEvents to production to use. Trainer/Speaker: AMIT R [...]
SQLM Bulletin #10. September 29, 2020. Add SQLMaestros to your address book. Spotlight: Data Platform Virtual Summit Updated Content & Pricing Model. Click Here. (200 SQL Sessions + Recordings – You cannot afford to skip this) Hi There, Here is the SQLMaestros Bulletin of 29 September, 2020. Highlights of Today’s Bulletin This Thursday, LIVE Geek Talk [...]
Hello Friends, Here is another popular lab from Hands-On-Lab library: Transform Data Using Azure Data Factory. Azure Data Factory is a cloud-based data integration service that automates the movement and transformation of data. We can create data integration solutions using the Data Factory service that can read data from various data stores, transform/process the data, [...]
Hello Friends, Here is another popular lab from Hands-On-Lab library: Transform Data in Azure Data Factory using Visual Studio – Hive Activity. Azure Data Factory is a cloud-based data integration service that automates the movement and transformation of data. We can create data integration solutions using the Data Factory service that can read data from [...]
