Continuing my 2017 series on unattended Microsoft SQL installs, this post will cover SQL 2016 on Windows Server 2012 R2. If you want the unattended install for SQL 2012, check out my post here or for SQL 2014, go here. I’m using the same drive configuration for SQL 2016, as...
Continuing my 2017 series on unattended Microsoft SQL installs, this post will cover SQL 2014 on Windows Server 2012 R2. If you want the unattended install for SQL 2012, check out my post here. I'm using the same drive configuration for SQL 2014, as I did for 2012. These drives...
A few years ago I wrote a blog post detailing an unattended SQL 2012 installation process. That article needs a bit of updating, so I'm creating a fresh post. I will also follow up on this post with SQL 2014 and SQL 2016. This time around I'm using Windows Server...
As you know if you've been following my blog this week, Ignite 2015 took place in Chicago with hundreds of great sessions. In fact, this year all but one or two sessions were spot on. You can easily download all of the great Channel 9 recordings using the PowerShell script...
Session: BRK3130 Note: This was a great beginner level session for those not familiar with encryption, certificates or PKI. If you are in that boat, I would urge you to find the session video and watch the whole presentation. If you are a security professional and already know about these...
Session: BRK2324 Shared secrets are easily breached Passwords are easily replayed and phished See previous "Microsoft Passport" session I blogged about for more info Security without convenience is dead in the water Keys are ideally generated in hardware TPM, software as last resort Single unlock gesture provides access to multiple...
Session: BRK3557: Baselining and Benchmarking AlwaysOn Availability Groups In this session the speaker went through what SQL AlwaysOn availability groups is, and why the customer wanted to use it. Then he went through how he setup his testing, RAID levels, and listed the SQL perform stats that he monitored during...
Session: BRK3455 Note: This session had very densely packed slides and lots of demos. So I've changed things up and just included screenshots for this write up. If you want to run Nano I encourage you to check out the video recording to see all of the demos. Voice of...
Session: BRK3487 Note: This session was jam packed with slides, text, and diagrams. The speaker was also flying through the material, so it was impossible to attempt to keep up. The session was very good, and quite technical. So if you deal with clustering in your daily job, check out...
Session: BRK2473 Note: This session was 50% about what's new in VMM 2012 R2, with 15-20 minutes on what's new in VMM 2016. My take away is that MS is trying to listen to customers and make the product easier to use. But don't expect any radical changes in VMM...