page contents
Archive | SQLServerPedia Syndication RSS feed for this section

PowerShell Basics: Using Variables

Variables are a fundamental part of Windows PowerShell. They’re quite different from the variables in Cmd.exe. In Cmd.exe, all variables are environment variables, which you primarily access with the Set command. The environment variables can store only strings of text. (You can store a number in an environment variable, but it’s up to the program […]

2 Comments Continue Reading →

What is the different between Classful and Classless Routing?

I have been preparing to take my last part of my CCNA test later this month, which is ICND2. It goes over a lot of topics, such as routing protocols, VLANs, spanning tree and a lot of troubleshooting. One of the topics involves classful and classless routing as it relates to VLSM (variable length subnet masks) […]

1 Comment Continue Reading →

IOS Command Reference

Router Basic Configuration •    Router> enable (enter privileged mode) •    Router# configure terminal •    Router(config)# hostname R1 •    R1(config)# banner motd # message of the day # •    Setting passwords: •    R1(config)# enable secret password •    R1(config)# line console 0 •    R1(config-line)# password password •    R1(config-line)# login •    R1(config)# line vty 0 4 •    R1(config-line)# password password •    R1(config-line)# login •    Gathering Router Info: •    R1# show version •    R1# […]

Comments Off on IOS Command Reference Continue Reading →

How does Instant File Initialization Help Your Databases?

In an earlier article, I spoke about a Best Practice called File Initialization. I walk you through setting it up I pointed you to a blog by Kimberly Tripp. Today, I want to show you how much time it will save you. I know this may seem like a silly question, but don’t you want […]

1 Comment Continue Reading →

List of Windows OS Version Numbers

I was watching a video and saw someone open a command prompt to issue a netstat to check on current TCP connections. I noticed the version number and suspected that this was Windows Vista: It turns out that I was correct with my guess that it was Windows Vista, but I decided to put together a […]

Comments Off on List of Windows OS Version Numbers Continue Reading →

Navigating the Start Menu in Windows 8 and Server 2012

Here is the new Windows 8 Menu that people are both not happy with and also trying to figure out how to use. I have written a few articles about the new start menu in Windows 8/Server 2012. (As seen below) Today I wanted to write another article to help people navigate through this new […]

Comments Off on Navigating the Start Menu in Windows 8 and Server 2012 Continue Reading →

Video: VPC Concepts

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. This video is almost 2 hours long. Loading the player … Notes for VPC Concepts: The […]

3 Comments Continue Reading →

PowerShell Script to create a Shutdown/Restart/Logoff Windows 8 Tile for the Start menu

One of my more popular articles on this site, is the Finding the Start Menu in Windows Server 2012. It walks you through the basic changes of the new start menu. Most of the complaints that I have heard is that it hard to quickly reboot, shutdown or logoff a system or it is hard […]

3 Comments Continue Reading →

HOW TO: Enable Windows Key on Logitech G510 Keyboard

I switched to a new keyboard recently (G510 keyboard) and noticed that the Windows Key no longer worked. On Windows 7, this was not such a big deal, but on my Windows 8 installations it was starting to become very annoying. To make matter worse when I searched for it via Microsoft support forums none […]

1 Comment Continue Reading →

HOW TO: Find the Physical host of a VM in Hyper-V

With the rising popularity of virtual machines, you may find yourself one day logging into a server troubleshooting an issue. Then all of a sudden it occurs to you that you are not sure if this machine is Physical or Virtual. Better yet you know this is a VM, but you are not sure which […]

2 Comments Continue Reading →

HOW TO: Make Symbols With The Keyboard

Have you ever wondered how to create all of those special characters called symbols? Well, today you are in luck. J This chart is broken into 3 sections… Keys to press…. What it will generate…. Notes to clarify what you just typed. Without further ado, here is the list of symbols: Alt + 0153….. â„¢… […]

Comments Off on HOW TO: Make Symbols With The Keyboard Continue Reading →

Huge collection of Free Microsoft eBooks (2013 Update)

Eric Ligman is a Microsoft Sales Excellence Program Manager and he just posted (today) a very helpful article on his blog. Last year, he listed a series of free Microsoft eBooks and he decided to update it again for this year. What I really like about both of his list of free books is that […]

Comments Off on Huge collection of Free Microsoft eBooks (2013 Update) Continue Reading →

IPv4 SubNetting Cheat Sheet

Lately, I have been reading CCNA 640-802 Official Cert Library by Wendell Odom (a lot) as I am preparing to take my exam in a few months. It is a lot of information to know and the exam covers a lot of information, it is like CompTIA’s Network+ test, but it adds more content to master. […]

3 Comments Continue Reading →

Video: AWS ELB Sticky Sessions Explained

The information provided in this video is meant as a tutorial. It is not the final word on security or setup for your particular case. In Simpler terms: USE at your own risk. That said, I hope it helps. Loading the player …

Comments Off on Video: AWS ELB Sticky Sessions Explained Continue Reading →

HOW TO: Migrate an AWS Image (AMI) to another region

When I used to work at Amazon Web Services (AWS) one of the pain points was the ability to migrate your fault tolerant strategies to another region. Amazon had these great technologies to help you fail away from trouble areas. A great overview of these strategies is in a video, that I did last year, which […]

12 Comments Continue Reading →

Hyper-V limits with Windows Server 2012

As stated in an early article of mine, there is a great free book from Microsoft Press that talks in good depth about Windows Server 2012. Today, I wanted to share some of the information that I learned from that book. (Limits and new features) Here is a simple comparison of the different limits between Windows Server 2008 R2, Windows Server 2012 Release Candidate 1 […]

Comments Off on Hyper-V limits with Windows Server 2012 Continue Reading →

HOW TO: Go from Minimal Interface to CORE in Server 2012

In my last article, I spoke about a new cool feature of Windows Server 2012. The ability to go from a server GUI to Server CORE (or vice versa) without having to re-install the Operating System! You may ask yourself, “Why would I care about that?” To be blunt, Server CORE is very similar to the way most Linux […]

1 Comment Continue Reading →

HOW TO: Go from GUI to CORE and back to GUI in Server 2012

I have been preparing to upgrade my Windows and SQL certifications for 2012. I was checking out an article on switching from Server GUI to Server core. This article was written for Windows Server 8 Beta and was called How to Turn the GUI Off and On in Windows Server 2012. It gave me the […]

2 Comments Continue Reading →

Improvements with SQL Server 2012 SP1 CU2 and Sysprep

Good news came out earlier this month when Microsoft released Cumulative update package 2 (CU2) for SQL Server 2012 Service Pack 1. It can be downloaded here and if you are new to CU packages, there are not like a regular Service pack or Windows update. These CU fixes are not as tested as regular […]

Comments Off on Improvements with SQL Server 2012 SP1 CU2 and Sysprep Continue Reading →

Troubleshooting a SCVMM 2012 transport error

Last week, I had someone reach out to me asking for help with a new SCVMM 2012 server. It was a new installation and for the most part it worked well for them during the past month. However, recently they started seeing the error below, which prevent them access to the Virtual Machine Manager: At […]

Comments Off on Troubleshooting a SCVMM 2012 transport error Continue Reading →
Copy Protected by Chetan's WP-Copyprotect.