There are many different DBA (database administrator) interview questions that employers may ask to assess a candidate’s knowledge and skills. Some of the most common and popular DBA interview questions include: These questions are designed to assess a candidate’s knowledge of the core concepts and skills required for a DBA role. By asking these questions, employers can get a better …
There is an old DBA joke, that goes something like this: You either need to have a good backup strategy, or a really good resume. But all joking aside, many people responsible for a SQL Server database find out too late that they did not have the right backup and recovery strategy. How would it feel to explain to your …
Do you have the right backup and recovery strategy? Read more »
If you are a pro at SQL server I am sure you already know how to backup a database, but for someone who is new to it, things can be a bit overwhelming and confusing. This is especially confusing with the number of options that Microsoft has added into SQL Server Management Studio over time. We get called in quite …
On a number of recent installs of SQL Server that I have worked on, I have noticed that the SQL Configuration Manager has been missing from the start menu, not sure if someone deleted it from the menu, or if the icon was just not added. The SQL Configuration Manager is an important tool for configuring the sql instances installed …
At the beginning of June I realized that I was slightly behind on my blogging, so today, June 30th marks 30 days of 30 blog posts in the month of June. Some other big blogging months were March 2015 and April 2015, around the Database Corruption Challenge, and June 2013 with 27 posts, and May 2013 with 27 posts. I …
Question submitted at SteveStedman.com: Is there any formula to calculate size of TempDB? There are some great formula’s out there for instance to calculate the max server memory setting (https://bornsql.ca/s/memory/), however calculating the size of TempDB is not that simple? Consider the situation of 2 SQL Server with the same size databases, exact same hardware, the same tables, but the …
What was your worst day as a DBA? We all have ups and downs in our life, perhaps some of those bad days are the days that make us realize how good we have it on a good day. There are things with family and friends that can make things better or worse, but what I am interested in today …
SQL Server recovery models often incorrectly referred to as (MS SQL Recovery Mode) define how your SQL Server database will treat your transaction logs. There are 3 SQL Server Recovery Models to choose from, Simple, Full and Bulk Logged. Simple: The transaction log is written to as a transaction runs and once the transaction completes what is in the transaction …
It can be a bit time consuming to work through the the SQL Server Management Studio (SSMS) user interface to check on the agent job history to find specific agent jobs that have been run. To help speed that process up, I created the following TSQL script to directly query the job history. This query makes use of a common table …
In SQL Server there is a special connection that can be used to connect to the database, the remote Dedicated Admin Connection or (DAC). This is a special connection that allows the administrator to connect to the SQL Server even if something has occurred that is preventing connections on the normal port. One quick way to check if the DAC …
SQL Server – Dedicated Admin Connection (remote DAC) Read more »