In this article, we will discuss all Microsoft Certifications paths in a way that helps you to drive on the correct road, to meet the requirements of the current job career growth or the job that you plan for.
Read more »Professional development
SQL Interview Questions for the second round
May 22, 2020In this article, we will talk about SQL interview questions and answers that can be asked in the second-round technical stage. These interview questions are based on real-life experiences. Therefore, it can be a very useful source when preparing for the second round of SQL technical interviews.
Read more »SQL Server Senior Database Administrator Interview Questions and Answers
May 5, 2020In this article, we will discuss a number of questions that you may be asked when applying to a senior SQL Server database administrator position.
Read more »SQL Server Junior Database Administrator Scenario-Related Interview Questions and Answers
May 5, 2020In this article, we will discuss a number of questions that you may be asked when applying to a junior SQL Server database administrator (DBA) position.
Read more »Microsoft Azure Administrator scenario-related Interview Questions and Answers
May 4, 2020In this article, we will discuss several scenario-related interview questions that you may be asked when applying to an Azure Administrator position.
Read more »SQL Server Replication Interview Questions & Answers
March 2, 2020In this article, we will discuss a number of interview questions that cover the SQL Server Replication concept, components, types, and troubleshooting scenarios.
Read more »SQL Server Always On Availability Groups Interview Questions & Answers
February 28, 2020In this article, we will discuss a number of interview questions that you could be asked about the SQL Server Always On Availability Groups feature when attending an interview for the SQL Server database administrator role.
SQL Server Transaction Log Interview Questions
October 3, 2019In this article, we will discuss some important SQL Server Transaction Log interview questions that you may be asked during a SQL Server administrator or developer technical job interview.
Read more »SQL Server Auditing Interview Questions
October 3, 2019In this article, we will discuss a number of common and important SQL Server Audit questions that you may be asked during the SQL Server database administrator interview. I advise you to check them out and get ready for the interview.
Read more »SQL Server Execution Plan Interview Questions
September 20, 2019In this article, we will discuss a few very common questions that you may be asked during a SQL Server administrator or developer technical job interview.
Read more »How to markup, annotate content like a boss
December 5, 2018Overview
As a writer and content creator, I often use annotation and drawing markup tools to add value to the content I’m creating. You might not think of it as a big deal, but the human brain processes visuals 60,000 times faster than text. Is it true? Probably not. There’s no scientific evidence to back up this figure. However, it’s a fact that humans process visual data better. Therefore, I always try to deliver helpful, value-added content with a lot of visuals suitable for easy reading and understanding.
SQL interview questions on database backups, restores and recovery – Part I
July 30, 2018So far, we’ve discussed a lot about database backup-and-restore process. The backup database command is an online database copy of the SQL Server database and restore database command gives an option to test the consistency and integrity of the backup file.
As we all know, the backup database command bound with many database options. Indeed, it facilitates the execution of specific backup database command that meets the business requirement.
Read more »Interview questions and answers about data science, data understanding and preparation
July 27, 2018Q1: In the data science terminology, how do you call the data that you analyze?
In data science, you analyze datasets. Datasets consists of cases, which are the entities you analyze. Cases are described by their variables, which represent the attributes of the entities. The first important question you need to answer when you start a data science project is what exactly is your case. Is this a person, a family, an order? Then you collect all of the knowledge about each case you can get and store this information in the variables.
Read more »SQL Interview questions on database backups, restores and recovery – Part IV
July 25, 2018In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database. Also, discuss several T-SQL statements to derive most useful information with reference to data purge, database growth, backup report, restore history and more.
Read more »SQL interview questions on database backups, restores and recovery – Part III
July 25, 2018So far, we’ve discussed a lot about database backup commands. In this article, we’ll discuss more on database restore or database recovery processes. When you initiate a restore process, it undergoes a series of internal stages to restore or recover the data to the specific point of time.
Read more »SQL interview questions on database backups, restores and recovery – Part II
July 25, 2018In this article, we’ll walk through, some of the refined list of SQL Server backup-and-restore, (or recovery) interview Q&A. Also, it includes the high-level overview and links of the “stairway to backup-and-restore series” articles for detailed information. As you read through the lists of Q&A, you’ll learn most of the features and concepts of Backup-and-Restore operations.
Read more »Eating the frog: How to create a daily-deliverable sprint burn down graph in Excel
July 12, 2018In the first article I wrote on how to create a SCRUM-based, sprint burn down in Excel, How to create an advanced sprint burn down chart in Excel, I showed how to easily set up a conventional burn-down with effort points as a percent, to create a pretty nice looking burn down chart, just by entering the IDs of each completed PBI on the date that it was finished.
Read more »How to create an advanced sprint burn down chart in Excel
July 10, 2018SCRUM is a great way to manage all sorts of tasks including sprints, but you don’t have to purchase expensive software packages to burn one. Excel is a great tool for rolling your own sprint burn down graph or you can just take mine. In this article, I’ll walk you through a burn down spreadsheet I created, show you how to modify it and at the end you can download it for yourself and kick the tires.
Read more »Sharpen your ax
July 4, 2018This is a popular story which illustrates the advantages of not just plowing away at your work, but improving your knowledge, planning, skills and preparation first to achieve a better outcome in the end
Once upon a time there were two men who lived in the same forest and decided to have a contest chopping wood. The first man was in good physical shape and very muscular. The second man was in good shape but smaller in statute and wiry. They would chop wood all day and at the end of the day compare to see who had chopped the most wood. The first man laughed to himself that there was no way this wiry little man would beat him and so they began the contest. Every 45 minutes the second smaller man would take a break and seems to just wonder off somewhere. The first man laughed again to himself and said “Yep there’s no way this wiry little man is going to beat me.” This happens several times during the day. At the end of the day the two men compare their piles of chopped wood and unbelievably enough the wiry little man has chopped twice as much wood as the more physically fit man. He says “I don’t understand. First I’m twice your size and twice your strength! On top of that every 45 minutes you rolled off and took a break or a nap or something. You must have cheated!” The smaller man says “I didn’t cheat. It was easy to beat you because every 45 minutes when you thought I was taking a break, I was out back sharpening my ax.” 1
Read more »Comprehensive Performance review template
July 3, 2018I looked around for a good performance review template for a long time but I finally just sat down and wrote my own. It is a 5 pt system with various categories that cover
- hard skills – your skill at your core competency i.e testing
- soft skills (quality, follower ship, communication, proactivity, intangibles)
- Performance – how you are doing, productivity
- Quality
- Trend – getting better, worse or the same
Daily Deliverables – the art of eating the frog
June 29, 2018Each evening sees it close;
Something attempted, something done,
Has earned a night’s repose”
Retention successes and failures – combatting the Peter Principle for managers
June 29, 2018No matter what your position, unless perhaps you work for the post office, typically you are required to do more to earn a promotion, not just do your job long longer. The trouble is that not everyone can or will do more. Some lack the motivation, some the potential and others endurance to continually progress. For whatever reason, even if there are growth slots available, not everyone will move up and instead some will ultimately hit their career ceiling aka plateau. This concept is often described at the Peter Principle
Read more »Rubber Balls vs Glass balls – a metaphor for task prioritization
June 28, 2018When I was in the Army we all got a 2 page hard copy with a visual called “Rubber balls vs glass balls” as an analogy for balancing the many day to day priorities of being an Officer. It was a compelling article that I’ve referred back to many times in life. I’ve spent the last couple years looking for it on the web, but with no luck here is my attempt to recreate it from scratch, by memory.
Read more »Top 25 SQL interview questions and answers about indexes
June 25, 2018Q1: What is the difference between a Heap table and a Clustered table? How can we identify if the table is a heap table?
A Heap table is a table in which, the data rows are not stored in any particular order within each data page. In addition, there is no particular order to control the data page sequence, that is not linked in a linked list. This is due to the fact that the heap table contains no clustered index.
Read more »Contribute, contribute, contribute!
June 20, 2018A good friend of mine and co-speaker at SQLGrillen this year, Paul Broadwith (@Pauby), said this during a practice run of our presentation, not in a Steve Ballmer way thankfully. Although we were talking about open source projects at the time, the concept applies to blogging, organising and speaking at user groups or conferences, everything Community related really.
Read more »