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

Event Display
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:

Meeting Detail

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


Let’s talk about Big Data using SQL Datawarehouse

RSVP: None

Let’s talk about Big Data using SQL Datawarehouse

Azure SQL Data Warehouse is a massively parallel processing (MPP) cloud-based, scale-out, relational database capable of processing massive volumes of data. SQL Data Warehouse: Combines the SQL Server relational database with Azure cloud scale-out capabilities. Decouples storage from compute. Enables increasing, decreasing, pausing, or resuming compute. Integrates across the Azure platform. Utilizes SQL Server Transact-SQL (T-SQL) and tools. In this session we will discuss about this awesome feature from Microsoft Azure and how we can use it to help on our day to day.


I'm a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I'm a speaker at various technology events such as SQL Saturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I'm the Chapter Leader of SQL Maniacs PASS chapter.

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