The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Jun 05 2018 11:00 Central Daylight Time


Not So Secret: Get To Know SQL Server Agent - Jes Borland

RSVP: None

Not So Secret: Get To Know SQL Server Agent - Jes Borland

Secret agents have it all: fun code names, cool gadgets, and fast cars. SQL Server Agent has operators, jobs, and alerts. These features will turn your database server into a well-tuned machine that can warn you of errors, alert you to approaching problems, and run tasks on a schedule. Learn how to increase your automation capabilities and take your notifications to a new level!


Jes Borland is a SQL Server Premier Field Engineer at Microsoft. She holds an AAS - Programmer/Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is a user group founder, a blogger, and a frequent speaker. In her free time, she runs, cycles, and cooks.

Meeting Detail

Tue, Jun 12 2018 12:30 (UTC+10:00) Brisbane


Tips and Tricks for Using SQL Server Management Studio Effectively

RSVP: None

Tips and Tricks for Using SQL Server Management Studio Effectively

Most SQL Server developers and DBAs work with SQL Server Management Studio (SSMS) all the time. But SSMS is a very capable tool and most users only know how to use a fraction of its features. Join Greg to see his favourite tips and tricks for working with SSMS.


Greg is well known in the SQL Server community as a mentor, trainer, author, and community leader. He is a certified master for SQL Server, was an instructor in that program, and holds a PhD in Computer Science. Microsoft regularly call on Greg to develop data-related content, and to train their own staff. He regularly speaks at tier-one conferences internationally. Greg is best known for his SQL Down Under podcast, SDU Tools, and his eBooks and whitepapers. He heads up a boutique consultancy called SQL Down Under in Melbourne Australia. Greg has been awarded as an MVP since 2001.

Meeting Detail

Tue, Jun 19 2018 11:00 Central Daylight Time


CHOOSING THE RIGHT AZURE SQL SERVICE FOR YOU

RSVP: None

CHOOSING THE RIGHT AZURE SQL SERVICE FOR YOU

As part of their Azure offering, Microsoft has constantly and aggressively released new features and services for SQL databases. While having more options is usually a good thing, it can also be pretty confusing. We have Azure SQL Db both single model and elastic pool model, Azure SQL Managed Instance and finally Azure SQL Data Warehouse. Sometimes the use case for each service will be obvious, other times they might overlap depending on your scenario. In this session we will go over the ideal use cases for each one of these services, decision factors to choose one over the other and go over demos of behavior differences between the offerings.


Warner is a SQL Server MCM, Data Platform MVP and Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, building and managing data solutions in many industry verticals while leading a highly talented team of Data Platform consultants.

Meeting Detail

Tue, Aug 21 2018 11:00 Central Daylight Time


BEGINNING ADMIN: THE CARE AND FEEDING OF SQL SERVER

RSVP: None

BEGINNING ADMIN: THE CARE AND FEEDING OF SQL SERVER

Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected. In this class, we’ll cover the basics of the big five administrator tasks: • Backups – You must set up regular backups, to keep copies of your databases…just in case something breaks, or someone makes a bad, bad mistake. • Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined. • Index maintenance – Databases need regular upkeep so they’ll continue to run well. • Disk management – It’s actually your job to find out about full disks before they happen. After all, databases grow! • Alerting – Alerts tell you what’s wrong, so you don’t have to go looking for problems. I’ll also provide good references for the other two big basics of admin: security, and performance. Being a database administrator is a big job, but we can cover the extremely important parts in just one session!


Jennifer McCown is an independent consultant, Microsoft SQL Server MVP awardee, developer, and DBA. She's senior editor at MidnightDBA.com, where she creates training videos, the "DBAs at Midnight" webshow, blogs, reviews, and podcasts. Jennifer is a member, volunteer, and speaker in NTSSUG, PASS, and the PASS Women in Technology Virtual Chapter.

Meeting Detail

Tue, Sep 11 2018 12:30 (UTC+10:00) Brisbane


Data Types Do Matter

RSVP: None

Data Types Do Matter

They're just numbers, right? A date's a date. It's just string data, who cares? I can't tell you how many times I've heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.


Angela is a DBA/BI Developer, living in High Point, NC and loves what she does. She's worked with all versions of SQL Server & worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She earned her MSCE: Business Intelligence in 2015. Awarded Microsoft MVP - Data Platform in 2018. She volunteers with PASS in various capacities, ranging from Program Committee to cleanup at local SQL Saturday events. She is also the chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in the pool, she's an avid US Masters swimmer, Coach and Instructor.

Meeting Detail

Tue, Sep 18 2018 11:00 Central Daylight Time


Linux Fundamentals for SQL Server DBAs

RSVP: None

Linux Fundamentals for SQL Server DBAs

Most of the Fortune 1000 companies leverage Linux for their 7/24 mission-critical enterprise server platform and Enterprise Linux has become the standard de facto for reliability and scalability. Today, more and more companies are considering Linux as their new operating system (OS) for SQL Server; and in today's economy to be an effective database administrator, DBAs and Architects must possess extensive OS and database expertise. In this session, learn how to install and configure SQL Server on Red Hat 7 Enterprise Linux and SUSE Enterprise Server (SLES v12) on bare metal servers and in virtualized infrastructures. We will discuss the top 10 Linux commands that every SQL Server DBA needs to know as you transition from Microsoft to the world of Red Hat and SUSE; with a closer look at the different file system types that are available and which one you should choose. Leveraging real-life experiences and techniques as a certified Linux veteran for over 16 years, I will also share my top tips that you need to know to configure a Linux environment worthy to run SQL Server: 1. Install required RPMs to install SQL Server * Manage and interrogate RPMs * Review RPM dependencies * Setup a local YUM repository 2. Set appropriate kernel and network parameters, shell limits, and file limits for SQL Server 3. Configure transparent hugepages 4. Determine and implement the right I/O Scheduler 5. Configure NTP for the server 6. Bond network interface * Enable jumbo frames 7. Configuring NFS 8. Setup correct partition alignment 9. Centralize System Logging 10. Simplify DNS 11. Setup up ssh equivalence between Linux servers 12. Configure swap setting


Charles Kim is an Oracle ACE Director, VMware vExpert, Oracle Certified DBA, Certified Exadata Implementation Specialist, Certified SharePlex Administrator, and a Certified RAC Expert. Charles specializes in RAC, Exadata, Cloud, and Virtualization and author of 10 books:

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids