The Accidental DBA (Day 30 of 30): Troubleshooting: Transaction Log Growth
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
As I announced in our Insider newsletter last week, we’ve designed some new Immersion Events to expand the curriculum we offer. We have a new Immersion Event for the
I bet you'd love the answer to be "SQLskills.com"? Well now it can be. Over the last few months some of our clients for whom
A few weeks ago I kicked off a survey about tempdb configuration – see here for the survey. I received results for more than 600
It's all very well hearing about how cool our training classes our from *us*, but what do attendees like you think? I recently did an
Last Tuesday I hosted T-SQL Tuesday #012 (see here for the call for participation) and posed the question "why are DBA skills necessary?" This month
The November 2010 edition of TechNet Magazine is now available on the web and contains my latest feature article. In this article I give my top-10
For about 6 months we'd bee trying to hook up online with SharePoint MVP Hilton Geisenow for an interview but unfortunately the bandwidth to South Africa is
(Look in the Misconceptions blog category for the rest of the month’s posts and check out the 60-page PDF with all the myths and misconceptions
Back in January I offered a promotion as a way of introducing our maintenance/operations auditing services. Now I've completed a bunch of them, with some
The November 2009 edition of TechNet Magazine is up on the web and contains my latest feature article, the second in a 3-part series on
One of the perennial problems facing both experienced and involuntary DBAs is how to tell whether a database is really in the Full recovery model
The 35-page whitepaper on high availability I wrote for the SQL team over the summer has been published on MSDN. It’s a 2-300 level whitepaper
This survey is based on a suggestion from Jonathan Kehayias (blog/Twitter). In this survey I'm asking two questions: When you're designing/implementing a database, do you
A few weeks ago I kicked off a survey asking what kind of disaster recovery guide/run-book/plan (I'll just call it a plan from now on)
In this survey I'd like to find out what kind of disaster recovery guide/run-book/plan you have, if any. When a disaster occurs, do you just
A long time ago, in a blog post far, far away (well before I went offline in July) I kicked off a weekly survey about
In this week's survey I'd like to know how often you run consistency checks on your *most critical* production database, regardless of *how* you run
In last week's survey I asked how you manage the size of your database *data* files – see here for the survey. Here are the
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
In this week's survey I'd like to know how you manage the sizes of your database *data* files (remember we've already done log file size
In last week's survey I asked you what you think is the hardest thing when becoming an involuntary DBA – see here for the survey.
This week's survey is all about being a DBA or involuntary DBA – what do you think is the hardest thing when becoming an involuntary
Chad Miller over on SQLServerCentral has put together a really great collection of scripts that allow you to easily monitor and report on what backups
In last week's survey I asked you two things, as a precursor to a whitepaper I'm writing for Microsoft The first question was what is
This week's survey is inspired by this morning's Kimberly+Paul hot-tub conversation around data-dependent routing vs. network load balancing, which then turned to SLAs. Yes, we
In last week’s survey I asked whether you’re ever tested your disaster recovery plan, and if so, what happened? (See here for the survey). Here
This week's survey is inspired from many stories I saw on the forums and Twitter this week – mostly bad, one good (someone I'm following
Quickie this morning to start the day off. I saw a question on a forum: if I *have* to use a GUID and *must* have
This is a true story, and unfolded over the last few days. It’s deliberately written this way, I’m not trying to be patronizing – just illustrating
Hopefully all of you reading my blog already know to use the WITH ALL_ERRORMSGS option whenever you run DBCC CHECKDB (which is now the default
Last week's survey was two-fold – what's the largest SQL Server database you manage, and how many SQL Server databases are you responsible for managing.
This has come up a few times now, most recently in an email question this morning – subsequent runs of DBCC CHECKDB show varying numbers of
Recently there’s been a spate of people noticing strange behavior from active transactions when DBCC CHECKDB (or any of the other DBCC consistency checking commands
Jason Massie posted an interesting statistic yesterday – Facebook has 1.5 petabytes of image storage, and it grows by 25TB daily – I wonder how
The June edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
Not much to do here in Tokyo while waiting for the Bangkok flight except read and blog, and I've already done enough reading for one
Last week's survey was on how *you* manage the size of your transaction log (see here for the survey). Here are the results as of 4/10/2009
The May 2009 TechNet Magazine is now available online, and it's the annual security issue. In there is an article I wrote highlighting 10 common
Jack Li, one of the Senior Escalation Engineers in Product Support, just posted details of an interesting case over on the CSS blog – his article
Just saw this on a forum – running REPAIR_ALLOW_DATA_LOSS on msdb to cope with corruption. Yes, this will work but it's certainly not safe and
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.