What do you think are the minimum skills a person should have before they are allowed to manage a database? Does it matter whether or not it’s a production database? Does it matter how much data is there? What kind of data? Is recovery a goal or a symptom? Does it matter how old you are? Or how old the database is? What is the meaning of all this anyway?
Thomas LaRock ( blog | @sqlrockstar ) and I will be talking about what a Minimalist DBA is, what skills we think they need, and how to ensure that they have them on 3 December at Noon EST for the DBA Fundamentals Virtual Chapter of PASS.
Every profession has a core set of responsibilities that are expected of every practitioner. For anyone that has the letters “DBA” in their job description their job function is a black box to anyone on the outside. "What do you do here?" is a common question for most DBAs.
Some DBAs are a part-time data modelers, SAN admins, VM admins. Sometimes they know all about security, or Active Directory, or .NET. It differs from one shop to another. Whether it is day one or one hundred in your career as a DBA you need to make certain you stay focused on your core duties. If you slip up then you will find out why DBA often stands for Default Blame Acceptor.
Attend this webinar to make sure that no matter what your level of efficiency and laziness you are able to focus on the bare essentials (the minimum) necessary to be a Rockstar DBA."
Karen Lopez is a senior project manager and architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a SQL Server MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality. She isn’t a DBA, but loves to talk and debate about the effectiveness of lazy DBAs. She isn’t sure if the minimalist thing is a strength or an excuse.
Thomas LaRock is a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and a Microsoft Certified Trainer with over 15 years’ experience in the IT industry in various roles such as programmer, developer, analyst, and database administrator. He is also the author of “DBA Survivor: Become a Rock Star DBA” (http://dbasurvivor.com) and has participated in the technical review of several other books.
Currently, Thomas is a Technical Evangelist for Confio Software. This role allows for him to work with a variety of customers to help solve questions regarding database performance tuning and virtualization. Thomas also serves on the Board of Directors for PASS as Vice President of Marketing. You can find out more information about him at his blog: http://thomaslarock.com/resume/.
You can probably expect our usual level of snark, debate, levity and great info for this presentation. Bring your ideas and snark, too. I always ensure that the audience is part of the presentation, so expect more the a slew of bullet points and demos. And even though this is hosted by a SQL Server organization, all we will be talking about will be applicable to multiple platforms. That’s how real enterprise database systems are anyway, right?
You’ll need to register, but it’s free. By the way, if you also register on that site, you’ll become a member of that chapter. And that’s free, too.
Join me and three data experts in my Big Challenges in Data Modeling webinar on Thursday 22 Aug 11AM PDT/ 2PM EDT. Since I’m attending the NowSQL Now! conference , our topic this week will be how data architects and modelers should be involved in requirements and modeling efforts on NoSQL, Schemaless, and Unstructured Data projects…or is there a role for them at all?
Some of the topics we hope to cover during the panel:
- What is NoSQL? If it’s Not Only SQL, where does SQL fit?
- What sort of data modeling/data requirements should be completed on a NoSQL project?
- How can we best leverage existing data models?
- Where do schemas matter? Don’t they?
- Do different NoSQL databases lead to different data cultures?
- If the datastore is schemaless, when do data analysis (meaning, quality, security, privacy, financial sensitivity) requirements get consideration?
- How much should an enterprise NoSQL team member understand about the traditional database development process?
- Who wears the “data professional” hat on NoSQL projects? Is there one?
- How do hybrid solutions fit into all this?
Of course we won’t get to all those in the panel, but you can see from the list of candidate questions where we might focus.
Join me and these great NoSQL and SQL experts:
Dipti Borkar, Director of Product Management, Couchbase
- Dipti Borkar is a Director of Product Management at Couchbase where she is responsible for the company¹s flagship product, Couchbase Server, and works with customers and users to understand emerging requirements for low-latency, scalable data stores. Dipti has deep technical experience in the database industry having worked at IBM as a software engineer and Development Manager for the DB2 server team and then at MarkLogic as a Senior Product Manager.
Alex Peake, Data Architect, Intuit
- I am passionate about extracting value from data, and have been for over twenty years. In the early days it was with start-ups, several of them my own. I have also worked with larger companies like Iron Mountain, PayPal and Intuit. I have designed and implemented systems for managing data and analyzing it.
- In the relational world have been OLTP systems, like Oracle and VoltDB, and for Data Warehouse systems, Teradata, Netezza and Vertica. In the non-relational world I have worked with the Hadoop ecosystem, NoSQL databases like Cassandra, HBase and MongoDB, and streaming solutions. In the analytical world, I have built systems for marketing segmentation, and used machine learning methodologies with tools like R and MatLab.
Hamiton Hayes, Sandhill Consultants
- Hamilton Hayes is a Senior Consultant for Sandhill Consultants Ltd. Over time, Ham has led much of the evolution of the CA ERwin product suite and its supporting education courses. He has provided his extensive expertise in information, process and enterprise modeling to numerous major North American corporations and government agencies.
- Ham has authored articles and delivered presentations to industry groups on enterprise modeling and its role in improving performance. The focus of his consulting and teaching has helped enterprises bridge the space between technical modeling and business success. He is also researcher in modeling, using the ERwin products to model non-linear social interactions.
Unlike many webinars, we provide many mechanisms for attendees to participate during the live event. We have attendee-attendee chat, plus a formal Q&A section. We also participate via Twitter using hastag #BCDModling
This webinar is free, but registration is required. See you there!
This month’s webinar (2PM EDT/11AM PDT) focuses on how DBAs and Data Modelers can collaborate better. You know what it’s like: we both love our data and what databases to purr. But what happens when our points of views differ? Is performance more important that some data quality? Should we all be using the same tools? Who should be calling the shots? Who should be “in charge”? What deliverable should we be preparing?
Our webinars are very interactive. We open the chat to everyone and offer a formal Q&A for asking questions and giving feedback to the panelists. You can even join early to chat with us and we tend to stay about after to have “off the record” follow up conversations. So this isn’t a lecture, but an online community event to chat about what we can do as a team to provide data and database solutions to our organizations.
We are sponsored this month by CA Technologies, the makers of CA ERwin®. Thanks, ERwin team!
You’ll need to pre-register, but it’s free. Do it now. It will be fun.
About the Presentation
We invite you to join us in this monthly DATAVERSITY webinar series, “Big Challenges with Data Modeling” hosted by Karen Lopez. Join Karen and two or more expert panelists each month to discuss their experiences in breaking through these specific data modeling challenges. Hear from experts in the field on how and where they came across these challenges and what resolution they found. Join them in the end for the Q&A portion to ask your own questions on the challenge topic of the month.
This Month’s Panelists
- Yanni Robel, Lead DBA, Database Operations Team at Amazon.com
- Yanni (@yannirobel) manages the Database Operations team at Amazon.com in Seattle, WA. She is a very active Senior Database Administrator as well, leveraging more than a dozen years of experience working with Microsoft SQL Server products and technologies.Yanni specializes in bridging communications between the business, the developers, the sysadmins, and the DBAs to help everyone understand what it is that they depend on. As an active member in the SQL community, previous developer, and parent, Yanni knows the importance of knowing what you don’t know and leveraging the collective knowledge of others and the community to learn and grow. Yanni is pleased to give back to peers, coworkers (past & present), and recruiters by sharing knowledge.
- Javed Mati, Sales Director, Myriad Solutions UK Ltd
- [Bio Pending]
- Paul Agnew
- Paul Agnew is an author, consultant and speaker with more than 20 years experience in the data modeling and data integration fields in many different industries. He is the co-author (With Len Silverston) of The Data Model Resource Book Volume 3: Universal Patterns in Data Modeling, which describes universal data modeling patterns. Mr. Agnew, has been a featured speaker at the prestigious DAMA International conference, and has presented papers on many different aspects of data management field.Paul has extensive, hands-on experience working in many different industries, including financial services, insurance and re-insurance, health care, healthcare informatics, sales and marketing and manufacturing. Paul is an expert in solution architecture, data architecture, data quality, master data management, data warehousing, big data and data governance.
Join me and an excellent panel of industry experts in discussing the state of Data Modeling Governance. No, not Data Governance, but Data Modeling Governance. This free webinar is Thursday, 23 May at 2 PM EDT. While the formal part starts at 2 PM, you are free to join us 15 minutes before as we prepare for the event. You can even post your Data Modeling Governance questions then so that we can answer them
We data architects spend a great deal of time advocating for organizations to treat their data as an asset. We champion the efforts to set up stewardship programs and data governance councils. We insist that data conform to enterprise naming and modeling standards. We enforce data policies, measure data quality, report deficiencies and track anomalies. But do we follow our own advice when it comes to managing “our” data – metadata and data models?
In this webinar, we’ll be tackling the questions of:
- Do you have budget (money and time) to govern the data modeling environment?
- How can we get the resources we need to properly govern our data models?
- Who sets permissions and manages them?
- When does data modeling by email work?
- Are data modeling artefacts part of the production systems operations?
- Are there multiple data modeling tools in your environment? For the right reasons?
- Are we loving our data models as much as our data?
- …plus more.
My panellists this week have a great deal of experience in working on a variety of enterprise environments:
- Anne Marie Smith, Ph.D. is an Information Management professional and consultant with broad experience across industries. She has exceptional, demonstrated skills in business requirements gathering and analysis, data governance and stewardship, data architecture, data and process modeling, strategic data management, meta data management, data quality management, master data management, data warehouse planning and design, project management, and information systems methodology development.
- David Loshin is the President of Knowledge Integrity, Inc, (www.knowledge-integrity.com), a consulting company focusing on customized information management solutions including information quality consulting and training, business intelligence, metadata, and data standards management. David is among Knowledge Integrity’s recognized experts in information management.
- Pete Stiglich is a Senior Healthcare Data Architect at Perficient. He has over 25 years IT experience having worked in Enterprise Data Architecture, Data Management, Data Modeling (Conceptual, Logical, Physical, Dimensional, Data Vault, EDW), Data Quality, DW/BI, MDM, Metadata Management, Data Quality, and Database Administration (DBA)
- You! I always consider the audience as the first panellist in a webinar. We have a open, engaging webinar configuration where attendees can chat with each other and ask questions to the panel.
You’ll need to pre-register, but it’s fast and free. Bring your questions, comments, snark and observations. See you Thursday.
Oh, and if you are late reading this and the webinar has already happened: no worries. We record every event and post it to the Dataversity website. You’ll miss all the great chatter in the chat room, though.
Subscribe via E-mail
- My links of the week – December 8, 2013 | R4 on 10 Tips for the Minimalist DBA
- Doing It Right: Performance Monitoring and Troubleshooting - SQL Server - SQL Server - Toad World on 10 Tips for the Minimalist DBA
- Doing It Right: Performance Monitoring and Troubleshooting - SQLRockstar - Thomas LaRock on 10 Tips for the Minimalist DBA
- Robert L Davis on Trolling the #24HoP
- Cindy Gross on Strutting: We all Know When You are Doing It. So Stop.
- December 2013 (1)
- November 2013 (1)
- October 2013 (3)
- September 2013 (3)
- August 2013 (2)
- July 2013 (4)
- June 2013 (5)
- May 2013 (7)
- April 2013 (5)
- March 2013 (4)
- February 2013 (7)
- January 2013 (12)
- December 2012 (2)
- November 2012 (3)
- October 2012 (3)
- September 2012 (13)
- August 2012 (5)
- July 2012 (17)
- June 2012 (2)
- May 2012 (4)
- April 2012 (4)
- March 2012 (8)
- February 2012 (11)
- January 2012 (3)
- December 2011 (10)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (9)
- July 2011 (5)
- June 2011 (5)
- May 2011 (5)
- April 2011 (9)
- March 2011 (4)
- February 2011 (9)
- January 2011 (8)
- December 2010 (15)
- November 2010 (27)
- September 2010 (2)
- August 2010 (1)
- July 2010 (4)