Archive | SQL RSS feed for this section

Adding Shortcuts to the Windows 8 Start Menu

One of the main concerns with the Windows 8 Start Menu is that it changed the end user experience and software behavior that people had gotten used to with Windows. Last week, my article discussed how you can navigate easier with Windows key shortcuts, like using the Windows+X. (As seen below) In addition to using […]

Leave a comment Continue Reading →

Navigating easier with the Windows 8.1 Start Menu

Windows 8/Server 2012 changed the way, user interacted with the desktop and safe to say at this point, a lot of people were unhappy with the new design. Personally, I feel it is a shame, because I feel that Windows 8/Server 2012 is the best operating system that Microsoft has released to date. I am […]

1 Comment Continue Reading →

Types of MSSQL Joins

In Microsoft SQL Server, we have four types of joins. We use these joins to fetch data from multiple tables that are based on a condition. A join condition is a relationship among some columns in the data tables that take part in SQL join. Basically data tables are related to each other with keys. […]

Leave a comment Continue Reading →

Language components of Structured Query Language (SQL)

Recently, I have been working on improving my querying ability in Microsoft SQL and have been reading Itzik Ben-Gan’s book. I thought I had written this topic in an earlier and to my surprise I was wrong. A good fundamental bit of information to know as I progress through data structures and the language used to […]

Leave a comment Continue Reading →

Hardware Changes in Windows 2012 RS VM’s

I have been reading a few of the latest Ebooks from Microsoft press lately: Introducing Windows Server 2012 R2 Introducing Windows Azure for IT Professionals In this book, I felt it gave one of the better summaries of the new changes with Hyper-V and I am just copying a section from them as seen below. […]

Leave a comment Continue Reading →

Video: Installing Tracetcp, Tcping, WireShark and PortQry

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 … This is the last of a four part series on networking troubleshooting: […]

3 Comments Continue Reading →

Video: WireShark Network Capture

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 … This is part three of a four part series on networking troubleshooting: […]

Leave a comment Continue Reading →

Video: Name Resolution and Port Queries

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 … This is part two of a four part series on networking troubleshooting: […]

Leave a comment Continue Reading →

Video: Using Tracetcp versus Tracert

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 … This is part one of a four part series on networking troubleshooting: […]

3 Comments Continue Reading →

HOW TO: Deploy Windows 8.1 via WINPE USB Disk

Recently, I had to create a custom image and I was pleasantly surprised with the way it turned out. It allowed me to shave 3 hours off an installation, so I could deploy a standard image to workstations. This is part three of a three part series that will detail how to perform the following […]

1 Comment Continue Reading →
Copy Protected by Chetans WP-Copyprotect.