While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I realized I wanted to purge all the data from my Query Store, just for testing. I did a series of searches to try to track down the information and it… Read more
I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several of these in previous posts. While people will claim to learn better based on a single source-type, studies have found that you actually learn best by a multitude of methods.… Read more
Quick little post. I just wanted to share how happy I am with the new “THIS TOPIC APPLIES TO” infographic. An example here:
I think it makes things much more clear when you’re attempting to figure out what’s up with some T-SQL syntax.
Well done Microsoft and thank you.
Side… Read more
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… Read more
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using the language. Even if you do things badly or inefficiently, you’re figuring out how to put the language to use. I tried the same thing with R.
Fair warning, there… Read more
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t even when I had to present in front of people that I respect and admire (although presenting in front of Paul Randal (b|t) & Kim Tripp… Read more
I spend a lot of time talking about the need for automation within your databases, especially in support of development, deployment, and through process management. It’s because I learned the hard way just how important this stuff is. It took a pretty strong developer (in the sense of abilities, he… Read more
Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?
Instead, it seems I’ll be involved with a completely different role. Starting on January 1, I’ll be moving onto the executive committee of the PASS Board and taking on the role of Executive… Read more
When I present at any given event, I generally assume that the people attending have heard of the event that I’m at. For example, I don’t need to ask people at SQL in the City, “Who here has heard of Redgate Software?” Same thing goes for a SQL Saturday event… Read more
This represents my 12th month on the board so I thought I would recap my time there so you know what I’ve done, haven’t done, etc.
A year ago I took over Chapters as my area of responsibility, what’s known as my Portfolio. Wendy Pastrick had been ably running it… Read more
Learning a programming language is largely an act of using that language to do stuff. Done.
However, the big thing about R is the mathematical and statistical analyses that can be easily run against your data sets. This means, part of learning this language is learning another, that of data… Read more
With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had announced my plans to charge down the DocumentDB road to try to get the basics of that in my head along with learning some JSON so I could get… Read more
You know you want to go on the SQL Cruise. You can. You just have to convince the boss that it’s worth doing. It is. I’ve said it before and I’ll repeat it as necessary, SQL Cruise changes peoples lives. I’ve watched people go on the cruise with a… Read more
A great benefit that I get with my job is that I get to travel all over the place to see people present. This means I can expand out beyond my own country to see good speakers. That’s the case this month. My Speaker of the Month, with all the… Read more
Another PASS Summit is complete. This one was amazing. It’s my first time ever as a member of the Board of Directors of the PASS organization to attend the Summit and take part in the full process of making the sausage. It was hard. It was exhausting (more so… Read more
It’s Kilt Day!
I want to give a quick assessment on how the Summit has been for me so far. Monday, as is true for the rest of the week, I served two masters. In the morning I went to the Redgate SQL in the City event. In the afternoon… Read more
If you’re going to PASS and you want to have a chat, I want to talk to you. If it’s about the Board of Directors for PASS, PASS Chapters, execution plans, crossfit or something else, here are a few places where I’ll be doing my best to make myself available: Read more
I’m at least one of the people who yelled Zoomit during a keynote at PASS Summit.
I want to take a moment and explain why I did it and why it was wrong.
I was frustrated. I’m watching a presentation on a HUGE screen, from about mid-way in the… Read more
Next week at the PASS Summit I’ll be presenting a session called Statistics for the New Data Pro.
You can read the abstract at the link. I just want to emphasize that this is a beginner level session. I think way too many people who are just starting out… Read more
I’ve put this off for too long. It’s time to get my feet wet with some new tech.
Step 1 is easy. Go to the Azure portal and start the process for creating a DocumentDB:
While that’s running, let’s see what’s on the interwebs about getting started in DocumentDB…
Nice.… Read more