Grow your data career with professional development tips, leadership guidance, and practical SQL Server skill‑building resources.
There are three Microsoft certifications available for SQL Server 2008. In this tip we look at available resources for each of the different certifications: Database Administrator, Database Developer and Business Intelligence Developer.
I am new to the SQL Server platform and want to break into the field. I have been doing IT work for a while now and I am looking to focus my career on SQL Server. Do you have any suggestions? Where should I start? What should I be prepared for during
When preparing for a SQL Server interview there are several topics that could be covered. In this tip we cover some possible interview questions and answers related to SQL Server replication.
When most DBAs and Developers hear the term 'project management', I am sure this is not a term that makes them jump for joy. Those emotions are probably from past experiences where they have had issues. To me past performance does not always dictate fu
How did you learn SQL Server? This is a question that has been asked of me a few times over the last few months. I have also been asked how someone can get up to speed with SQL Server very quickly and become productive. Check out this tip to get some s
In this tip, we have a list of SSRS Developer level interview questions that you can go through to refresh, evaluate and deepen your knowledge on SSRS development and take it to the next level.
Do you want to distinguish yourself as a database developer on the SQL Server 2008 platform? Consider studying for and passing the 70-433 exam. The Microsoft Learning site recommends the exam for those writing T-SQL code for database solutions. The exam e
In a recent tip, a DBA explained that he has SQL Server Agent Jobs created without his knowledge on a regular basis. He indicated that setting up proper security and a change management process would be the solution to this issue. Is that really all it
I have been a SQL Server DBA at one organization for a number of years. I am moving on to another organization and I saw one of your tips about leaving a SQL Server job gracefully. I thought this was a good tip, but I could use some recommendations on s
Do you want to distinguish yourself at classic DBA duties with SQL Server 2008? Consider passing the 70-432 exam. The Microsoft Learning site recommends the exam for those performing SQL Server DBA tasks, such as installing, configuring, and maintaining S
You’re leaving your current employer for a new opportunity and want to make the move as smooth as possible. You don’t want to burn your bridges and want to make sure that everything you’ve left behind can be managed by the people you’ve left behind or the
Get started learning about Microsoft SQL Server which is a relational database management system including SSIS, SSRS, Power BI, SSAS, T-SQL and more.
At our organization many folks wear a variety of hats, because we have a small and talented team. Although we have a SQL Server DBA, our Network Administrator also takes care of some of the SQL Server related tasks in our environment. We are looking to
We are in the process of trying to hire a Junior SQL Server Developer to work on a few of our projects. What expectations should we have on their skill set? What are some fair questions to ask them during the interview process? With a junior level deve
The phone interview. It has tales of bringing normally rationale people to a terrified state. I have even heard of a DBA that was so worried about a SQL Server phone interview that 'they just happened to be in the office park' where the company was loca
My job function is a Network Administrator, not a SQL Server DBA or Developer, but I work with SQL Server on a regular basis. I could use some pointers to improve my skills. What would be a good SQL Server primer for me? What are some high level SQL Se
In the latest installment of the MSSQLTips interview question series we are going to cover questions on T-SQL functions. The questions are categorized as either easy, moderate or difficult with the question available to read, but the answers are hidden t
There is something to be said for taking a vacation. The rest and relaxation, seeing new places, being exposed to new and exciting things. The other side of the coin is being on-call, answering pages at 3:00 AM then driving around a strange location hun
I've been working remotely (also known as Telecommuting) for over 8 years now. While it sounds great: Hey I get to work from home! telecommuting effectively takes a great deal of work. You can't just phone it in (sorry I could not resist the pun). B
SQL Server Security, probably one of the most controversial and debated topics among SQL Server DBAs and Developers. One person's security is another person's nightmare and vice versa. With security being so important for so many different reasons let's
Over the years at MSSQLTips.com the tips focusing on interview questions have been popular with the community. From our first tip on SQL Server Concurrency and Locking Interview Questions to our most recent on SQL Server Backup and Recovery Interview Que
Staying up on the latest SQL Server technologies is a huge benefit to employers. Many seek only the best and brightest to build solutions for the organization. The general premise is the more knowledgeable their team is the more opportunities the organi
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 system databases. In this tip, the questions are there to read, but the answers a
Over the last few months I have heard the terms 'typer' and 'clicker' related to how SQL Server DBAs manage SQL Server. Working with one specific customer, the customer came right out and asked me 'if I was a typer or a clicker'. I was surprised to hear