Getting Started in a SQL Server 2017 VM in Azure

Uncategorized
You say you're ready to dip your toes in the Azure ocean? Come on in, the water's fine! Oh, you want to really dip your toes. You're starting with Virtual Machines? OK. I guess. It's not where the real excitement is. You should be checking out Azure SQL Database and Azure SQL Data Warehouse and CosmosDb and... VMs. OK. Let's get you started. Set up Azure First Microsoft maintains seriously good documentation on how to work with Azure. I'm honestly blown away by how much information there is and how well written it is. In fact, everything I'm about to tell you is documented better, here. However, I'm going to give you the TLDR version. First, you have to have an Azure account. If you have an MSDN license, that…
Read More

SQL in the City 2017

Uncategorized
Redgate is once again hosting a live, virtual event for SQL in the City. We're going to give you a lot of educational content on DevOps, SQL Server, Monitoring, GDPR and compliance. We'll also be doing all this with Redgate tools. Here's my promotional video for the event: [video width="1280" height="720" mp4="https://www.scarydba.com/wp-content/uploads/2017/12/SitC.mp4"][/video] I hope you'll join us for this event. It's live, so you can ask questions and we'll all try to help out. Go here to register.
Read More

SQL Cruise as a Speaker and Sponsor

Uncategorized
SQL Cruise offers a number of unique opportunities for everyone involved, including speakers and sponsors. I've written before, several times, about the benefits of SQL Cruise. As an attendee of the cruise, you will get to sit in classes by amazing people (and me) talking about all aspects of the Data Platform. Further, you get the opportunity to sit down, for long hours, with these people and get, for want of a better description, free consulting time. What about as a speaker and a sponsor though, do we get benefits? As A Speaker Tim Ford is quite a bright fellow. He has tweaked and tuned SQL Cruise. I have been on SQL Cruise a number of times over the last five years, and it has changed radically since my first cruise…
Read More

There Is No Difference Between Table Variables, Temporary Tables and Common Table Expressions

Uncategorized
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was "personal preference" and didn't change at all the way SQL Server would choose to deal with them in a query. Let's immediately say, right up front, the title is wrong. Yes, there are very distinct differences between these three constructs. Yes, SQL Server will absolutely deal with these three constructs in different ways. No, picking which one is correct in a given situation is not about personal preference, but rather about the differences in behavior between the three. To illustrate just a few of the differences between these three constructs, I'll use variations of this query: SELECT * FROM Sales.Orders AS o JOIN Sales.OrderLines AS ol ON ol.OrderID = o.OrderID WHERE ol.StockItemID = 227; The…
Read More

A Moment For Reflection…

Uncategorized
While this is a personal blog, I try to keep it focused on either technical topics or personal development and leadership related to technical topics. This post is a complete deviation from all of the above. Please, read it anyway. I went to Auschwitz and Birkenau. Words are failing me here. Before I went, I was terribly conflicted about the trip. I had the opportunity to visit another Nazi concentration camp, Dachau, and I deferred. I know horror was committed there. Why should I voluntarily subject myself to it? As part of a trip to Poland, Aaron Bertrand suggested we should take a couple of extra days to see the sights, including visiting Auschwitz. I didn't want to go. Then I started thinking. Obligation. Honor. Remembrance. Humility. Respect. I truly…
Read More

Restoring a Database in Azure

Uncategorized
One of the many small things you don't have to worry about any more when working with Azure SQL Database are those pesky backups... Ha-ha-ha! Yeah, I can't keep a straight face when I type it. Microsoft takes on the role of DBA and creates backups and log backups for you when you're working in the Platform as a Service offering of Azure SQL Database. If that doesn't scare you, I'm not sure what will. However, there's good news. There are still ways for you to create your own backup (through the bacpac, I outlined it here, years ago). More good news is, Microsoft's backups actually work. Testing it out is easy. Let's walk through it once. I'm going to assume you have an Azure account on which you already…
Read More

Argenis Without Borders: Fun For a Good Cause

Uncategorized
This is the second year of Argenis Without Borders and the second year that I'm taking part. Last year we hit the fund-raising goal and I wore the rainbow fuzzy leggings at the PASS Summit. This year, it feels like we're a little behind the goal. We need you to get your wallet and fork over a little cash to help out this worthy charity, Doctors Without Borders. This year, the goal will be to get me into a funny hat. But, well, I already wear funny hats all the time: So I'm a little at a loss as to what to do: I mean seriously, where do I go from here? Any suggestions for a good funny hat? Only make them after you've donated though.
Read More

Speaker of the Month: May 2015

Uncategorized
When I attend sessions at events, I try to mix it up. I'll go to a session that, really, I probably will never use the information, just to expand my knowledge level a little. I also go to sessions by the masters so that I can try to expand my skill set. I go to sessions on topics that I feel like I know well just to reinforce my own learning and understanding. That's where I got the Speaker of the Month for May 2015, Denis McDowell (t). I went to his session titled DevOps for the DBA at SQL Saturday #380 in New York City. I present pretty regularly on this topic and I've helped build multi-day training courses on it. Seriously, I feel like I probably know it.…
Read More

I Am Grateful For…

Uncategorized
I'm almost done reading the book Connected (will be by the time this is published). It's fascinating although, at least so far, little in the way of suggestions for how to take advantage of this information. That however doesn't change my plans around working on positive thoughts and emotions as a way to hack your own mind and increase productivity. I'm also trying to figure out how to reinforce my network. In short, these are completely self-serving posts. I am grateful for Thomas LaRock (b|t). Tom is hard to miss. If you look at the floor all the time, the green shoes might be a giveaway. If you look up a lot, keep looking up because he's quite tall. Oh yeah, and he's the President of PASS (for a couple of…
Read More