Each work day, you have responsibilities as a Database Administrator (DBA). Those responsibilities vary, based on the type of business, type of administrator, and type of databases. Generally speaking, there are specific responsibilities that you should include in your daily activities, which you can customize to your specific environment.
1. Checking on Servers
Whether you’re responsible for the hardware or not, there are plenty of things you’ll want to do to check on your servers each day. Checking Windows Event, SQL Server Logs, and reviewing the SQL Server Agent are daily activities:
DBAs and the SQL Server Agent
DBAs and SQL Server Logs
DBAs and Windows Event Logs (not always accessible to you as a DBA)
In some environments as a DBA you may not have enough time to review details for every server every day. If so, set up a schedule where you make sure to keep looking at your most important (most mission critical) servers daily and then cycle through them daily or weekly, with reviews of non-essential servers based on priority, etc.
Stack Overflow has asked developers each year since 2011 about their favorite technologies, coding habits, and work preferences. This includes how they learn, share, and earn more money. This year over 64,000 developers took their annual survey.
They learn something new every time they perform the survey, and this year is no exception:
A common misconception about developers is that they’ve all been programming since childhood. In fact, we see a wide range of experience levels. Among professional developers, 11.3% got their first coding jobs within a year of first learning how to program. A further 36.9% learned to program between one and four years before beginning their careers as developers.
Only 13.1% of developers are actively looking for a job. But 75.2% of developers are interested in hearing about new job opportunities.
When we asked respondents what they valued most when considering a new job, 53.3% said remote options were a top priority. A majority of developers, 63.9%, reported working remotely at least one day a month, and 11.1% say they’re full-time remote or almost all the time.
A majority of developers said they were underpaid. Developers who work in government and non-profits feel the most underpaid, while those who work in finance feel the most overpaid.
So what can you learn from the answers collected during this survey? How about what languages pay the most, or are in the highest demand?
You can get much more detail directly from the Stack Overflow survey results.
The TIOBE Programming Community index is an indicator of the popularity of programming languages. The index is updated once a month. The ratings are based on the number of skilled engineers world-wide, courses and third party vendors. Popular search engines such as Google, Bing, Yahoo!, Wikipedia, Amazon, YouTube and Baidu are used to calculate the ratings. Observe that the TIOBE index is not about the best programming language or the language in which most lines of code have been written.
This month Visual Basic.Net has moved up sightly, but the big news is the PHP replacement language called Hack.
As a manager, you have to be thinking about the people that work for you all year long, but the first of the calendar year can be a time when some of your people decide to make a career move.
Understanding their motives and reasoning for this thinking, you have to look at the most common reasons for moving to a new job.
Lack of Communication – Good communication can mean different things to different people. Some people might need much more face-time than some of your other people. This is a significant risk at the end of the year when the traditional holiday season might distract your team and prevent the same level of communication as they might get during the rest of the year.If you’ve been neglecting your team, apologize to them explain how you plan to be a better communicator this year.
No Transparency – We all say we value transparency and make everyone to be authentic and honest. We need to look at how we communicate with our team and make sure we are keeping them in the loop about what is happening in the company. While everyone understands their must be some information they just can’t know about today, your team must feel you aren’t keeping secrets from them. Verify you use clear and open communication with everyone on your team, and stress that they can come to you about any concerns they have.
Boredom – It can be easy to keep your best people assigned to perform the the same tasks every day. You can’t wait for someone on your team to request new or challenging tasks. You should be constantly nudging your team members to do something new or something that makes them unsure about their skills. Great employees want to be challenged and you want great employees. Look for ways to force individuals to expand their skills or use their skills in a different way.
Flexibility – People are always looking for more flexibility in the way management deals with them and their relationship with the company. This includes the ability to work remotely, the ability to use new tools, or a desire to explore more workplace perks. Talk to your people and make sure you understand what is important to them and them work help make it possible.
Stagnation – While some people are perfectly happy in their current position, many want to grow and learn new skills so they can seek promotion and greater responsibility. You will need to find a way to help them grow by providing constant feedback and, when possible, a mentor to help your people realize their dreams.
Here’s the top 10 items you clicked on the most in 2016:
20 SQL Server DBA Interview Questions – Some sample questions you might be asked about in an interview for a DBA position. Also used by the hiring managers to make sure they have some relevant questions during your interview.
SQL Server TCP and UDP Ports – This post lists the ports and protocols required to communicate with an instance of SQL Server. This can be very helpful if you need to create or manage firewall rules blocking unauthorized access.
SQL Server End-Of-Life Schedule – This is a useful reference if you need to know if your version of SQL Server is still supported, and when it will no longer be supported.
Reset Password and Disable SQL Server SA Account – With auditors wanting all user accounts to have passwords that change at least every 90 days, or the account must be disabled, this provides some guidance on how to make that work with the SA account.
Happy New Year! I hope you will continue to visit this site for helpful information on a variety of topics.
The Microsoft .Net framework has been around for about 14 years. While C#, C++, VB.NET, and F# seem to be the most supported and used languages to build .NET applications, there are close to 50 languages that are supported by the .NET framework.
In 2014, Microsoft moved to open-source .NET by introducing .NET Core. Most of the .NET components (compilers, languages, libraries, and tools) are now open-source and available in Github.
The new open-source component of .NET is named .NET Corevand has even more developers embracing what Microsoft is doing with .NET and the associated programming languages. Microsoft has acquired Xamarin and its products so developers can now use C# to build Android, iOS, and Windows mobile apps.
Is now the time to seriously consider the Microsoft .Net framework for your development?