The start of a new year is a time for self reflection and along with it perhaps a desire to do something new with your career. Maybe you are considering becoming a Junior Database Administrator (DBA)?
Acquiring your very first role as a Junior DBA is no easy feat. Just browse any one of the many [...]
Posts under ‘SQLServerPedia Syndication’
Top 10 Junior DBA Interview Tips
SQL Snippet: What SQL Server Agent Jobs were running at that time?
Here is a SQL Snippet that can be used to identify the SQL Server Agent Jobs that were running on a server at a particular point in time.
This can come in very handy if you need to troubleshoot a performance issue after the fact and want to find out if there were any jobs running [...]
SQL Snippet: SQL Server Wait Types
Here is a handy little SQL Snippet that will return information about those all important SQL Server Wait Types for your server. It uses the SQL Server Dynamic Management View (DMV) sys.dm_os_wait_stats in order to extrapolate the desired information. A column has also been added to provide details of the percentage of total wait time [...]
Blog your way to becoming a better DBA
One of the most rewarding aspects of Blogging is that the content you share and publish has the potential to help others in your community but have you also considered that Blogging can actually make you a better DBA?
You see the act of blogging itself provides a number of subtle benefits for your professional development.
Why [...]
Top 5 Free SQL Server Tools
Maybe there is no such thing as a free lunch but who cares when there are awesome tools for SQL Server that are available for free!
That’s right, you can make life a whole lot easier for yourself by maximising your valuable time so you can concentrate on the good stuff and the best [...]
SQL Server Essentials – Part 2: Why you should be using the FULL Recovery Model
In Part 1 of the “SQL Server Essentials” series we discussed the Database Administrator’s primary responsibility.
Given that your data is so important, how can you manage and ensure it’s safekeeping? Should a data loss event occur, you want to be in a position to enable you to protect the majority, if not all, of your [...]
SQL Server Essentials – Part 1: The Database Administrator’s Primary Responsibility
You’re busy coding away at your workstation when all of a sudden your manager walks over to you all excited and begins discussing with you, the details of this great new application your company has just aquired. It turns out that he wants you to look after and administer this newly aquired application platform, which [...]
Top 5 SQL Server Forums
As you no doubt already know, there is a ridiculously large amount of SQL Server Information available out there on the internet. Whether you’re browsing forums, web sites or blogs, knowing what the best sources of SQL Server information are and more importantly which one’s you can trust, can be tricky.
So to help you get [...]
DMV Query to identify all active SQL Server Sessions
You may already be aware that I am a big advocate of the SQL Server Dynamic Management Views (DMV’s) and the benifits that they bring to the Database Administrator. They certainly came in handy with a requirement I had recently whereby I needed to identify the IP Address of a specific SQL Server Login [...]
What does it take to be an outstanding SQL Server DBA?
There has been quite a bit of activity this past week in the SQL Server community regarding how to secure a role as a Junior DBA. Brent Ozar has posted a number of articles here and @SQLBatman has also been busy posting Junior DBA Questions.
Both authors make some excellent points but what if you are [...]