Select Page

Help for the Accidental DBA: Using Twitter as a SQL Server Resource

Eric Russo | | October 17, 2014

Using Twitter as a SQL ResourceHave you found yourself thrust into new responsibilities within your IT department as a manager overseeing database operations?

You may be what’s called an “Accidental DBA.”

As we explained in a prior post, it’s tough when you’re a professional new to this job to get up and running when you’re unsure where to start and what to do. We provided some basics for the Accidental DBA, but what happens when you reach an impasse?

Kirsten Benzel, a database developer at SurveyMonkey who began her career as a self-described accidental DBA, found some of her best advice from reaching out to other SQL users via Twitter. Even with some rudimentary training and a library of SQL books at her disposal, she still encountered challenges when trying to stumble through learning SQL.

She solved the issue by turning to social media. Benzel explains:

I hit up Twitter and asked for tips for brand new SQL learners using the hashtag #sqlhelp and got some fantastic replies … Twitter itself is an oft overlooked, yet priceless resource. The best minds in the industry are on there, posting blogs and articles and answering questions.

Although Benzel concentrated on finding resources for database administrators new to SQL, #sqlhelp is used by database administrators of all experience levels. The questions are not trivial either. Some October 2014 examples:

  • Anyone ever put a database mirroring witness in the cloud?
  • What’s the best way to search the plan cache for a particular table?
  • In SQL 2014 would the buffer pool extension flush on a cluster failover? Like SSD pool in a SAN?

Jorge Segarra (also known SQLChicken)is a member of the Jacksonville SQL Server User Group and SQL blogger, and says the value of Twitter to database professionals cannot be underestimated:

In the past year I’ve come to find that Twitter has become an invaluable tool for me professionally as I can get many quick answers and sometimes even more complicated issues resolved. … Thanks to the relationships I’ve fostered with fellow SQL professionals I got world-class, one-on-one help … and all for free. Simply put I cannot stress enough how much Twitter has enhanced my worklife and helped me to be a better DBA as now I have the power of so many sql resources at my fingertips almost instantly.

Segarra tells a story of a time when he needed help for a vexing situation in which a coworker unfamiliar with SQL deleted an .LDF file from a SQL Server 2000 instance when he deemed the transaction log file had become too big. The individual thought a restart would result in the transaction log file being reconstituted, which was not the case. The corruption issues cascaded and worsened. Paul Randal, a SQL expert, responded to Segarra’s tweet for help immediately and was eventually able to help Segarra resolve the database corruption problem. (The process wasn’t pretty or painless, but the problem was resolved.)

What if this and other conventional means of seeking assistance for pressing SQL questions don’t work?

Contact Datavail for more information on how we might best support you and your organization with custom solutions tailored to your needs.

Image by bloomua/123RF.

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Hyperion Myth #9: SOX Audit Requests Are Time-consuming

With serious financial penalties, SOX audits can be intimidating — but they don’t have to be. Find out how you can use Datavail’s software to automatically prove SOX compliance.

Jonathan Berry | March 13, 2018

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS