T-Sql

Three Keys to SQL Server Performance

Everyone wants good performance from their database systems. Some even expect and need a high performing Ferrari all the time. How is this achieved though? What do you need to understand about SQL Server specifically in order to make your company’s …

Continue reading

Measuring Your DBA Skills

Over the last 9 weeks I took you on a journey of skills and career topics related to being a SQL Server DBA. We looked at the Production DBA. We saw skills and career topics from the beginning to mid-career to Senior DBA. Then we looked at the …

Continue reading

How Do I Measure My DBA Skills Part 9

Production and Development DBA Skills and Things We Didn’t Touch On We’ve covered a lot of ground for Production and Development DBAs in terms of the skills and applicable career topics. We’ve mentioned necessary skills with T-SQL, backup/restore, …

Continue reading

How Do I Measure My DBA Skills Part 7

Lead Development DBA Over the past few weeks I have been writing about DBA skills for various career levels, and for a couple of different DBA types - the Production DBA and the Development DBA. Today, we’re examining the Lead Development DBA. You’ll …

Continue reading

How Do I Measure My DBA Skills Part 6

Development DBA II With the last post, we began talking about the Development DBA and the skills needed at the beginning of this career path. Now it’s time for you to ponder what the next level looks like. Development DBA II – 2 to 4 Years of …

Continue reading

How Do I Measure My DBA Skills Part 5

Development DBA We’ve been on a journey recently in this series as we discuss measuring your DBA skills. Previous posts have been intriguing to you. You like where this is going and yet, your skills are different from what we’ve been discussing in …

Continue reading

How Do I Measure My DBA Skills Part 3

In this series on measuring your DBA skills, we’ve been discussing what skills you should have at each phase of your career. So far we’ve covered the entry level skills and the phase 2 skills a Production DBA needs. In this part of the series you’re …

Continue reading

3 Ways to Restore SQL Server Databases

This is likely the last in a series of three posts about backups and restores. My aim with this series has been to give you an idea of the options available and a basic start on using those options. I’m not trying to go in-depth on the subject of …

Continue reading

How Do You Find Good SQL Server Training Resources?

 Teacher-Mentor-pexels-christina-morillo-1181398 What process can you use to find SQL Server training resources that will be valuable? After all, not everything on the internet can or should be trusted. If you want training on something in this …

Continue reading