Posts

SQLStarter – Intro to DBA

 

About the Presentation

Session in the SQLStarter beginner track to introduce the database administrator career. Will discuss aspects of what this job entails and what day to day could look like in this career path. We’ll go over important skills and where to find training information.

Session Level: Beginner

Download the Presentation

SQLStarter - Intro to DBA

Presentations (Upcoming & Past)

 

About the Author

Data Platform Consultant

David Maxwell

UpSearch Alum David Maxwell is a database strategist, community evangelist and public speaker. He is passionate about helping community and business leaders get the most out of SQL Server.

Since 2000, David has served to protect, unlock and optimize data's value within such diverse environments as healthcare providers, insurance companies, manufacturers and financial institutions.  David has the unique ability to zero in on a complex challenge quickly, and provide a long-term solution that fits both the business needs and budget.

Since 2012, David has maintained a SQL Server focused blog at https://dmmaxwell.wordpress.com/. He is a frequent presenter at local and regional events for the Professional Association for SQL Server (PASS) and and works with the Columbus, OH based PASS chapter.

In his free time, David is an avid musician who plays several instruments, as well as a lover of puzzle-based games.

Learn more about David Maxwell at https://upsearch.com/david-maxwell/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

So you want to be a Database Administrator

 

About the Presentation

In 2014, CareerBliss.com and Forbes Magazine ranked Database Administrator as the #1 happiest job. But what exactly does a DBA do? How does someone become a DBA? And why are they so darned happy? In this session we’ll explore the different types of DBA, their roles and responsibilities, and the career path for database professionals. Whether you’re just starting your career and trying to find your footing, or you’re a seasoned veteran wondering where to go from here, this session will show you the possibilities.

Session Level: Intermediate

Download the Presentation

So you want to be a Database Administrator (DBA)

Presentations (Upcoming & Past)

 

About the Author

SQL Server Consultant

Colleen Morrow

UpSearch Alum Colleen Morrow is a database strategist, community advocate, author, blogger and public speaker. She is passionate about helping technology leaders use Microsoft's SQL Server to protect, optimize and unlock data's value.

Colleen has been working with relational databases for almost 20 years. Since 2000, Colleen has specialized in SQL Server and Oracle database management solutions. She excels at performance tuning, troubleshooting mission critical SQL Server environments, and training technology professionals and business users of all levels.

Since 2011, Colleen has maintained a SQL Server focused blog at http://colleenmorrow.com. She is an active member of the Ohio North SQL Server User Group, as well as a volunteer for the Professional Association for SQL Server (PASS). Colleen earned a Bachelor of Science in Computer and Information Systems from Cleveland State University.

Learn more about Colleen Morrow at https://upsearch.com/colleen-morrow/.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

 

About the Presentation

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

In today’s world, you’re more likely to have databases both on premises and in the cloud. Managing databases in different environments can make your life more complicated, but with the new PowerShell cmdlets introduced with SQL Server 2014, it actually becomes easier.

In this session, we’ll introduce you to the new cmdlets and show you how to manage your on-prem and Azure databases consistently.

Session Level: Intermediate

This session was presented at PASS Summit 2014.
Manage Both On-Prem and Azure Databases with SQL Server PowerShell

Download the Presentation

Manage Both On-Prem and Azure Databases with SQL Server PowerShell

Presentations (Upcoming & Past)

 

About the Author

Microsoft SQL Server MVP and Practice Leader

Allen White

Allen White is an UpSearch Alum and Microsoft SQL Server MVP.  For over 30 years, Allen has specialized in developing applications that manage the movement of data and maximize data's usefulness. Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. Allen thrives on providing comprehensive solutions to information management problems across a great variety of application environments.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

PowerShell 101 for the SQL Server DBA

 

About the Presentation

PowerShell 101 for the SQL Server DBAThe more you have to manage, the more likely you’ll want to automate your processes. PowerShell scripting language will make you truly effective at managing lots of servers. But it’s more than just a scripting language – it’s an interactive shell that stores data for you and allows you to implement ad-hoc solutions quickly and easily. Within the PowerShell environment you can easily manage both SQL Server instances and the Windows servers themselves, giving you a ‘best of both worlds’ environment that puts you in control. This session will introduce you to SQL Server PowerShell and show you how to use it to manage SQL Server across many instances.

Session Level: Intermediate

Download the Presentation

PowerShell 101 for the SQL Server DBA

Presentations (Upcoming & Past)

 

About the Author

Microsoft SQL Server MVP and Practice Leader

Allen White

Allen White is an UpSearch Alum and Microsoft SQL Server MVP.  For over 30 years, Allen has specialized in developing applications that manage the movement of data and maximize data's usefulness. Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for over 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. Allen thrives on providing comprehensive solutions to information management problems across a great variety of application environments.

About UpSearch

up-social-round

UpSearch is a company of data management and analytics experts who enable digital maturity with Microsoft’s technologies. Its mission is to enable every leader to unlock data’s full potential. UpSearch provides full lifecycle support for SQL Server, SQL Server in Azure (IaaS), Azure SQL DB (PaaS), Azure SQL DW (PaaS), Analytics Platform System (APS), and Power BI.

 

Checklists

One of the first things a pilot is taught is to use checklists. Everything from preflight to tie down after your return is covered in aviation checklists. Did you check the thickness of the brake pads? Did you actually look in the fuel tanks to see how much fuel you have (because guages can malfunction, just like everything else)? When you’re 3500 feet above the ground you can’t just pull over and see what’s wrong. (Once – on my second solo flight – had just taken off when there suddely was a loud flapping noise against the side of the plane. With a high level of anxiety I maneuvered through the pattern, got the plane back on the ground, and found I’d left the strap to my seat belt hanging out the door when I closed it, and it was hitting the side of the plane from the prop wash after I took off!)

As a DBA it’s your responsibility to ensure that everything is running properly, especially in your production environments. When things are running smoothly and you have time to think things through it’s easy to make changes without incident. Things aren’t always running smoothly when changes have to made. Sometimes you’re in the middle of a critical project and someone needs a major change. It’s easy to forget little details – things you’d normally never forget – when these requests are made. It’s moments like this when the checklist is really your friend.

We have an application that manages web sites for our trade shows, and it uses a master database for the application, and a database for each individual web site. Over the (almost) four years since we brought this application in house I’ve created hundreds of databases for the sites. Now, there are items on my checklist besides setting up the databases, because I handle those as well, but I don’t know of a business environment where you can focus on “just” the database issues.

  • Create the Datastore Directory
  • Create the Site Database
  • Configure the Global Database
  • Set up the Java Runtime Connections
  • Configure the Web Site
  • Confirm the Web Site is Working

The checklist doesn’t have to be complex (it can be if you’re passing it on to a junior DBA, but it doesn’t have to be.) It’s usually enough that you have the major steps, and some of the minor ones if they get a bit detailed. The important thing is that you have a reference to make certain you don’t miss anything when you need to get something done.

 

About the Author

Microsoft SQL Server MVP and Practice Leader

Allen White

Allen White is a Microsoft SQL Server MVP and Practice Leader at UpSearch.

For over 30 years, Allen has specialized in developing applications that manage the movement of data and maximize data’s usefulness. Allen excels at communicating highly technical information using language that results in increased client engagement and understanding, regardless of technical competency.

Allen has been working with relational database systems for almost 20 years. He has architected database solutions in application areas like retail point-of-sale (POS), POS audit, loss prevention, logistics, school district information management, purchasing and asset inventory and runtime analytics. Allen thrives on providing comprehensive solutions to information management problems across a great variety of application environments.

Learn more about Allen White at  https://upsearch.com/allen-white.

 

About UpSearch

up-social-round

UpSearch provides as needed Microsoft SQL Server DBA Services across the globe. We specialize in helping leaders protect, unlock and optimize data’s value.