Author Archives: Phillip Burton

Using MATCH and INDEX

Hello. This article is about looking up values in Excel. Balaji asks: How can I create a Query that displays maximum value in one column and the date corresponding to the maximum value in the adjacent column ?   There are several ways to do this. In this video, I will have a look at the MATCH and INDEX formulas to solve […]

Read more

SQL Server video course – Session 1

70-461 Session 1: Querying Microsoft SQL Server 2012 About This Course This course is the foundation for the Microsoft Certificate 70-461: “Querying Microsoft SQL Server 2012″. Rather than present one huge course, this course takes some of the basics and then goes in depth. The basics presented are: how to install SQL Server, and how to create and drop tables. […]

Read more

SQL Server videos

Learn SQL Server by watching videos Having a certification in SQL Server can be advantageous to your career, but there’s a lot to concentrate on. Where do you start? What would Microsoft want you to learn? Well, Microsoft has an examination about T-SQL, the language about adding data to and retrieving information from SQL Server. It is called “70-461 Querying […]

Read more

WDW Today

Episode 1426 – Buy Or Sell Episode 1425 – December 2014 Preview Episode 1424 – Listener Questions Episode 1423 – Attraction Mashups Episode 1422 – Toddlers And Tweens Episode 1421 – Listener Questions Episode 1420 – Mickey’s Very Merry Christmas Party 2014 Preview Episode 1419 – Once Upon A Time Episode 1418 – Listener Questions Episode 1417 – Looking Forward […]

Read more

How to explore newly received emails

Introduction In our previous five articles, we talked about initial investigations for data that you have just received, whether it be by: walking through the filing structure, investigating the files’ dates, seeing how many different types of files there are, looking at Word, Excel and Power document properties, and examining photograph metadata. In this article, we will be looking at […]

Read more
1 2 3 9