Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Interview Tips

When is the last time you interviewed for a position? It could be at a new company, or maybe it's for a different position inside your own company. Perhaps you just needed to make an impression internally for a new project. I've always treated all my one-on-one meetings or reviews as interviews since I'm usually trying to impress someone enough to get a raise or promotion.

Preparing for something you do rarely is hard. If your partner is also a business person, perhaps they can help you, but I've found that most people struggle to help others prepare as they don't know how, especially if they don't interview others regularly.

I used to interview people periodically as part of my job. Over time I built up a routine of how to run an interview, ask questions, record notes, and evaluate people. I spent time asking others and reading up on how different companies do this, and I think I got good at the process. Not necessarily at hiring people as that still felt hit and miss, but at least I had a process.

When I was looking for jobs, which happened a bunch in my late 20s/early 30s, I also had a process and I think I did well. I got offered positions after most of my interviews, which was a luxury since that often gave me a choice of where to work. I saw this post on Linked In with a list of questions and answers for a job interview. These are certainly the type of questions I've been asked before, and I've prepared for. While this aren't bad answers, they aren't enough.

Some of these might not be asked in internal interviews or reviews, but you ought to be able to give a short answer and then follow it up with an example from your career, give some details and practice delivering those smoothly. Know your own story, and don't look like you're fumbling for answers, trying to remember things you've done. It's understandable that you might not remember details of some event from ten years ago, but it is also a sign you haven't prepared for an interview.

Getting a job these days is about having some relevant experience, having good soft skills, and standing out from the pack of other people who are applying for the same job. Blogging helps showcase experience, practicing communication helps soft skills, and great stories of things you've done help you remain memorable when the interviewer is talking about all the candidates with their peers.

If you want a new and (hopefully) better job, put in some work and prepare.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents
Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview

Tony Davis from SQLServerCentral.com

The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.

External Article

How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?

Additional Articles from MSSQLTips.com

The article A gentle introduction to dbt explains how you can get dbt in the cloud version, how you can set up a free account, and how to create a connection to a Microsoft Fabric warehouse.

Technical Article

Navigating Your Test Data Challenges: Insights and Solutions

Press Release from SQLServerCentral

Join Redgate on May 1st for an insightful webinar cohosted with analyst firm, Bloor Research, featuring independent Senior Analyst Daniel Howard and Redgate's Steve Jones. Discover the biggest test data challenges, the latest approaches like AI synthetic data generation, and how effective test data management can benefit your entire organization. Don't miss out on this opportunity to gain valuable insights and solutions.

Blog Post

From the SQL Server Central Blogs - SQL Server Wait Stats

Kevin3NF from Dallas DBAs

Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...

Blog Post

From the SQL Server Central Blogs - FabCon 2025 Recap

DataOnWheels from DataOnWheels

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best way). It was incredible to see so many folks in Redmond for the MVP Summit,...

Big Data Analytics cover

Big Data Analytics with Spark: A Practitioner's Guide to Using Spark for Large Scale Data Analysis

Site Owners from SQLServerCentral

Big Data Analytics with Spark is a step-by-step guide for learning Spark, which is an open-source fast and general-purpose cluster computing framework for large-scale data analysis. You will learn how to use Spark for different types of big data analytics projects, including batch, interactive, graph, and stream data analysis as well as machine learning. In addition, this book will help you become a much sought-after Spark expert.

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The Long Running Backup

I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

The Monitor Server

What does the monitor server do in log shipping?

Answer: This is an optional server that tracks all the details of log shipping

Explanation: The monitor server is optional in log shipping. This is an instance that tracks the details of log shipping, such as when the primary transaction log was last baked up, when the secondaries copy and restore the files, and failure alerts. Ref: Log Shipping Terms and Definitions - https://learn.microsoft.com/en-us/sql/database-engine/log-shipping/about-log-shipping-sql-server?view=sql-server-ver16#terms-and-definitions

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2016 - Development and T-SQL
Why would using a variable vs Hard Value impact a Query's Performance - Why would using variables in place of hard coded numbers impact a query's performance?  The below code is just an example of what I'm asking. In  my case I have the same query twice with the difference being that one has the values hard coded in the criteria and the other is using variables that […]
SQL Server 2019 - Administration
Size of DB on physical disk doesn't match Disk Usage by Table report - Hi everyone I am looking at the size of my db on disk (ie c-drive) and comparing it against SS report Disk Usage by Table.  The size of the mdf file on my storage drive is close to 37 GB.  The sum of all tables and indexes (columns Data (KB) + Indexes (KB)) on the […]
SSIS Won't Create Log Entries - Hi everyone My SSIS package will not log to sysssislog.  I am not sure what to do to troubleshoot.  Can someone please provide some guidance on what I can do to help fix this? Setup configuration: The configuration manager I use is the same one I use in SSIS when I have tasks that read […]
SQL Server is terminating in response to a 'stop' request from Service error - Dear All, In one of the server its repeatedly restarting sqlserver services and not found any thing in logs except this Message SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. please help to find some solution to fix […]
Somebody realized to configure Cluster-Aware updating on VMWare nodes - Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File server. All servers are VMWare Virtual Servers (with Windows server 2025) Having some problems with configuring the Cluster-Aware Updating. While troubleshooting i was just wondering if this is possible to install. Is there anyone on this forum that was able to […]
SQL Server - Log file not getting smaller on Log backup - I have a database that is in full backup recovery model. When the log file is backed up the usage size is not getting smaller [ dbcc sqlperf(logspace) ] . For example, if the log file is 1000 MB, and 800MB is used, the expectation is when a log backup occurs, the usage will then […]
SQL Server 2019 - Development
Update particular record in a table - I need to update greatherthan8 (category) record to Missing (status) if the same member is in different (category) but having same (status) and that also only when they are  compliant. for example 123 PID i have both lessthan8 and greaterthan8 (category) but having same (status) that is compliant so for this member 123 for greaterthan8 […]
SSIS giving "Error converting data type varchar to float" error - issue resolved.
mysql query timeout upped but job still fails about same number of minutes in - hi, i changed my mysql based linked server's timeout to N'600' instead of N'0' but my job (sqlagent->ssis) goes down at about  the same number of minutes in as when i have it at n'0'.  the error i get is shown below. i'm using an odbc driver (mysql) installed on my sql server to contact […]
is it cache or something else - hi a few days ago i narrowed down the cause of a new problem in ssrs to 2 columns (of maybe 50) in a view.   nobody is claiming responsibility.  the calcs for both are hard to look at.  when i eliminated the 2 columns, the view ran in ssrs fine. if you haven't seen this […]
Reporting Services
Report Server Configuration Manager - The target principal name is incorrect SSL - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. Report Server Configuration Manager - Database - Change Database - Choose an existing report server database. - Test Connection I am able to log into the SQL Server in SSMS without checking […]
Report Server Configuration Manager - Change Database - SSL Error - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. I'm trying to set the database in the configuration manager and when I click on 'Test Connection' or 'Next' in the 'Change Database' popup box, I get that error. Report Server Configuration […]
SQL Server 2022 - Administration
Just a rant about the SQL Server 2022 upgrade - Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am so glad we're doing this in our test environment. During the install, got a popup about a missing file C:\Windows\ProPatches\msoledbsql_18.7.4_x64.msi Try again fails, obviously - I have no idea why they even have "try again" as an option, the file is […]
Edition features - SELECT * FROM sys.dm_db_persisted_sku_features If the result set has no records is it conclusive to state that the enterprise features are not being used and we can downgrade to standard? This is across all sql versions...2008R2,2012,2014...2022 Are there more checks which need to be performed before we make an informed decision ? Thanks
SQL Server 2022 - Development
Internationalisation - Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a product for some time now that had an entirely UK-only customer base. The powers that be now want to flog it to Australia and the ROI. For one reason or another, there are a few places […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -