SQL Server Express - Install Configuration File?

Using configuration files as part of a SQL Server install is a great way to use a consistent and reusable setup, and make the process easier. The configuration file name and location is available on the Ready to Install screen, just where you would hit the magic install button.

OK as buttons go it's not that magic!

If you're using SQL Express things are a little bit different, in fact there's no configuration file available at all as the Ready to Install screen doesn't exist in the standard setup. Here I'm trying to install SQL Server 2017 Express Edition:

With no configuration file available I would either have to let the install finish without one or hit cancel. I can see why this happens as Express is all about a speedier install, especially with the new basic install option, but can we still get a configuration file if we really wanted?

Following the official documentation on installing SQL Server:

SQL Server Express Edition setup does not create a configuration file automatically. The following command will start setup and create a configuration file.

SETUP.exe /UIMODE=Normal /ACTION=INSTALL

So in order to get a configuration file we're going to have to tell SQL Server to use the normal UI mode option, which the UI option for the non-express edition installs.

This time after setting whatever options I need to, I get to the Ready to Install screen and my configuration file is available again:

Speaking at my first conference.

Recently I had the opportunity to speak at DATA:Scotland. It was my first time speaking at a conference where I presented my session on Guillotines, Sat-Nav and the Query Optimiser. During my time there I met quite a few people who were interested in speaking too but hadn't quite yet made the jump, so I thought I'd try and use a blog post to give people a helpful nudge.

Firstly, although this was my first conference I did get the opportunity to speak at a couple of local(ish) user groups beforehand. This was ideal because I could try out the session in front of a very friendly crowd and get a lot of instant feedback too. I could also get a feel for some of the bits that worked and some of the bits that didn't. 

I'd also read a lot about public speaking but in truth when it comes to actual delivery style I guess that's just develops (or is constantly developing) quite naturally. For me I throw in quite lot of humour into my session which helps me break the ice with the audience and build a rapport with them, but that is something that fits my personality and works for me. I guess if I try to be or present as someone else then it's probably not going to work.

I also try to speak about topics that I am really interested in, it sounds obvious but it's also true. I'm quite happy to talk about the query optimiser because I really enjoy the inner workings of SQL Server, particularly around optimisation. Ask me to talk about merge replication and a session will be totally different, or more than likely non-existent!  

Practice is key. Another rather obvious bit of wisdom but another that is also completely true. I would go over parts in the car, in the shower, in my sleep and to my rehearsal audience of the dogs. For me it's about constantly tuning the delivery; what works, what doesn't sound right, would this slide be better over there, does this even make sense etc etc?! 

I'd also add that the practice doesn't end after delivery, I'm still very much making tweaks!

Having the support of DATA:Scotland was crucial. They provided me with a speaker mentor, Alex Yates, who provided some absolutely priceless insights into speaking and gave me some awesome advice on my session. After our first talk I genuinely was full of ideas because I was able to look at the session from an attendees perspective, something I hadn't really done. Now I had questions such as, "why is this useful to me?" or "how does this make me do my job better?" in mind when putting it all together.

Having the newcomer session option was a big nudge for me. I'm not even sure I would have submitted a session without it and genuinely I think it's brilliant. Not only did I have a superb mentor but there was also a couple of web sessions on presenting. Also, being introduced as a new speaker at the conference helped too, it didn't feel like I was plunging into the deep end as much!  

There's loads more and I'll definitely write more about the experience but what I will say/write is that just before I went into the room I told myself that never again would I be experiencing speaking at a conference for the first time again. This was it and I needed to immerse myself in the experience, nerves and all, as much as I could. I like to think I did just that and as such it was one of the most rewarding experiences of my life.

It's also rather addictive. 

If you are wondering about it then reach out to the community, local user group or even me, I'm more than happy to share my experience of speaking and give any advice that I can (though wisdom may be rather limited).

In the defence of certification.

The usefulness of IT certification is a constant question and I don't actually think there's a definitive answer just lots of opinions, here's a couple:

https://www.scarydba.com/2019/08/26/certifications-are-a-bonus-not-a-path-to-employment/

https://itsalljustelectrons.blogspot.com/2017/04/Certified-And-Inexperienced-The-Kiss-Of-Death.html

Here's mine:

Certification is very useful.

Now I totally get why many people see them as surplus (or a bonus). I've met so many talented and highly skilled IT pros who don't have a single cert to their name and it has to be said that I've also met a few people who have an abundance of certs that haven't quite necessarily lived up to them.

There's also the age old problem of certification not equating to real-life experience, which is absolutely a fair point. At the end of the day you just cannot substitute actually doing the job, but does make certification a waste of time?

I honestly don't believe so. Although I only have one SQL related cert to my name (well I did but then it expired shortly after William the Conqueror took the helm) it proved to be an extremely valuable thing to have early on my career when it undoubtedly got me through the door to a few interviews where it was always mentioned (and subsequently led to my first "proper" DBA job).

Now it would be easy to ask that if they were that useful then why did I never take any more? In all honesty until recent times I've never really needed to but now with the emergence of so many new technologies I've hit the studying again. Taking certification in unfamiliar technology is a great way to learn because of the structured path that it provides and let's not forget the sense of achievement in actually gaining certification in something that has often started from very little knowledge.

I use the word achievement because gaining a cert really isn't easy, providing you do it in the right way. It takes hours upon hours of repeated studying, practice, not to mention an exam at the end of it which isn't everyone's favourite activity! Unfortunately though there are some short cuts available and there are people that take them but there's absolutely miles between someone who has taken a cert properly and someone who hasn't and that shouldn't devalue what certification stands for - that's not fair.

I've been on the other side of the interview table many times. For me certification really stands out and I can fully appreciate the efforts that people have taken to get it, and what it really means to them. I've interviewed people that are really trying hard to get into a role but they lack the significant experience but they've done the exam(s) to at least try to prove that they want to do it and for me that stands for a lot because I think it shows a great deal about the person, it's not just the cert.

Some people that I have met also take the certification path because they do stand for a certain level of expertise. I've seen more experienced people be very dismissive of certs, just like the MCTS which was the one I had. In fact I saw a whole social media conversation on that very subject shortly after I got mine. That really sucked because I think the point was missed; alright, I was in no way an expert (neither would I make out to be) but I'd learnt a lot, from nothing and at that time I had something to show for my efforts.

Like I said at the beginning, there is no definitive answer because many people haven't needed them and just as many have found them extremely useful. They don't substitute real world experience but then you can't really compare the two, they're completely different things but certification helps people get there, that, based on my own experience is the most beneficial factor.

DATA:Scotland 2019. Unleashing the Guillotine!!!

Friday 13th of September will be my first ever appearance at a conference as a speaker at DATA:Scotland. Needless to say I cannot wait and I'd like to thank the organisers, selectors or whoever it was that drew out the short straw that is me.

I'll be presenting my intriguingly titled 'Guillotines, Sat-Nav and the Query Optimiser' session which I presented at the Manchester and Leeds User Groups earlier this year. The user groups have proved to be a really useful experience as some of the questions that were raised from the audience I've taken onboard and added in, basically I've been stealing their ideas.

My session starts at 12 which unfortunately for me is when my daily caffeine intake usually starts to wear off right at the same time I start to get hungry so I might take up a flask of espresso and a couple of wagon wheels to keep me going. I'll be in conference room 7 which also happens to my lucky number, so that's good news.

Something very new to me is that there will be presenters presenting their sessions at the same time as me and as such I need view these SQL superstars as, well, the competition I guess. I'm not entirely sure what tactics to deploy to get people to come and see me instead; media smear campaigns, good old fashioned kidnapping or perhaps just go really heavy on the propaganda...a bit like this blog post.

The truth is I'm very much overwhelmed at seeing my name up there on that schedule surrounded by people who in all honesty I hold in the absolute highest regard, and I also promise not to kidnap anyone (is their an emoji for fingers crossed behind your back?).

So what can people expect? Well at the moment we're in the midst of an amazing shift in the technical landscape. We've got all this funky cool new stuff like AI, the cloud, containers, Kubernetes etc etc etc and obviously I thought not to cover any of that. No, apparently vintage is all the rage these days so I'm jumping right on that bandwagon!

It may be old school but the query optimiser to me is like the magic box of SQL Server. We all throw queries at it and it goes off and does what it does, that's the beauty of it but at the same time we don't often get chance to open the box and have a good root around - and that's where this session comes in. So I'll be covering how the optimiser works, some of the magic tricks that it performs, how we can use SQL to keep a very close eye on what the optimiser is doing and of course how to break it!

It's worth adding that I will also be trying my best to seamlessly link the query optimiser to guillotines and satellite navigation - that'll teach me to come up with a great title before the actual presentation. I say that but I am currently working on a new session called "fixing your availability groups with sticky back plastic", take note Blue Peter (is that even still on?).

As well as the actual learning stuff (which I promise, there's plenty) there's a few ice breakers in there which I'll not give away right now and there's a good sense of humour throughout, which is mostly directed at the expense of myself.

So if you are attending DATA:Scotland all that's left is for me to beg, plead, perhaps even bribe you to come along to my session; if you choose otherwise I'll not hold it against you...and if you're not attending but stumbled on to this post by accident then thanks for reading if you got this far!

Blogging and Burnout

A short time ago I called it a day on my blog SQL Clarity - the blog is still there as I'd say there's a few interesting reads on there, although clearly I'm biased. I'm not entirely surprised that it didn't take too long for me to start blogging again, so here I am with a revitalised approach to blogging and a brand new blog too.

I covered the "why I stopped blogging" in the last post on there but actually looking back that was the tip of the iceberg. In short I was juggling way too many things and heading towards burnout and a few things definitely had to give.

Now I could go on and write a piece about burnout (as the title may have led you to believe) but as it happens there's an excellent article wrote by Kendra Little that for me really hit home and provides some seriously sound advice too. I recommend that absolutely everyone gives it a read.

Over the last couple of months I've had some time away, enlisted some help on the consultancy side of things and refocused my efforts on where they needed to be. I cannot emphasise just how much a complete step back has helped even though at times it's seemed like it's completely the wrong thing to do, again - read the link above.

I started a brand new blog because I wanted something a bit different this time. SQL Clarity had lots of aims at the beginning and some were achieved but some definitely got lost along the way. With that in mind this blog isn't aiming to do that much (I know, I'm selling it well) beyond putting down my thoughts and experiences as I go along with whatever I'm doing.

In September this year (Friday the 13th, typical)  I'm speaking at DATA:Scotland which is my first time speaking at a conference. I've really felt compelled to write about this experience so I'll definitely be putting up posts about this in the near future and in many ways this has twisted my arm into blogging again...but not in a bad way!

I'd also like to say a thank you to my mentor for the conference which as I'm a first time speaker I get to spend time with. I'm not sure if we can "go public" so I'm going to call them Person X, which I actually kind of like and might stick with from now on. Speaking to them has been so useful (even though I've been stretched for time admittedly) but their input has helped way beyond the presentation and for that I am very thankful.

And on that note, I'm calling it a day - for this particular article. Extended thanks to anyone who reads this and until the next time, take care.