Vol. 23, #27 - July 09, 2018 - Issue #1189
WServerNews: Spotlight on SQL Server
- Editor's Corner
- Ask Our Readers - Need a better patch management solution (new item)
- Ask Our Readers - Authenticated NTP and security (one more response)
- Ask Our Readers! - Need help from the IT pro community?
- SQL Server gets its own YouTube channel
- What can you do when your SQL Server runs slow?
- Running SQL Server on Linux
- Safeguarding data with SQL Server
- Provisioning SQL Server instances using Docker
- Send us your feedback
- NEW!! - The Book Corner
- Featured TechGenix article
- Factoid of the Week - The growing problem of e-waste
- Admin Toolbox
- Admin Tools We Think You Shouldn't Be Without
- This Week's Tips
- SQL Server - First Responder Kit
- Office 365 - Changes coming to Exchange Web Services
- Azure - Securing your infrastructure
- Events Calendar
- More upcoming events
- New on TechGenix.com
- Recommended articles from TechGenix.com
- Tech Briefing - SQL Server
- Even More SQL Server Features that Time Forgot
- Management Studio Hides Missing Indexes From You
- Power BI Introduction: Tour of Power BI - Part 1
- Does It Matter Which Field Goes First in an Index?
- SQL Server Closure Tables
- Other Articles of Interest
- Tips and tools to give AWS network performance a jolt
- How to install Maven and build apps with the mvn command line
- How a SaaS provider made microservices deployment safely chaotic
- Cloud billing APIs enable greater cost transparency
- WServerNews FAVE Links
- Australian Beer Magic - Dom Chambers
- Magicians Penn And Teller Give a Lesson in Misdirection
- British Female Aerobatic Pilot - Amelie Windel
- 'Permission' - Comedy
- WServerNews - Product of the Week
- Ransomware resilience: next level backup repository hardening
- SAVE THIS NEWSLETTER so you can refer back to it later for helpful tips, tools and resources!
- SEND YOUR FEEDBACK to [email protected] if you have any comments or suggestions!
This week we shine our spotlight on Microsoft SQL Server with news, tools, and tips for readers who work with the product. And if that's not you then please forward this issue of WServerNews to any colleagues you know who work with SQL Server and suggest they subscribe to our newsletter! To subscribe to WServerNews and other great newsletters from TechGenix, simply go here:
This week we also have a new Ask Our Readers question a reader needs help with. And we're also introducing a brand new section in our newsletter called The Book Corner where Yours Truly will provide you with short reviews of some of the IT, dev, and other technical books He's been reading recently and which He thinks some of You might be interested in reading. Plus we have lots of other stuff for you as well, so enjoy!
As some of you may know from experience, writing a book isn't easy. Getting your book published however can be even harder! In fact, most successful authors could probably paper the walls of their living rooms with the rejection slips they received from publishers when they first started out writing. How do publishers feel about sending out such rejection slips? Let's listen as Dogbert reveals the dark side of the book publishing industry:
Ask Our Readers - Need a better patch management solution (new item)
Marques the Director for Systems and Data of a company in Brooklyn, New York USA sent us the following question seeking help from our readership:
Hi, I work for a non-profit and we have a number of virtual and physical machines that need to be patched on a regular basis. We formerly used Kaseya to manage patching for our servers (just like our end user computers) but found that it wasn't smart enough to know how to properly patch and restart certain groups of computer (i.e. servers 1 , 2 and 3 need to be shutdown and restarted in a certain order). We are also leveraging some hyperVs that also need to be patched as well on a regular basis.
Does the community have any suggestions for software that could potentially help in this situation? Currently, the patching process is manual and thus not consistent. Thanks!
Can any readers help? Email us at [email protected]
Ask Our Readers - Authenticated NTP and security (one more response)
Two weeks ago we published this question from a reader named Johnny:
Do you have any experience and thoughts about NTP and security risks? For example, what is outlined here:
Have you also had experience or know about someone using the NIST authenticated service:
I would appreciate your reply. I cannot find a set guidance/best practices and concrete ways to go about it. Thanks in advance.
A reader named Mark responds as follows:
One option, if security is a real concern, is to skip NIST or any other internet based source altogether. There are a few vendors of devices you can add to your network that use GPS signals to set their clocks. Essentially it is a GPS NTP server local to the site.
Mark also provided links to a couple of GPS NTP device vendors and you can find these in the Admin Toolbox section of this week's newsletter.
Ask Our Readers! - Need help from the IT pro community?
WServerNews goes out each week to more than 500,000 subscribers worldwide! That's a lot of expertise to tap into. Do you need help with some issue or need advice on something IT-related? Got a question you'd like us to toss out to our readers to try and answer? Email us at [email protected]
And now on to the main topic of this week's newsletter…
SQL Server gets its own YouTube channel
SQL Server fans might not be aware of it but about a month ago Microsoft launched a new YouTube channel that's entirely devoted to their SQL Server product line. You'll find videos on SQL Server performance, security, high availability, machine learning, and more. Plus you can learn about running SQL Server on Linux or in the cloud. And you can learn about the new features of SQL Server 2017 the latest incarnation of the product. Check it out:
What can you do when your
Brent Ozar has put together an excellent video that provides a sequence of steps you can follow to try and discover the root cause why your SQL Server is running slow. Watch it here on his blog:
Running SQL Server on Linux
Did you know you can now run SQL Server on Linux? The SQL Server Team at Microsoft has released a free ebook titled SQL Server on Linux: A guide to re-platforming and modernizing your data workloads. You can get the ebook from a link in this post on the SQL Server Blog:
Hmm, I still have Linux running on an old dust-covered 386 machine running somewhere in my basement. I wonder if I can run SQL Server 2017 on it?
Safeguarding data with SQL Server
Brian Kelly an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security has recently published an article titled Principles of Data Protection that discusses what you can do from an SQL Server perspective to safeguard sensitive data.
Provisioning SQL Server instances using Docker
Starting with SQL Server 2017 you can now run SQL Server instances in Docker containers. Laerte Junior explains how you can get started doing this:
Send us your feedback
Got feedback about anything in this issue of WServerNews? Email us at [email protected]
NEW!! - The Book Corner
Mastering Modern Linux, Second Edition (CRC Press)
This updated version of the excellent book from CRC Press provides a comprehensive introduction to the Linux platform as it is today. Starting with a primer on what Linux is all about, the book moves through core topics like managing the file system, configuring networking protocols, implementing cryptography, setting up Apache web servers, managing users, setting up the Gnome desktop environment, writing BASH scripts, and performing various other system administration tasks. These topics are all well covered with text and examples that are invariably clear and to the point.
The book then starts diving into deeper topics by covering the GCC compiler and C library for those who want to learn how to do C programming in Linux. I/O, system calls, and inter-process communications are then covered in great detail and illustrated with many code examples.
Chapters are well-written and organized and end with a series of exercises that let you test your understanding and knowledge. The website for the book also has a series of additional appendices covering various topics like setting up SSH and using vim. The website also lets you download the code samples from the book which makes it easy to explore the scripting and programming topics the book covers.
While the book assumes no prior experience with Linux, reading it will require a certain self-discipline and attitude on the part of the learner. That's because the book is intended as a textbook for a one-semester university-level course in Linux. So if you're an IT pro who has a university degree then the approach the book uses will likely benefit you and facilitate learning. But if you've never gone to university you might find the way the book is written a bit dry, sort of like one of those old Linux books from O'Reilly but without the funny animal on the cover. Personally I like dry because it gets to the point quickly instead of meandering around and wasting my time. And time is a very precious commodity as far as IT pros like us are concerned!
The verdict: Buy this book if you're interested in learning Linux and are willing to dedicate the time to learning it properly.
Featured TechGenix article
This week we're featuring the following article published on our TechGenix website:
Review of SolarWinds Traceroute NG
SolarWinds recently released their own version of Tracert which they call Traceroute NG. TechGenix author Brien Posey recently reviewed this product to find out how it can benefit IT pros who are already accustomed to using the built-in Tracert utility:
The reason I chose to feature this article is because I have a lot of experience troubleshooting network problems, so I'm always on the lookout for good tools. And if you have any network troubleshooting tools you rely upon and would like to recommend to our readers, email me at [email protected]
Factoid of the Week - The growing problem of e-waste
Last week's factoid and question was this:
There are more Australian bees in Canada than there are Canadian people in the world. So what does it feel like to be stung by a bee?
Golly, no one responded to that one. Maybe IT pros are immune to bee venom?
Here is this week's factoid:
Fact: The United Nations found that people generated 44.7 million metric tons of e-waste globally in 2016, and expects that to grow to 52.2 million metric tons by 2021.
Question: On a scale of 1 to 10 how serious would you rate this problem compared to other things about "life, the universe, and all that" that keeps you awake at night?
Email your answer to us at [email protected]
Until next week,
GOT ADMIN TOOLS or other software/hardware you'd like to recommend? Email us at [email protected]
Join live session to see new features from Microsoft that can take hardening your Veeam backup repository to the next level.
Put your mind at rest with Altaro VM Backup. Excellent performance & powerful features to meet your disaster recovery needs. Download a 30-day trial now for unlimited VMs & get 2 FOREVER FREE VMs!
Spectracom provides time and frequency references and systems for precision timing in your networking environment:
TimeTools provides a variety of GPS referenced stratum-1 NTP servers to meet the precision timekeeping needs of different-sized organizations:
SQL Scripts Manager contains 28 scripts written by expert DBAs, SQL Server MVPs, and Redgate's SQL developers. And it's free!
SQL Server - First Responder Kit
Brent Ozar Unlimited has put together a free First Responder Kit for SQL Server administrators that's packed with scripts, worksheets, and checklists you can use to make your job easier. Get it here:
Office 365 - Changes coming to Exchange Web Services
You Had Me At EHLO the official blog of the Microsoft Exchange Team has posted an announcement concerning the changes coming soon to the Exchange Web Services (EWS) API for Office 365:
Microsoft Inspire in Las Vegas, Nevada on July 15-19
Microsoft Ignite 2018 on September 24-28, 2018 in Orlando, Florida USA
Add Your Event
PLANNING A CONFERENCE OR OTHER EVENT you'd like to tell our 100,000 subscribers about? Contact [email protected]
U.S. Supreme Court decision on mobile location data a boost for privacy protection
Privacy protection in the United States received a needed boost as a result of a recent Supreme Court decision that limits the data the government can collect.
Shedding light on shadow IT: Yes, it's a problem - except when it's not
Shadow IT is viewed by many businesses as a problem because it indicates a loss of control over what technologies users have access to. But is this always a bad
No-nonsense guide to cloud computing benefits for your business
Moving to the cloud brings with it a ton of advantages, including reliability, flexibility, agility, and scalability. These cloud computing benefits can transform your business.
Microsoft unveils new SharePoint innovations, including AI and mixed reality
At its recent SharePoint Virtual Summit, Microsoft revealed several new SharePoint innovations that expand the functionality of the popular platform.
Are you GDPR compliant? Find out here, because what you don't know will cost you big time
GDPR, with its 11 chapters and 91 articles, is the most comprehensive data protection modification in two decades. Is your company GDPR compliant? This guide will help you know.
Even More SQL Server Features that Time Forgot
Management Studio Hides Missing Indexes From You
Power BI Introduction: Tour of Power BI - Part 1
Does It Matter Which Field Goes First in an Index?
SQL Server Closure Tables
Tips and tools to give AWS network performance a jolt
Don't wait for network performance to lag to do something about it. Proactively monitor AWS workloads to identify troublesome areas that can disrupt the end-user experience.
How to install Maven and build apps with the mvn command line
If you want to learn Maven and become a build master, the first step is to install Maven, and the second is to use the mvn command-line tool to compile and package Java apps.
How a SaaS provider made microservices deployment safely chaotic
This organization was blindsided by performance issues with its microservices-based SaaS, until the company decided to sabotage its own product – at scheduled times, in staging – with a different kind of test.
Cloud billing APIs enable greater cost transparency
No enterprise wants to be surprised by its cloud computing bill. And, even as providers offer more visibility into users' costs through APIs and other tools, obstacles remain.
This Week's Links We Like. Tips, Hints And Fun Stuff
GOT FUN VIDEOS or other fun links to suggest you'd like to recommend? Email us at [email protected]
Award-winning magician and comedian Dom Chambers is famous for his world-class sleight-of-hand combined with his cheeky wit:
Magicians Penn And Teller Give a Lesson in Misdirection
Penn and Teller impress Jimmy and the Tonight Show audience with a vanishing chicken and a lot of misdirection:
British Female Aerobatic Pilot - Amelie Windel
Amazing aerobatic flying by Amelie Windel - one of the youngest aerobatic pilots in Europe:
'Permission' - Comedy
This funny video will make you laugh. 'Success' is such a smart kid. Amazing!
Ransomware resilience: next level backup repository hardening
WServerNews - Editors
Mitch Tulloch is Senior Editor of WServerNews and is a widely recognized expert on Windows administration, deployment and virtualization. Mitch was lead author of the bestselling Windows 7www.mtit.com.Resource Kit and has been author or series editor for almost fifty books mostly published by Microsoft Press. Mitch is also a ten-time recipient of Microsoft's Most Valuable Professional (MVP) award for his outstanding contributions in support of the global IT pro community. Mitch owns and runs an information technology content development business based in Winnipeg, Canada. For more information see
Ingrid Tulloch is Associate Editor of WServerNews and was co-author of the Microsoft Encyclopedia of Networking from Microsoft Press. Ingrid is also manages research and marketing for our content development business and has co-developed university-level courses in Information Security Management for a Masters of Business Administration program.