11 Presentations to Get to Know SQL Server
Are you an aspiring SQL Server data professional? In this post we take a look at some excellent articles and presentations to help boost your knowledge in the space.
Join the DZone community and get the full member experience.Join For Free
for my final blog post in the #gettingstarted, #iwanttohelp series, i decided to curate a set of presentations from the pass virtual chapters. this content is available online. it’s free. most importantly for the person just getting started as a sql server data pro, it’s good. i’m going to marry each of the presentations with my eleven blog posts in this series.
the importance of a full backup in sql server
for this one, i’m going to recommend tim radney’s session understanding sql server backup and restore . i know tim personally and guarantee this is a good session.
why is the server slow?
jes borland is a very close personal friend and an absolutely outstanding presenter (and person). she has a session all about getting you started on wait statistics beyond cxpacket: understanding wait statistics .
sql server backups are a business decision
paul randal is, well, paul randal. if you’re not familiar with his work, you really should be. he presented a session called building the right backup strategy that should coincide nicely with my blog post.
a view is not a table
ok, i couldn’t find a single session talking about views, so i’m going to come at this from the side, just a little (and i might start working on a presentation on views & other structures). this session by kenneth ureña, who i’ve talked with several times, is about structures and performance. it should do the trick. indexing strategies and good physical designs for performance tuning .
use the correct data type
silent killers lurking in your schema by (yes, a good friend) mickey steuwe is absolutely going to cover data types, among other things.
choosing the right sql server edition
john martin (yeah, another friend, what can i say, i try to stay on the good side of smart & capable people) has a presentation that’s a bit more focused on sql server internals but will absolutely address the edition of sql server as part of the work. get sql server set up right! the first time.
i’m also going to add a session by jes borland, again, that introduces azure, especially talking about azure in a hybrid scenario. azure and sql server. plus, i just want to share more azure links. if you’re just getting started with the microsoft data platform, start with azure.
monitor query performance
there are tons of choices here. i’m going with kicking and screaming: replacing profiler with extended events because i know that most people learn profiler first. i also know that we need to get people to start using extended events instead. i will further add that erin stellato really knows here stuff on this topic, as well as many others. she is also a wonderful presenter (and a friend).
azure sql database for your first database
as i said, i really believe in azure as an entry into the land of data platform. it’s easy. it’s inexpensive. it’s available almost anywhere. tim radney has a session called azure sql database for the production dba that will help to get you started.
the clustered index is vital to your database design
the clustered index is so important that everyone presents on it in one fashion or another. i’ve met ayman el-ghazali a few times. we’re not friends yet, but we get along (he’s very smart, see above). his session indexing fundamentals seems ideal for this slot.
statistics are vital for performance
erin stellato has a session called statistics starters . it is so important to understand what statistics are within sql server, how to use them, how to maintain them, it’s hard to over-emphasize it.
powershell to test a query
if you’re just getting going with powershell, you’re going to need tons of help. luckily it’s out there. i could have picked any number of excellent sessions by amazing people (many of them friends). i’m going with the powershell tips and tricks for sql server administration by mike fal. mike (a friend) recently helped me with some of my own powershell scripts, so he’s kind of top of mind at the moment.
for my final post, i wanted to do three things. first, a recap of the last year’s worth of #getttingstarted blog posts. believe it or not, i put a little work into each of these and it’s nice to see them all collected like this. second, i wanted to illustrate the vast quantity of high-quality learning that is available through pass and the pass virtual chapters . i pulled these sessions from a bunch of different chapters. there are alternatives i could have picked for every topic (except for views, something to work on). which leads to my third, and final reason for doing my last post in the series like this, i wanted to keep helping. you now know a great resource to go to and search through for more information and learning.
before we go, i want to launch a small challenge of my own. if you’re a blogger, pick a topic (or a collection of topics like i did), and put together a blog post that curates the content using only pass resources. link back to this blog. use the hashtag, #passcurated. let’s see what other information can be put together.
Published at DZone with permission of Grant Fritchey, DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.