Author Archives: Robert

Errata for my book on Querying data with Transact-SQL (MCSA 70-761)

If you find any errors in the book, please let me know. This will help not only myself, but also other readers.

Posted in MCSA SQL 2016 70-761 | 5 Comments

Screenshots of tables

This gallery contains 5 photos.

It appears that on some Kindle devices, it is hard to read the tables. Therefore, on request, I’ve put the screenshots of the tables here. Tip: you can also read the eBook on Amazon Cloud Reader (https://read.amazon.com)    

More Galleries | Leave a comment

Insert object in Word document with Powershell

At times, you have to create reports in Word format. If these are reports you have to create on a regular basis, you’ll want to automate this as much as possible. There is a lot you can do to automate … Continue reading

Posted in Code samples, Powershell | Leave a comment

Installing SQL Server 2008 R2

This video demonstrates the installation for SQL Server 2008 R2. It is supporting material for my eBook on Database Fundamentals, which covers the Microsoft MTA 98-364 exam. In this video, I explain the installation process step by step. The purpose of … Continue reading

Posted in MTA 98-364 | Leave a comment

Does the Powershell command Restart-Service -force restart dependent services?

This could be my shortest post ever, with a simple “yes”, but let me elaborate. At times, you have to restart a service. With Powershell, this is easy enough (provided you have the right permissions): Restart-Service -name will do the … Continue reading

Posted in Powershell, Uncategorized | Leave a comment

My book on Database Fundamentals is now available!

Finally, I’ve finished my book on the Microsoft Technology Associate 98-364 exam: Database Fundamentals. It’s available in the iTunes book store: https://itunes.apple.com/us/book/id1043228558 I decided to make it an iBook, since this format provides a combination of text, screenshots, screencasts and interactive test … Continue reading

Posted in MTA 98-364 | 7 Comments

How to create a list of installed SQL Server instances on a cluster

On a normal server, there are several Powershell ways to get a list of all installed SQL instances. Probably the most straightforward way is to query the registry:

You can subsequently use the output to query all instances on … Continue reading

Posted in Powershell | Leave a comment

Powershell disk inventory

Every now and then, I have to tackle a performance problem on a SQL Server I’ve never seen before. One of the things I’ll be looking for is the block size of the disks. The block size for drives containing … Continue reading

Posted in Performance, Powershell | Leave a comment

Code samples for my book on Database Fundamentals (MTA 98-364), chapter 4

 

Posted in Code samples, MTA 98-364 | Leave a comment

Creating a virtual machine with Vboxmanage

Lately, I’ve been creating, deleting and recreating a lot of virtual machines with Oracle VirtualBox. So today, when I needed to start with a clean environment, I decided to create a virtual machine using the command line instead of the … Continue reading

Posted in Uncategorized | 1 Comment