SQL Saturday Austin is coming to Austin Texas. That’s right, you heard it here first! Free SQL Server training in Austin, TX!
SQL Saturday Austin is Feb 24th and 25
We hope you had a great holiday season. With the new year everyone made goals and resolutions. Are you looking to take your IT career to the next level? If so, we got you covered! The Austin SQL User Group is coming together to see if Austin SQL Server professionals are interested attending in-person training.
SQL Saturday Austin – Why Should you go?
This is a great opportunity to network with your peers in the data community. Since 2020 networking opportunities have been rare and hard to find in-person.
Free SQL Server Training from some of the best trainers in the US. There will be sessions about SQL Server, Azure, and Analytics. If you like to make data fast, secure, available, visible there will be sessions for you!
Learn SQL Server 2022 in an all-day session with Bob Ward. You can travel to conferences across the world and pay hundreds of dollars or come to Austin for the same all-day experience for $50.
SQL Saturday Austin Costs?
How much does SQL Saturday Austin cost to attend?
Great question. Friday is an all-day training event on SQL Server 2022 with Bob Ward and costs only $50 to attend.
Saturday will have multiple 1-hour sessions going concurrently from several Microsoft MVP’s, MCT’s, and national speakers and is 100% Free to Attend. You must sign up as space is limited. Currently, there are only 40 seats available.
The following are five tips for working remotely that I learned over the years from working remotely with large companies like DELL, RDX and now even as a leader of a consulting company that focuses on making our customer’s data fast, secure and highly available.
Manage Your Schedule
Manage your schedule don’t let it manage you! Technically not a remote working tip but I noticed this was very important for me when I transitioned from working in an office to working from home. I love my Full Focus Planner it is a tool that helps me get the most out of my day, week, quarter and year!
In short, I changed from focusing on tasks to focusing on my schedule. My tasks are now like blocks of legos and my schedule is the board for my legos. This visually allowed me to understand two things. One, what am I committed too and how much time do I have to accomplish what’s important. Second, what is my three most important tasks that needed my focus today and how does my current schedule allow me to focus on them. Maybe it doesn’t and I need to make some changes. Weekly I get to pause and see how I am heading on my quarterly and yearly goals and also evaluate if they still make sense.
Exercise throughout the day.
The most important thing you can do now is to take care of your health. I lost over 70 pounds in a year by simply altering my eating habits and setting my Fitbit to alarm at the fifty-minute mark of the hour so I could walk for 10 minutes. It helped me quickly get my 10k steps. If I had a meeting that didn’t require me to use my computer I would walk during the meeting.
Bonus: wait for the fifty-five-minute mark of the hour and walk for ten minutes. You will get your Fitbit step credits for both hours.
Communicate More Not Less
In my first year working remotely as an employee, I learned that I could actually communicate better remotely than when I was in the office. To be successful in any role communication is critical. Instead of having a group around me all having different needs I was able to utilize technology like messaging, video conference, screen sharing (Microsoft is giving FREE six months for Teams to do all of these) to not only get tasks done faster but also train more people while I was working. That said, it all started with promptly returning messages, emails, calls, and voice mails. Even if the response was to say, “this request is in my queue. We will get you an update tomorrow.”
Work like you never left the office
Good work habits working in the office can transition easily to working remotely. Keep things as simple as possible. Did you maintain a typical daily schedule for starting and ending work? If so keep those hours. Regardless communicate with everyone to know how and when its best to communicate with you. Take some breaks just like you would in the office. Just make them more productive and valuable to your day to day needs.
You Are Not Alone
Working remotely doesn’t mean you are on an island all by yourself. One of the best things I think you can do during the transition is to ask your colleges or managers for feedback on how the situation is working out. Do they see any changes in the value you are providing in your role?
Hopefully, these tips for working remotely are helpful for anyone who is making the transition to working remotely. Let me know your thoughts about these tips or questions you might have in the comments below.
https://procuresql.com/wp-content/uploads/2020/03/rOe5KnPWRomLNFMd5Vidag-scaled-1.jpg25601920JohnSterrett/wp-content/uploads/2024/05/Data-Architecture-as-a-Service-with-ProcureSQL.pngJohnSterrett2020-03-25 16:47:432020-03-25 16:47:43Five Tips for Working Remotely
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars! We are very proud of our team and their efforts to share knowledge and experiences. Be sure to say hello and ask questions when you see them!
GroupBy September 7, 2018
We are proud to announce that Martin Perez, close friend of Procure SQL, will be joining John Sterrett in presenting for GroupBy.Org! GroupBy is FREE online SQL Server training by the community, for the community! This month’s training is scheduled for September 7, 2018 beginning at 8:00 AM Eastern, with the last session starting at 2:15 PM!
Martin will be presenting “T-SQL Tools: Simplicity for Synchronizing Changes” at 11:45 AM Eastern. Any DBA or developer that has ever faced the problem of moving data changes across databases will surely benefit from this session. One of the most common problems a DBA or database developer may face is finding an syncing data changes efficiently between multiple systems. He will explore different methods focusing on effective use of TSQL, and how these methods can be mixed and matched in your ETL workflows:
Brute Force
Log Shipping/Read Only Standby
Rowversion datatype
Change Tracking
Change Data Capture
Temporal Tables
Martin hopes to assist the DBA or Developer free up time and energy by understanding all the available options. Come find out why brute force is not the only path forward!
John Sterrett (1:00 PM Est)
Directly following Martin, John Sterrett will be presenting “Make Your Own SQL Server Queries Go Faster” at 1:00 PM Eastern. Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? It is how John stumbled into his career in performance tuning. In this session, you will learn some T-SQL performance tuning tips that can be used in the office immediately. You will learn how to identify top offender queries and be able to benchmark queries. Finally, he will cover some coding patterns that are developer friendly (but are not SQL Server database engine friendly) and show you how to rewrite them so they can run faster.
SQL Saturday #774 – Denver, CO September 15, 2018
If you are in the Denver, Colorado area, be sure to register for SQL Saturday #774! The free training event will be held on Saturday, September 15, 2018 at the University of Denver in Sturm Hall. Registration is free!
Two of our team members will be presenting! Both John Sterrett and Angela Tidwell will be presenting at 9:00 AM.
John Sterrett
John will be presenting “Automate the Pain Away with Adaptive Query Processing and Automatic Tuning“ In this Intermediate level session, John will explore how tuning SQL Server workloads is changing. In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events. In SQL Server 2012 Columnstore indexes were introduced; In SQL 2014 the cardinality estimator got a huge overhaul. With SQL Server 2016 we were given query store to allow us to get more insight into our performance pains and execution plan changes. SQL Server 2017 gave us Automatic Tuning and Adaptive Query Processing to help automate performance improvements. In this session, he will harness ways to improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.
Angela Tidwell
Angela will be presenting “Become the Most Valuable Player: Soft Skills for the Hard Market“ This session is for beginners and seasoned pros alike. Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success. Often times we focus on showing how smart we are instead of showing what a good team member we can be. In this session, Angela will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills? She will explore innovative and fun ways in which to do just that! Get ready, Angela likes to wake you up and make you think: she likes to have fun in this session!
SQL Saturday #802 – San Diego, CA September 22, 2018
Planning to be in San Diego on September 22, 2018? If so, you can catch Jay Falck speaking at SQL Saturday #802! SQL Saturday San Diego will be held at UCSD Extension – University City Center and Registration is free!
Jay Falck
Jay will be presenting “Introduction to Linux for SQL Server“ SQL Server is now available on Linux but you only know Windows, now what? In this beginner level course, Jay will introduce the Linux version of Windows commands used on a daily basis for administering SQL Server. He will explore updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. Also he will dive into default file locations for SQL Server and what can be moved and how to accomplish that.
SQL Saturday #770 – Pittsburgh, PA September 29, 2018
Pittsburgh Technical College will be hosting SQL Saturday #770 on September 29, 2018. As always, registration for SQL Saturday is free!
John Sterrett
John will be presenting Automate the Pain Away with Adaptive Query Processing and Automatic Tuning at 10:00 AM Eastern. The way you tune your SQL Server workloads are changing. In the past, you would rely on dynamic management views, execution plan cache, and server-side traces or extend events. In his intermediate level session, John will explore the ways to improve performance into the new so you can automate the pain away and spend more time identifying and tuning pain points that cannot be automated.
We are back this year! Not only are we sponsoring SQL Saturday Houston, we are also speaking! All three of us are presenting! Go here to see the full schedule.
What is SQL Saturday?
SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence, and Analytics. SQL Saturday Houston will be held on June 23, 2018 at San Jacinto College – South Campus, 13735 Beamer Road, Houston, Texas 77089. Check-in and breakfast starts at 7:30am. The first sessions begin at 8:30 am. There are sessions for beginners, intermediate, and advanced levels. Topics covered at this SQL Saturday are:
Powershell
Application & Database Development
BI Platform Architecture, Development & Administration
Cloud Application Development & Deployment
Enterprise Database Administration & Deployment
Professional Development
Strategy & Architecture
Remember, this is a FREE event, but only a few spots remain! Don’t wait, click here to register!
Where will we be?
We will each be at the Procure SQL booth with smiling faces, fun giveaways, and answers to your SQL Server questions! Please stop by and say hello. If not at the booth, you can find us attending a session or giving one of our own!
Angela will start out the day at 9:45 am in room 117. She will be presenting her professional development session “Becoming the MVP: Soft Skills for the Hard Market.” In this interactive, round-table discussion, Angela explores how soft skills are important at all levels of a person’s career. The importance of soft skills in the job market, specific skills, and how to hone them will be top priority. She has been known to give away prizes, so make sure to say hello!
Jay comes in next at 11:00 am in room 149. Jay’s presentation is “Linux for SQL Server” and is a high-level overview of the differences and similarities between Linux and Windows for those who haven’t been exposed or may need a refresher. Don’t be mistaken, even though this session is a high-level overview, it is fantastic for beginners! Jay will introduce the Linux version of Windows commands used on a daily basis for administering SQL Server. Next, he will explore updating Linux, updating SQL Server, moving files between Windows and Linux, and backing up and restoring databases from one system to another. He will round out the session by taking a look at default file locations for SQL Server and what can be moved and how to accomplish that.
John is waking up the afternoon crowd at 1:30 in room 113. He is presenting “Automate the Pain Away with Query Store and Automatic Tuning” which is an intermediate level presentation which explains how execution plans get invalidated and why data skew could be the root cause of seeing different execution plans for the same query. He will further explore options for forcing a query to use a particular execution plan. Finally, he will discuss how this complex problem can be identified and resolved simply using new features in SQL Server 2016 and SQL Server 2017 called Query Store and Automatic Tuning. You won’t want to miss out on that!
What happens after the sessions are done?
Stick around after the last sessions because at 5:00 we all gather together for final remarks and sponsor raffles! We will be giving away a new Super Nintendo Entertainment System Classic Edition! To enter, just drop your raffle ticket in the bucket at our booth.
But wait, there’s more!
The fun doesn’t stop here. We leave from the event to an after party which is being held at Main Event, 1125 Magnolia Ave., Webster, Texas 77598. Party starts at 6! The after parties are a great way to unwind, network, and chat up the speakers and new SQL friends you made during the sessions!
I had the distinct honor of helping John Sterrett (t/b) and Dolph Santorine (t) organize and run SQL Saturday #717 in Wheeling, West Virginia on April 28, 2018. It was a chance meeting at the event that drove home to me why we invest so much of our personal time and effort into organizing/running/presenting at SQL Saturdays. The short answer as to why we do it is: We do all of this to promote free education to all who choose to seek it. That’s right…. FREE. Education is the best gift that can be bestowed upon and received by anyone. I met Kyle, this was his first SQL Saturday and his tweet sums it all up:
“All you’ve done since you got back from #SQLSaturday is talk about all the classes you were at. Don’t you wanna talk about something else?” #whoops
Each SQL Saturday is organized by individuals or teams of volunteers. We do not get paid for our time. The speakers do not get paid for their time. Speakers are sometimes compensated by their employers when they present at SQL Saturdays, but most of the time these speakers pay the travel and lodging expenses out of their own pockets! The events are funded by sponsors. Thus we are able to give away free education from active industry professionals!
Sponsorship is key.
Like I mentioned, the events are funded solely by sponsorship. The cool thing about sponsoring a SQL Saturday is that not only are you expanding your marketing campaign for a minimal amount of money, you too are giving back to a noble cause. Marian Wright Edelman wrote, “Education is for improving the lives of others and for leaving your community and the world better than you found it.” Being a sponsor allows you the awesome privilege of helping make a difference in someone’s life.
Why we do what we do.
During a chance meeting at SQL Saturday Wheeling, I met a USMC Veteran who is trying to find his way in the tech field. He was referred to the event by a college professor. Much to his surprise, not only did he walk away from the event armed with tons of information and a new-found excitement for learning SQL, he walked away with a lot of new SQL friends and mentors. He was introduced to fellow Ex-Marine and Veteran, Jim Donahoe (t/b), who then put him in contact with others in the industry who can directly help make an impact on his career! That is at the core of who we are as a community. We left as we rise.
In the SQL community, we pride ourselves in giving back and helping others. On twitter we even have an open hashtag (#SQLHelp) where you can ask questions and get responses from experts in the SQL community. If you participate, you will find a friend and mentor who will help provide information, keep your spirits up, and help you find your way through the weeds. I personally have been blessed through the community, and my mission is to help bless others.
Thoughts on being an organizer.
Helping to organize and run a SQL Saturday is no small task. There are many moving parts, many small details that can be overlooked or forgotten. I was so very thankful to have friends who are also organizers who helped me along the way. I certainly learned a lot about event planning! More-so, I learned a lot about the value of kindness. They provided guidance and tips, and I too will do the same for others who want the help. Standing there Saturday morning before the doors opened I thought to myself “Here we are. All these months and we are finally here.” And honestly, I was afraid. What if no one showed up? What if the equipment failed? What if I had forgotten something? What if lunch doesn’t show?
And you know what happened? Attendees arrived, speakers arrived, everything worked, lunch arrived early, we had plenty of coffee, and everyone had a great time! It was not a huge event. In fact, it was a very small event. Something I noticed from being at both large and small events is that the quality of education is the same. It is the same because the presenters are all there for the same thing I am….to share their unique vision and experience in hopes that someone in the audience will gain new perspective and it will grow their career.
Final thoughts on volunteering.
I personally feel a sense of pride and accomplishment when I can help someone else with no expectation of reward. But there is a reward, there is always a reward! My reward was smiles from speakers and attendees, but mostly, knowing that we all touched the lives of all those who attended.
For more information on how to attend or volunteer for a SQL Saturday in your location, please visit the SQL Saturday website!
The best way to learn is directly from industry professionals! We are thrilled to be helping the SQLSaturday Wheeling organizers put together a great SQLSaturday, April 28, 2018. The schedule is packed full of knowledgeable SQL professionals waiting to share their unique experiences and knowledge with you!
What is SQLSaturday?
SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. Admittance to this event is free, and most costs are covered by donations and sponsorships. This event will be held on Apr 28 2018 at West Virginia Northern Community College, 1704 Market Street, Wheeling, West Virginia, 26003, United States. You can register here: SQLSatWheeling
* To register for a SQLSaturday, you must first become a PASS member. A PASS account is free and makes it convenient to manage your SQLSaturday user profile, update preferences, and keep track of your SQLSaturday registrations.
What topics will be discussed?
SQLSaturdays offer a wide variety of sessions from beginner to advanced. There truly is something for every data professional at every level of his or her career.
The topics covered are:
Analytics and Visualization
Application and Database Development
BI Information (Delivery, Architecture, Development, and Administration)
Cloud Development and Implementation
Enterprise Database Administration and Deployment
Professional Development
The full schedule for SQLSaturday Wheeling can be found here.
What else does a SQLSaturday offer?
Education is a very important element in growing your career. Another often over-looked important element to growing a successful career is networking! SQLSaturdays provide an excellent opportunity to meet new people, reconnect with old, and have a great time networking. There will be a networking event Saturday after the event, so you will have a chance to unwind, grab a bite to eat, and chat with your newfound SQL friends!
In my last post (A Beginner’s Guide to SQL Server Backups) we discussed the basics of SQL Server Backups. As Backups are the foundation for Recovery, the next logical discussion should be Recovery Models. For reference, I have included this Sample Backup Plan from the earlier post:
Sample Backup Plan
There are Three SQL Server Recovery Models
Simple Recovery Model
This is the most basic of the Recovery models. It gives you the ability to quickly recover your entire database in the event of a failure; (or if you have the need to restore your database to another server) however, this only recovers data to the end of the last backup.
Thankfully, Differential Backups can be utilized with this recovery model. NOTE:Any changes made after the last Full or Differential Backup will be lost. Transaction Log Backups cannot be used in Simple Recovery Model. There is no Point-In-Time recovery in this model (recovering to a specific transaction or point in time). Looking at the sample backup plan above… if you have an issue occur Saturday afternoon, you will lose any changes in data since your last Differential Backup that ran Friday night. If you do not opt for Differential Backups and only perform Full Backups once a week, your changes and data will be lost for the full week. (GASP!)
Why would you ever consider using such a basic, Simple Recovery Model? Actually, there are a few really good (and perfectly safe) reasons why you choose to use Simple Recovery Model:
Your data is not critical and can easily be recreated
The database is only used for test or development
Data is static and does not change
Losing any or all transactions since the last backup is not a problem
Full Recovery Model
This is the most inclusive of the Recovery models; you can recover (depending on your valid backups) data up to the last transaction that was run before the failure. Log backups are a must for this recovery model, including Tail Log Backups (which will be discussed at length in a later post). Data can be restored to a specific point in time (once again, depending on your backup plan)!
Let’s explore that for a moment using the sample backup plan above. Say you take Full Backups on Sunday night, Differential Backups every week night, and Transaction Log Backups every half hour. If you have a failure and must restore data, by using all the backups to the specific time you need to restore, you can recover data at any moment in time! Using this recovery model, you have a potential of minimal to no data loss (once again…depending on your backup plan and whether your backups are restorable). You want to be the DBA who is able to restore quickly and recover data to the very last moment before the failure or crash occurred. YES, we all want to be THAT person!
Bulk Logged Recovery Model
Once again, this Recovery model requires log backups in order to prevent the log file from continually growing. This is a special purpose recovery model that is not widely used, and Microsoft states that it should only be used “intermittently to improve the performance of certain large-scale bulk operations, such as bulk imports of large amounts of data.” It allows high performance bulk-copy operations and is only available when in Full Recovery. Keep in mind that with the Bulk Logged model you can recover to the end of any backup; however, if a bulk transaction has occurred during the last log backup, those transactions will have to be redone. From the bulk operation on, you can no longer utilize point in time restore.
OOOOOOOOOO, I dropped the ENTIRE database!
While studying Backups and Recovery, I have been working in SQL Server 2016 AdventureWorks Database (Download Here). To see if I REALLY understood the process of Backup and Recovery, I made a Copy Only Backup of my original database, made some changes to my database, took Differential Backups, made another Full Backup, made more changes, and made more backups….and then dropped EVERYTHING. POOF….gone. While I did do this intentionally, my heart was racing. Sparkly spots darted in and out of my vision, and my heart pounded in my ears. Would I be able to get it back? Would I be able to restore it? WHAT HAVE I DONE??????
I Dropped the DB! Photo Credit @Lance_LT
How do I know that my backups were good?
I firmly believe you learn more from one of your failures than you do from one hundred of your successes. TEST TEST TEST TEST those backups! I am afforded some extra wiggle room while I am working on my virtual machine and not actually working on a client’s production database.
So, I did it, I dropped that DB like a hot rock. I attempted to restore my database in Simple Recovery Model. My Differentials would not restore. Somewhere along the way in the backup or restore process, I messed up. (I will give you a hint at my mistake, I did not restore the Full Backup with NORECOVERY before I tried to restore the Differential Backup with RECOVERY – we will go into Recovery processes in a later post).
Knowing that I had made a Copy Only Backup before I started monkeying around with the database, I set out to restore faith in myself. And boom, I restored the Copy Only Backup! The day was saved! Well, mostly. I lost some data changes, but still had the original database, so that was good-ish.
Lessons Learned
At a later date I repeated the steps above and was able to fully recover a database that was previously in Simple Recovery Model complete to the last Differential Backup (noting my mistake and learning from it). I additionally created another database to test the Full Recovery Model with Full Database Backup, Differential, Transaction Log Backups, also utilizing Tail of the Log backup to get to the very last transaction that was run after the last backup and before my data files AND database were deleted. (This is pretty in-depth and is covered in Recovery Using Tail Log Backup.)
As was discussed in a previous blog, (The Most Important Role of a SQL Server DBA) Backups and Recovery are the cornerstone of all successful SQL Server DBA careers. Exactly how much attention is paid to backups until something drastic happens? NOT AS MUCH AS SHOULD BE!
What is a SQL Server Backup?
A backup is the process of putting data into backup devices that the system creates and maintains. A backup device can be a disk, file, a tape, or even the cloud. Easy enough!
Backups are your Keys to Success
There are four different methods of backup in SQL Server:
Full Backup – A Full Backup is a copy of the entire database as it exists at the time the backup was completed. It is all-encompassing; every detail of your database (data, stored procedures, tables, functions, views, indexes, and so forth) will be backed up. This is why the Full Backup is the foundation of every restore sequence. These Full backups can be quite large and put a strain on your storage capacity. Despite the name, a full backup will only backup the data files; the transaction log must be backed up separately. To ensure you can recover to the point of failure quickly, you will want to also utilize Differential and Transaction Log Backups (we will cover these next). Without a Full Backup, your Differential and Transaction Log Backups are useless as you cannot restore a database without a Full Backup!
Differential Backup – Differential Backups capture only changed data from the last Full Backup. Simple terms: this will backup only the changes since the last Full backup, not backup the entire database. In the event of an outage, the Differential Backups can greatly reduce the time to recover. Using both Differential Backups and Full Backups will dramatically reduce required storage space, as the Full Backups can be very large and the Differentials are remarkably smaller.
How does a Differential Backup know what data has changed?When data is changed on a page, it sets a flag. This flag indicates which extent (collection of 8 database pages) the Differential Backup will need to backup. If your Differential Backups are set to run daily, each day’s data changes are recorded and the flag will not be cleared until a Full Backup has been executed. Say on Monday you have 3 flags set, and Thursday you have 4 more set, your differential backup on Thursday night will contain data changes represented by all 7 flags, so the flags from the Monday Differential are not cleared by the subsequent Differential Backups. The flags would only be cleared by a Full Backup.
Transaction Log Backup – A Transaction Log is a physical file that stores a record of all the transactions that have occurred on a specific database; much like a recorder, maintaining a record of all the modifications. The Transaction Log Backup will capture the information and then releases the space in the log file so it is able to be used again. In doing this, the Transaction Log Backup truncates the information in the Transaction Log, but the data is not deleted, it is stored in the backup! Without Transaction Log Backups, the Transaction Logs will run and grow nonstop, chewing through valuable storage space.
Not only does backing up and truncating the Transaction Log manage the filesize, it also decreases the potential for catastrophic data loss. Having all the Transaction Log Backups since your last Full Backup will allow you to perform point in time restores. Transaction Log Backups are ideally set up to execute every few minutes to every hour, depending on your company’s threshold for data loss.
Copy Only Backup – A Copy Only Backup doesn’t change the Differential. It can be a full backup in that it is a record of the database as it exists when the backup is taken; however, it does not reset flags. It is ideal for doing a full backup in the middle of the week without disrupting any other backups. A Copy Only Backup can be used in a Dev space for troubleshooting, or preparing to move to a new environment.
Here is an example of a solid weekly backup plan which uses Full, Differential, and Transaction Log Backups:
Sample Backup Plan
Okay, great…backed up, now what?
Okay, so now you know what SQL Server backups are, a description of each backup type, an idea of how and what they back up, and have an idea of a good plan of action to create a solid backup plan. So, why are backups so important? Do you know how easy it is to accidentally update or delete data? It is just one T-SQL statement away with the wrong filter, or no filter at all. Having good up to date backups and being able to restore them is the difference between looking like a hero and being forced to find a new job. Backups are your foundation for Recovery.
Please come back, this is the 2nd in a series of blog posts regarding SQL Server Backups and Recovery. See you next time when we begin to discuss SQL Server Recovery Models. Thank you for reading!
Have you wanted to build an availability group but didn’t know where to start?
If so, we have discounted SQL Server Availability Group training for you!
Nashville, TN learn how to implement and monitor Always On Availability Group Solutions!
Join us for pre-conference training brought to us by SQL Saturday Nashville! John Sterrett will be presenting a half day precon in Mufreesboro, TN on Thursday, January 11, 2018, from 1:00 pm to 4:30 pm!
SQL Server Availability Group Training in Nashville, TN
In this half-day session, you will learn how to build your first availability group while also learning how availability groups work with other components like active directory, storage, and DNS. You will walk away with a checklist to help your future deployments while also learning how to implement, monitor, troubleshoot and use availability groups.
In this session we will cover:
Understanding the difference between Availability Groups and Failover Cluster Instances
Configure Windows Failover Cluster Service (WFCS)
Understanding Quorum in WFCS
Pre-staging Active Directory Objects
Learn how Availability Groups use DNS
Build Availability Groups
Implementing Planned Downtime Failovers
Troubleshoot Common Availability Group Problems
Proactive monitoring Availability Groups
Backups for your Availability Groups Databases
Managing Connectivity
Handling SQL Agent Jobs
Making SQL Server Reporting Services Highly Available Utilizing Availability Groups
Come for the SQL Server Availability Group Pre-con and stay for the full day of free SQL training on Saturday!
SQLSaturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence, and Analytics. Join us on Jan 13, 2018, at Middle Tennessee State University (MTSU), 1301 East Main Street, Murfreesboro, Nashville, Tennessee, 37132.
https://procuresql.com/wp-content/uploads/2018/09/Procure-SQL-Building-Your-First-Always-On-Availability-Group-1.jpg5691096JohnSterrett/wp-content/uploads/2024/05/Data-Architecture-as-a-Service-with-ProcureSQL.pngJohnSterrett2018-01-03 22:21:582018-01-03 22:21:58Building Your First Always On Availability Group