This is part of my series on building a virtual lab for use with SQL Server and Windows. You can see the entire series here: Building a Virtual Lab with Hyper-V.
The whole point of virtualization is better use of resources. Whether it’s CPU, storage, networking, power, etc., we… Read more
I needed to get this one on Hyper-V, so I decided to document the process. I’ve put together a series that looks at the steps I took.
- Virtual Lab – Design and Setup
- Differencing Disks
- Setting up a new VM
- Adapter Setup
- The Domain
- New Domain User
- SQL Server
This… Read more
It’s T-SQL Tuesday time again and Jason Brimhall is hosting this month’s event. He used to live in Las Vegas, and with that theme in mind, he calls for you to Place Your Bets. That’s a time when someone has gambled, or risked something on an application, venture, process… Read more
This is part of a series where I set up a virtual lab for testing and misc work. The other parts in the series are here: Building a Virtual Lab with Hyper-V.
I haven’t had a good lab set up since I moved from VMWare to Hyper-V on my… Read more
SQL Intersection is coming to Orlando in April, along with the rest of the Dev Intersection events the week of the 13-16th. I’ll be there speaking, along with an amazing lineup of other SQL Server experts. The SQLskills crew is headline and organizing the event and I’m looking forward to… Read more
Jobs are important, mostly because running stuff interactively, and manually, is a pain. The real power of PoSh administration, in my… Read more
Day 14 introduces us to Windows Management Instrumentation (WMI). Since many people might not be familiar with WMI, the chapter spends… Read more
I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of anything. It looked cumbersome, I didn’t always understand how sample scripts worked, and it was just easier to use the various other Windows tools to accomplish tasks.
However as… Read more
There are free systems out there. If you have no budget, and want to get started, download one of these:
- Subversion: http://subversion.tigris.org
There are good ones to pay for as well, and some of them have other features and integration you may like:
- Team Foundation Server…
Remoting. It sounds complex, and intimidating. It isn’t, and it’s powerful. It’s also essential, allowing you to access commands on remove… Read more
This chapter is a practical one. Build a scheduled task that removes all jobs from a certain printer. Not that hard,… Read more
This is a fairly simple thing to do, but I had to look it up the other day and thought it would make a good blog. This is a good example of a blog that everyone should write to show they know a particular skill.
TL;DR: Use a comma between… Read more
I’ve learned that the dash (-) is going to be my friend. Filtering and comparisons are the backbone of SQL. We… Read more
I saw this as a problem recently from someone and thought it would make a good post. As I was building a quick solution, someone else posted theirs, but I decided to save mine as a blog post. It was a good, quick, T-SQL exercise for me to work on. Read more
My first flight of 2014 will be to Cleveland to run a SQL in the City seminar and then speak at SQL Saturday #241. Both are free events, taking place on February 7th and 8th, respectively, and it’s a great chance for you to improve your SQL Server skills,… Read more
It’s a little less than two weeks until SQL Saturday #271 – Albuquerque. The second event in that great city, and the beautiful state of New Mexico. I rarely get there now that my brother moved away, but’s always neat to visit.
I was lucky enough to get chosen… Read more
I missed last month and I was a bit sad, but I was traveling the week before and speaking, and then was on vacation. No time to write a post, and it was a tough topic from Robert Davis. However I’m back this month, and I’m thrilled to participate in… Read more