SQLSaturday #1004 – Bangladesh – Virtual 2020
Event Date: 11/28/2020 00:00:00
Event Location:
- Microsoft Bangladesh
- Laila Tower, 4th Floor, 8 Gulshan Avenue, Gulshan-1
- Dhaka, Dhaka, Bangladesh
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Azure SQL Database-Business Continuity During Disaster
Abstract: Azure SQL Database is a relational database-as-a-service (DBaaS) based on the latest version of the Microsoft SQL Server Database Engine. You can build data-driven applications and websites in the programming language of your choice, without needing to manage infrastructure.
While considering Azure SQL Database, two of the most critical questions you need to answer are what are my options for business continuity and how to implement these options?
In this demo intensive session, I will talk about five specific options and show you how to implement those. You will walk out of this session equipped with knowledge and scripts to implement appropriate High Availability and Disaster Recovery solutions for your Azure SQL Database.
Speaker(s):
- Taiob Ali
Track and Room: Enterprise Database Administration Deployment - Virtual Event
Title: Multi-server agent jobs administration with happy faces and pigeons
Abstract: This talk will be about multi-server administration using MSX and TSX servers. Built-in feature you may have seen, but was too scared to play with. Will show you how to configure multi-server environment and how to manage it with least possible resources.
What SQL Server and pigeons have in common? Not much, besides that you do not want to be a pigeon – pigeon post to be specific. I have been a DBA pigeon in my past. Managing hundreds of SQL Servers and visiting every single SQL Agent to setup the maintenance jobs, backup jobs or any jobs that would help me to keep the servers up and running. Sometimes using SQL scripts, other times Powershell scripts to deploy or update new jobs, but it was still the same ol’ way. Flying between instances like a bird. Until, one day, I found out about MSX and TSX! And now my life is full of happy faces! I want your face to be happy too.
In this session you will learn how easy is to setup this hidden and forgotten feature of SQL Server. Will show you
Speaker(s):
- Mikey Bronowski
Track and Room: Enterprise Database Administration Deployment - Virtual Event
Title: How to audit and prevent unwanted user actions.
Abstract: Abstract:
Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.
Coverage:
1 – Granting correct user access is vital. 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications. 5 – Preventing unwanted SCHEMA changes. 6 – Preventing table TRUNCATIONS. 7 – LOGIN triggers to control who, what, and when. 8 – Change data capture (CDC) an alternative to triggers. 9 - Which of these techniques apply to an Azure SQL database?
Speaker(s):
- John Miner
Track and Room: Application Database Development - Virtual Event
Title: Life Cycle of a Query in SQL Server
Abstract: Many DBA’s and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Relational Engine, Storage engine, Cache and the Transaction manager. We will also cover what happens under the covers during read and write operations within SQL Server. Deepthi will show you how the SQL engine thinks – enabling you to think like it!
Speaker(s):
- Deepthi Goguri
Track and Room: Enterprise Database Administration Deployment - Virtual Event
Title: SQL Server Security Features
Abstract: SQL Server provides several several security features for developers and architects. Features such as Dynamic Data Masking (DDM), “Always Encrypted”, and Row-Level Security provide an additional level of security natively through the database server. We’ll explore the implementation of these features on the client/server for data in transmission or at rest. In addition, we’ll examine built-in features and custom implementations.
Speaker(s):
- Sam Nasr
Track and Room: Application Database Development - Virtual Event
Title: Integrate existing apps and publish blockchain ledger data to SQL using Azure Blockchain as Service
Abstract: Block chain is very fast growing technology.It is going to transform industry , lot of RD and initiatives going on in this area. In this session, we will discuss some fundamentals of Blockchain and how Azure Blockchain can help in Blockchain app development, deployment and integration with your existing applications .We will also see how we can capture Blockchain ledger events to a SQL Database or Cosmos DB.
Speaker(s):
- Mohammad Asif Waquar
Track and Room: Cloud Application Development Deployment - Virtual Event
Title: Hacking SQL Server Is Not Enough
Abstract: You already know how easy it is to hack SQL Server… But how do you protect your local and cloud servers against enemy agent attacks? This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered. Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Speaker(s):
- André Melancia
Track and Room: Enterprise Database Administration Deployment - Virtual Event
Title: Intelligent Query Processing Feature Family
Abstract: Azure SQL and SQL Server 2019 boasts a lot of improvements for SQL databases across the board from Intelligent performance, layers of security, availability, platform support to intelligence over all your data. In this session we will focus on the latest improvements in performance - The Intelligent Query Processing Feature Family. We’ll take a look at the features that provide a broad impact on performance for your existing workloads with minimal implementation effort and no application changes.
Speaker(s):
- Pio Balistoy
Track and Room: Enterprise Database Administration Deployment - Virtual Event
Title: SQL Server Internals and Tuning
Abstract: SQL Server Internals and Tuning” is designed for experienced SQL Server professionals who want to know how SQL Server really works, in order to take maximum advantage of its potential. The session includes demonstrations that illustrate the details of SQL Server internals as well as tuning techniques. Cover features specific to that version, but most of the information is relevant to SQL Server 2016 and SQL Server 2014, and some is relevant to earlier versions.
Speaker(s):
- Ahsan Kabir
Track and Room: Enterprise Database Administration Deployment - Virtual Event
Title: Azure SQL Replication
Abstract: Azure SQL is a relational database that is provided as a completely managed service by Microsoft. Built on top of SQL Server, Azure SQL boasts of a very well equipped querying layer and rock-solid stability. This blog will let you carry out Azure SQL replication easily.
Speaker(s):
- M A Nakib
Track and Room: Cloud Application Development Deployment - Virtual Event
Title: Monitoring SQL Server using Community solutions (Free)
Abstract: In this session we will cover how to monitor and support any SQL Server Environment using free tools created by community members
Speaker(s):
- Javier Villegas
Track and Room: Enterprise Database Administration Deployment - Virtual Event
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Mohammad Asif Waquar
Twitter: - asifwaquar
LinkedIn: Mohammad Asif Waquar
Contact: http://asifwaquar.com/
Asif is Microsoft MVP ,Microsoft Azure Platform .He specialises in Microsoft development, Blockchain, Mobile App and Cloud technologies. He works as Solution Architect at ABN AMRO Bank .He is certified in Corda and Hyperledger Development Framework for block chain. He has successfully implemented solutions for Trade finance on the Quorum Block chain.
He has completed his Masters in Software Engineering from NUS Singapore.Actively blogs at http://asifwaquar.com. Active in the developer community as public speaker, mentor etc. As an active member of SQL Server community and Azure Community, Asif leads Singapore SQL Server Pass Chapter (User group).
Ahsan Kabir
Twitter: - ahsan_kabir_
LinkedIn: Ahsan Kabir
Contact: https://techforumbd.github.io/techforum/
Ahsan Kabir is now working as software development project manager from last few years. He has started carrier as Software Engineer. He has more than twelve years of experience of working on large enterprise Application project i.e. Banking Solution, ERP solution. He has worked every phase of SDLC. Beside that he contributed his experience and skill on different professional forum and Microsoft technical community as technical speaker .He writes article on blog and assist other technical people providing problem solving answer through different forum. He is rewarded as MVP Awarded by Microsoft. He is the PASS chapter leader of Bangladesh-quot;techforum PASSquot;. Ahsan is very active in the developer community and volunteers his time for
Sam Nasr
Twitter: - SamNasr
LinkedIn: Sam Nasr
Contact: http://samnasr.blogspot.com/
Sam Nasr has been a software developer since 1995, focusing mostly on Microsoft technologies. He’s a Sr. Software Engineer with NIS Technologies where he consults and teaches clients about the latest .Net technologies. Sam has achieved multiple certifications from Microsoft (MCSA, MCAD, MCTS, MCT), and is the leader of the Cleveland C#/VB.Net User Group since 2003. In addition, he’s the leader of the .Net Study Group, an author for Visual Studio Magazine, and a Microsoft MVP since 2013. When not coding, Sam loves spending time with his family and friends or volunteering at his local church.
John Miner
Twitter: - https://twitter.com/JohnMiner3
LinkedIn: John Miner
Contact: https://www.mssqltips.com/sqlserverauthor/154/john-miner/
John Miner is currently a Data Architect at Insight DI (BlueMetal) advising corporations on how to solve their business needs with data platform solutions.
He has over twenty five years of data processing experience, and his architecture expertise encompasses all phases of the software project life cycle, including design, development, implementation, and maintenance of systems.
He has an undergraduate and graduate degrees in Computer Science from the University of Rhode Island. Other credentials include an up to date MCSE certificate and currently taking the Data Science program from EDX.
Before joining BlueMetal, John won the Data Platform MVP award in 2014 and 2015 for his outstanding contributions to the SQL Server community.
Damian Widera
Twitter: - @DamianWidera
LinkedIn: Damian Widera
Contact: https://codingfamily.net
SQL Server MVP amp; MCT Software engineer with 18+ years of professional experience in all aspects of software development. Damian participated in a number of projects in international environments and possesses practical knowledge of procedures and tools which are necessary for successful implementation of such projects. Now he focuses on building solutions based on Microsoft SQL Server environment (including complex database driven systems, database tuning and optimization).
Mikey Bronowski
Twitter: - MikeyBronowski
LinkedIn: Mikey Bronowski
Contact: https://bronowski.it/blog
What do I do? I select, I select stars!
Data enthusiast with a mathematics background in relation with SQL Server for over 10 years. Works as a database administrator (Microsoft SQL Server) responsible for environments upgrades and migrations. Microsoft Certified Trainer with a couple of certificates (MCP, MCSE Data Platform). Blogger at (bronowski.it/blog).
Not long ago Poland Data Community member, now proud UK Data Platform active member.
When not working or teaching, learns new things or attends various data/technical conferences and meetups.
Italian Calcio fan and traveller.
Taiob Ali
Twitter: - SqlWorldWide
LinkedIn: Taiob Ali
Contact: http://www.sqlworldwide.com
Taiob Ali, MVP Data Platform, is an accomplished technical leader with a proven record of success. For 14 years, he has worked with the Microsoft Data Platform and MongoDB both on-premise and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning. Taiob is currently working at “GMO LLC” as a Database Solution Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQLSaturdays, and Azure conferences.
Javier Villegas
Twitter: - https://www.twitter.com/javier_vill
LinkedIn: Javier Villegas
Contact: http://sql-javier-villegas.blogspot.com.ar/
Javier Villegas is a Database Administrator Manager for Mediterranean Shipping Company. Javier has more than 20 years working with SQL Server on every version from 6.5 to SQL Server 2019, Including SQL Azure Database and SQL Azure Managed Instance. His specialization is Administration, Performance Tuning and High Availability. He is a Microsoft MVP in Data Platform. Javier is a frequent speaker in conferences and events such as SQLSaturday , PASS Virtual Groups, 24 Hours SQL PASS , vOpen(NetConf), GroupBy and DataPlatformGeeks. @sqlargentina
Tracy Boggiano
Twitter: - TracyBoggiano
LinkedIn: Tracy Boggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.
Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.
Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
Deepthi Goguri
Twitter: - dbanuggets
Contact: https://dbanuggets.com/
Deepthi is a SQL Server Database Administrator with 7+ years of experience in administering SQL Servers. She is a Microsoft certified Trainer and professional with an Associate and Expert level certification in Data Management and Analytics. Deepthi completed her Masters in Computer Technology at Eastern Illinois University. She blog for DBANuggets.com.
Thimantha Vidanagamage
Twitter: - ThimanthaV
LinkedIn: Thimantha Vidanagamage
Contact: https://thimantha.wordpress.com/
Thimantha Vidanagamage is a Microsoft Certified Data Analyst Associate with 2+ years of experience in Microsoft Business Intelligence. He is passionate about technologies such as Microsoft Power BI, Azure Analysis Services, Azure Data Factory and Azure Data Lake Gen2. Currently, he is an Associate Microsoft Business Intelligence Consultant for Fortude (Pvt) Ltd. which is the only Microsoft Gold Partner for Data Analytics and Data Platform in Sri Lanka.
André Melancia
Twitter: - AndyPT
LinkedIn: André Melancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.
19+ years’ fun developing information and multimedia systems, DBA, project and IT management.
Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.
Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.
Go to http://Andy.PT and you’ll know the same as the NSA…
Thimantha Vidanagamage
Twitter: - ThimanthaV
LinkedIn: Thimantha Vidanagamage
Contact: https://thimantha.wordpress.com/
Thimantha Vidanagamage is a Microsoft Certified Data Analyst Associate with 2+ years of experience in Microsoft Business Intelligence. He is passionate about technologies such as Microsoft Power BI, Azure Analysis Services, Azure Data Factory and Azure Data Lake Gen2. Currently, he is an Associate Microsoft Business Intelligence Consultant for Fortude (Pvt) Ltd. which is the only Microsoft Gold Partner for Data Analytics and Data Platform in Sri Lanka.
M A Nakib
Twitter: - nakib_juris
LinkedIn: M A Nakib
Contact: https://nakibjuris.medium.com/
Nakib is a smart and young IT professional, MCT, Cloud Architect working with Corporate Projukti limited as Cloud Solutions. He had 2 years’ experience in Microsoft Bangladesh. Being an adviser, he involves in building and enhance solutions customer readiness on Microsoft Azure, O365 other Cloud based service. He assists decision making audience in context of Microsoft product services. Nakib is renowned community person- From graduation time he had started his community contribution from university life being an MSP LEAD. He had engaged different technical workshop being a speaker as well as organized. He started his carrier as intern on Microsoft Bangladesh. He works on tech community development and trainer in of IT education work
Pio Balistoy
Twitter: - Pioisms
LinkedIn: Pio Balistoy
Contact: https://lazysqlwriter.wordpress.com/; https://blog.pythian.com/author/balistoy/
Pio Balistoy is a Microsoft MVP Certified Trainer for Data Platform. A SQL Server professional with more than 17 years of experience with SQL Server operations, architecture and administration. He brings his passion for SQL Server as the community leader for Singapore SQL PASS and Philippine SQL Server User Group. He is currently one of the Lead Microsoft Data Platform Consultant for The Pythian Services - a global IT product and services company with headquarters in Ottawa, New York, Sydney, UK and India. He also co-founded Excent One Inc, a technology solutions company based in the Philippines and Singapore that helps SMEs integrate and develop Microsoft based business Applications.
Sponsors
The following is a list of sponsors that helped fund the event: