SQLSaturday #528 - Curacao 2016
Event Date: 06/11/2016 00:00:00
Event Location:
- University of Curacao
- 111 Jan Noorduynweg
- Willemstad, Curaçao, Netherlands Antilles
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: Common SQL Server Mistakes and How to Avoid Them
Abstract: Making mistakes is human nature, avoiding them comes from experience and shared wisdom from others. In this session, Tim Radney will share experiences he has encountered supporting multiple fortune level companies. Tim will share real world experiences of environments he has worked on and the impact he has seen from administrators not knowing how to properly configure and administer SQL Server. In this session you will learn many accepted best practices for installing, configuring and supporting SQL Server to help your environment run as smooth as possible. When you leave this session you will have a checklist of items to take back to your shop to make sure your environment is configured properly.
Speaker(s):
- Tim Radney
Track and Room: Enterprise Database Administration Deployment - ClassroomB
Title: Understanding SQL Server Backup and Restore
Abstract: Everyone knows that it’s critical to have backups but it’s amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, filegroup, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There’s something here for everyone to learn!
Speaker(s):
- Tim Radney
Track and Room: Enterprise Database Administration Deployment - ClassroomB
Title: DBA Vs. Hacker: Protecting SQL Server
Abstract: This was never showed before, a Hacker and DBA fighting against the time! The brilliant hacker mind trying to intrude and gain access inside of SQL Server to steal the most valued data using the Kalil Linux distribution when in other side the DBA avoing such achievement by using the security best practice and features available on SQL Server.
A Hacker’s goal is to find vulnerabilities in a system and a DBA’s goal is to make the environment secure and reliable. In this session we will learn how to protect SQL Server from the various forms of attacks that a smart hacker can throw at you. Let’s dig in the Hacker thought process to understand the inception of the attack and how to defeat the invasion. Join with me in this internal session using SQL Server and Kali Linux for the ultimate security showdown!
Speaker(s):
- Luan Moreno Medeiros Maciel
Track and Room: BI Platform Architecture, Development Administration - ClassroomB
Title: DBaaS on Azure - SQL Database Best Practices
Abstract:
The new term called - DBaaS (Database as a Service) is being widely recognised nowadays, this denomination provides a flexible, scalable and on-demand platform that is oriented toward self-service and easy management delivering, principally in terms of provisioning a business own environment. Is not necessary anymore the acquirement of a machine on the Microsoft Cloud [IaaS] to run a SQL Server Database, now you can leave this complexity behind by handing over this responsibility to Microsoft Azure Datacenter.
This new technology is being adopted for a lot of customers around the world and now it’s your time to get into it by learning the best practices configurations and caveats. Immerse yourself in this session and learn how to provide a to your customer the best database solution available on the market, the SQL Database from Microsoft Azure.
Speaker(s):
- Luan Moreno Medeiros Maciel
Track and Room: Cloud Application Development Deployment - ClassroomB
Title: Locking, blocking, and troubleshooting - Trial by FIRE!
Abstract: NOLOCK is like the duct tape of SQL Server, it fixes everything. Want to run reports on a live production server, add NOLOCK. Do you have a large blocking chains, add NOLOCK. Actually, NOLOCK is NOT the answer and we will tell you why and give better solutions.
In this session, we will deep dive into how isolation levels work and impact your concurrency. We will also cover how to troubleshoot locking and blocking issues within your system with the newfound locking knowledge. At the end of this session, you will be able to better understand how to identify and solve blocking chains in your system.
This is an interactive session, so please come prepared to help the class troubleshoot.
Speaker(s):
- Daniel Janik
Track and Room: Application Database Development - Aula
Title: T-SQL: Tips and Tricks
Abstract: Queries are running longer than expected? Your database server isn’t performing as well as it should? There are many reason that this could be happening and one of them is the T-SQL being executed on the system. T-SQL offers various ways to get the information that you need but sometimes the option you choose might return the data that you want but may not be the best query structure or logic to use. This session will share insight on how basic query structure and logic works so you can avoid wasting too much time on trial and error when writing queries. It will also show you some tips and tricks to avoid some bad T-SQL coding habits and help you write better queries. This session is for Developers and Database Administrators.
Speaker(s):
- Nigel Sammy
Track and Room: Application Database Development - Aula
Title: SQL Server OLTP - Monitoring and Troubleshooting
Abstract: This session will start from the basics of troubleshooting in SQL Server.Then move into a deeper level of monitoring and troubleshooting in online transaction processing databases .We will be looking into performance bottleneck identification (blocking, system resource contention, application design problems, queries or stored procedures that have long execution times), tuning queries, CPU highjackers, memory leaks and many more bad things which can ruin your SQL Server instance. We are going to use SQL Server built-in tools such as activity monitor, DMV’s, reports, query optimizer and other third-party tools to identify and troubleshoot SQL Server.
Speaker(s):
- Rohan Joackhim
Track and Room: Enterprise Database Administration Deployment - ClassroomB
Title: SQL Server: Indexing Fundamentals
Abstract: We all have indexes in our databases or at least should have indexes in them, but the question is, do we have the right types of indexes? Do we have too many or not enough? Are my indexes beneficial to my database? This session will leave you with the ability to answer these questions and more. We’ll review the different types of indexes in SQL Server and also discuss the structure of some of the main ones. I will show you how to verify if your indexes are being used, if they are being duplicated and finally how to maintain your indexes.
Speaker(s):
- Nigel Sammy
Track and Room: Application Database Development - Aula
Title: 7 things you need to know about TempDB
Abstract: TempDB is the most popular database in SQL Server. In this session you will learn how to configure your TempDB for getting the best performance out of it. You will also learn about the improvements on TempDB in SQL Server 2016. When you go back to your SQL Servers you will be eager to implement the things you learned during this session.
Speaker(s):
- Ignacio Salom Rangel
Track and Room: Enterprise Database Administration Deployment - Aula
Title: Contained Database
Abstract: There are times that for one reason or another we will need to move a database from one SQL Server instance to another instance. Before SQL Server 2012 this was a little difficult because the database relies on data that resides outside the database and we had the extra work to move or restore data that resides outside the database also to the new instance. With the release of SQL Server 2012 Microsoft introduced contained database, this feature allows us to move a database to another instances without the having to move data that resides outside the database, because the contained database had all the necessary settings and metadata.
Speaker(s):
- Roy Ernest
Track and Room: Enterprise Database Administration Deployment - Aula
Title: Understanding and Controlling Transaction Logs
Abstract: This session will unravel the mysteries of the transaction log, including how you can manage your logs and optimize their performance. Transaction logging is one of the most important activities SQL Server does for you, and understanding it thoroughly means you can ensure SQL Server does the best job possible. You’ll leave with tips you can implement as soon as you get back to the office.
Speaker(s):
- Nigel Sammy
Track and Room: Enterprise Database Administration Deployment - Aula
Title: Analyze your query plan like a Microsoft Engineer!
Abstract: This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the “noteworthy” query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.
Speaker(s):
- Daniel Janik
Track and Room: Advanced Analysis Techniques - ClassroomB
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Nigel Sammy
Twitter: - @NigelSammy
LinkedIn: Nigel Sammy
Contact: http://www.nigelpsammy.com/
Nigel Peter Sammy is a Microsoft Data Platform MVP with over 15 years of technical experience which includes 12 years of database and SQL Server experience. Nigel previously worked at Microsoft as an Account Technology Strategist where he was responsible for providing pre-sales technical/architectural support for Commercial and Public Sector customers. He was also responsible for delivering technical presentations and proof of concepts using SQL Server, Azure and Power BI . He is a co-author of Microsoft’s SQL Server 2012 Upgrade Technical Guide and a technical editor of Wrox’s Microsoft SQL Server 2012 and 2016 Reporting Services books. For the last 9 years he has been presenting for conferences locally and internationally.
Luan Moreno Medeiros Maciel
Twitter: - @luansql
LinkedIn: Luan Moreno Medeiros Maciel
Contact: https://luanmorenodba.wordpress.com/ amp; http://www.sqlshack.com/author/luan-moreno-m-maciel/
Based out of Brazil, Luan Moreno credits his ability to solve problems to thinking critically before acting. He values working with a team because he and his clients can benefit from various perspectives and collaboration, particularly when faced with difficult issues. When Luan Moreno first became interested in technology, he didn’t have a mentor, so he made a commitment to teaching others in the community and sharing his knowledge through blogging, speaking engagements.
Luan Moreno is a addicted Brazilian blogger and speaker. SQL Server MCT, MCSE and MVP living in Brazil. Nowadays he#39;s a Database Consultant at Pythian, company based in Ottawa - Canada.#160;
Nigel Sammy
Twitter: - @NigelSammy
LinkedIn: Nigel Sammy
Contact: http://www.nigelpsammy.com/
Nigel Peter Sammy is a Microsoft Data Platform MVP with over 15 years of technical experience which includes 12 years of database and SQL Server experience. Nigel previously worked at Microsoft as an Account Technology Strategist where he was responsible for providing pre-sales technical/architectural support for Commercial and Public Sector customers. He was also responsible for delivering technical presentations and proof of concepts using SQL Server, Azure and Power BI . He is a co-author of Microsoft’s SQL Server 2012 Upgrade Technical Guide and a technical editor of Wrox’s Microsoft SQL Server 2012 and 2016 Reporting Services books. For the last 9 years he has been presenting for conferences locally and internationally.
Rohan Joackhim
Twitter: - @rohanjoackhim
LinkedIn: Rohan Joackhim
Rohan has been working with SQL Server since 2001. His experience includes SQL Server projects dealing with HP Europe, financial institutions in Canada and data centers in the Dutch Caribbean. He is currently dealing with databases in 24/7 high availability environments . He was an active member and a presenter of the PASS chapter Toronto. Rohan holds a Bachelor of Computer Engineering degree and he is MCDBA SQL Server 2008 and ITIL V3 certified.
Nigel Sammy
Twitter: - @NigelSammy
LinkedIn: Nigel Sammy
Contact: http://www.nigelpsammy.com/
Nigel Peter Sammy is a Microsoft Data Platform MVP with over 15 years of technical experience which includes 12 years of database and SQL Server experience. Nigel previously worked at Microsoft as an Account Technology Strategist where he was responsible for providing pre-sales technical/architectural support for Commercial and Public Sector customers. He was also responsible for delivering technical presentations and proof of concepts using SQL Server, Azure and Power BI . He is a co-author of Microsoft’s SQL Server 2012 Upgrade Technical Guide and a technical editor of Wrox’s Microsoft SQL Server 2012 and 2016 Reporting Services books. For the last 9 years he has been presenting for conferences locally and internationally.
Roy Ernest
Twitter: - @RumblingDBA
LinkedIn: Roy Ernest
Contact: http://www.sqlservercentral.com/blogs/dba_rumblings/
Roy Ernest (Twitter: @RumblingDBA) currently works as the Manager of the IT-DBA Department for Zarb Corporation. He is the Leader of the Curacao SQL Server User group. Roy is very active in the SQL Server community and volunteers his time for the PASS organization. You can read his blog at http://www.sqlservercentral.com/blogs/dba_rumblings/default.aspx.
Tim Radney
Twitter: - @tradney
LinkedIn: Tim Radney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Rohan Joackhim
Twitter: - @rohanjoackhim
LinkedIn: Rohan Joackhim
Rohan has been working with SQL Server since 2001. His experience includes SQL Server projects dealing with HP Europe, financial institutions in Canada and data centers in the Dutch Caribbean. He is currently dealing with databases in 24/7 high availability environments . He was an active member and a presenter of the PASS chapter Toronto. Rohan holds a Bachelor of Computer Engineering degree and he is MCDBA SQL Server 2008 and ITIL V3 certified.
Tim Radney
Twitter: - @tradney
LinkedIn: Tim Radney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Roy Ernest
Twitter: - @RumblingDBA
LinkedIn: Roy Ernest
Contact: http://www.sqlservercentral.com/blogs/dba_rumblings/
Roy Ernest (Twitter: @RumblingDBA) currently works as the Manager of the IT-DBA Department for Zarb Corporation. He is the Leader of the Curacao SQL Server User group. Roy is very active in the SQL Server community and volunteers his time for the PASS organization. You can read his blog at http://www.sqlservercentral.com/blogs/dba_rumblings/default.aspx.
Luan Moreno Medeiros Maciel
Twitter: - @luansql
LinkedIn: Luan Moreno Medeiros Maciel
Contact: https://luanmorenodba.wordpress.com/ amp; http://www.sqlshack.com/author/luan-moreno-m-maciel/
Based out of Brazil, Luan Moreno credits his ability to solve problems to thinking critically before acting. He values working with a team because he and his clients can benefit from various perspectives and collaboration, particularly when faced with difficult issues. When Luan Moreno first became interested in technology, he didn’t have a mentor, so he made a commitment to teaching others in the community and sharing his knowledge through blogging, speaking engagements.
Luan Moreno is a addicted Brazilian blogger and speaker. SQL Server MCT, MCSE and MVP living in Brazil. Nowadays he#39;s a Database Consultant at Pythian, company based in Ottawa - Canada.#160;
Daniel Janik
Twitter: - @SQLSME
LinkedIn: Daniel Janik
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.
Ignacio Salom Rangel
Twitter: - @iasalom
LinkedIn: Ignacio Salom Rangel
Contact: http://ignaciosalom.com/
Ignacio Salom is a Senior SQL Server DBA and the CEO of Cenlinea Online Education He has over 15 years of experience in IT and in 2006 he turned his focus to SQL Server. Ignacio holds MCITP Database Administrator certifications for SQL Server 2005 and SQL Server 2008. His online presence includes:
- Writing for Confio Software’s LogicalRead
- His blog
- The SQL Server Central forums
- MSDN forums
- Twitter(@iasalom)
Daniel Janik
Twitter: - @SQLSME
LinkedIn: Daniel Janik
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.
Sponsors
The following is a list of sponsors that helped fund the event: