Grow your data career with professional development tips, leadership guidance, and practical SQL Server skill‑building resources.
As a SQL Server User Group Leader with Ray Barley, we are always looking for new ideas for our monthly meetings. We have tried polls on LinkedIN and Meetup. We have had some good feedback on formats, but we really want to have some fun as a group, give
A number of hiring managers have asked me the following question over the years: what key qualities should I look for in a SQL Server DBA? Often times the key qualities needed are very specific to the customer. Perhaps they have a large replication inst
Do you want to earn recognition as a SQL Server 2012 expert? Would you like to discover which SQL Server 2012 certifications are most relevant to your current job or the one you want next? Do you want to learn which exams are required for the SQL Server 2
According to a recent study cited in a Microsoft website, cumulative data will grow 44 times over the next decade. That surge in data growth can only increase the demand for data professionals. More and more people will be needed to fill that demand. Th
Building SSAS solutions is one part of the battle when delivering BI solutions to the users. Another part of the battle is to deploy and process those solutions making them highly available and accessible via different reporting tools. Having a good under
Aggregation is an important aspect of any OLAP/SSAS solution and is a major differentiating factor between OLTP and OLAP solutions. The ultimate goal of building SSAS solutions is to make the right data available to the business users in the intended form
Measures and KPIs are very important aspects of an OLAP/SSAS solution from an end user standpoint, and in general, an important aspect of any Business Intelligence application. Storage is another important aspect of SSAS from an engineering standpoint. He
Dimensions are a very important component of an OLAP Solution/Cube in SQL Server Analysis Services. Hence it is good to have a fair amount of knowledge/understanding on the Dimensions, its properties, and its sub components like Attributes and Hierarchies
In many organizations the SQL Server DBAs are among the unsung heroes in the IT Department and overall organization. Often times their contributions are unknown and overlooked. It this tip I would like to outline some of the value I have seen SQL Server
I am looking for career advice. I would like to know how to get started with my career and plan for changes over time. Do you have any suggestions for building my career? Check out this tip for some valuable career advice for new and experienced SQL Se
Data Warehousing (DW) and OLAP are very vast areas and are very essential areas when it comes to supporting critical business decisions. It is important to have a good understanding of the subject before attending an interview in the DW/OLAP space. Hence
Whenever you are preparing for a SSAS interview, it is a usual practice to decide on the list of topics to be covered and ensure that you have prepared yourself thoroughly in each of the listed areas. However, it is always a good idea to go over a few int
In the latest installment of the SQL Server interview questions, we will outline questions suitable for a DBA or Developer interview to assess the candidates skills related to SQL Server performance tuning. In this tip, the questions are there to read, bu
If you are preparing for a SQL Server Developer or DBA interview as the interviewer or interviewee, today's tip should offer value to you. This tip has interview style questions graded as either easy, moderate or advanced related to T-SQL, the relational
When preparing for SQL Server Integration Services interview be sure to understand what questions could be asked in the interview. In this tip series (tip 1, tip 2, tip 3, tip 4), I will try to cover some common Integration Services interview questions to
If you are preparing for a SQL Server DBA interview as the interviewer or interviewee, today's tip should offer value to you. This tip has interview style questions graded as either easy, moderate or advanced related to backup and recovery. To help gauge
In the latest installment of the SQL Server interview questions, we will outline questions suitable for a DBA interview to assess the candidates skills related to SQL Server Agent. In this tip, the questions are there to read, but the answers are intentio
My organization is in the process of hiring a junior SQL Server DBA to add to our team. What are some fair questions to ask as a portion of the interview process? I want to make sure we hire someone who has a good base of knowledge. I am concerned are
Are you an aspiring SQL Server Integration Services Professional? Do you need to prepare for an upcoming SSIS interview? Check out this tip series (tip 1, tip 2, tip 3, tip 4) on interview questions and this tip related to SQL Server Integration Service
When preparing for SSIS interview it is important to understand what questions could be asked in the interview. In this tip series (tip 1, tip 2, tip 3), I will try to cover common SSIS interview questions to help you prepare for a future SSIS interview.
This tip includes several links to inteview questions related to SQL Server for both developers and DBAs.
When preparing for your next SSIS interview be sure to understand what could be questions asked in interview. In this tip series, I will try to cover as much as I can to help you prepare better for SSIS interview. This tip covers transactions, event handl
When you are preparing for an SSIS interview you need to understand what questions could be asked in the interview. In this tip series, I will try to cover as much as I can to help you prepare for SSIS interview. In this tip we will cover SSIS basics and
When preparing for a SQL Server interview, it is helpful to understand what questions may be asked related to SSIS. In this tip we cover some basic SSIS concepts that may be asked.