Videos about Microsoft SQL Server, Excel, and much more – for way less than $30
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 moreIntroduction Previous articles in this series talked about how to see how newly received files were filed, how to look at their date range and types of files, and the specifics about managing Word, Excel and PowerPoint documents. This article will discuss the proliferation of photographs, and how to harness the hidden data contained within (and why you would want […]
Read moreIntroduction In previous articles, I talked about cataloguing a new hard drive, USB memory stick or network, and discussed approaches for investigating the file structure, the type of files, and the date ranges. In this fourth article I will be discussing in particular Microsoft Office files, namely MS Word, MS Excel and MS PowerPoint. I will be dealing with emails […]
Read moreIn the recent case of Willett v Redflex Traffic Systems Inc., the defendants stated that it had scanned and searched what is called “a high-level directory of the data”, and that it produced a spreadsheet of this directory. This spreadsheet had 538,000 rows, and it includes the following information: File name, File Type, File Size, Creation date, and Last Modified […]
Read moreOne of my other interests is that of SQL Server. As a Microsoft Certified Solutions Associate: SQL Server 2012, I have prepared for and taken (and passed!): exam 70-461, Querying Microsoft SQL Server 2012, exam 70-462, Administering Microsoft SQL Server 2012 Databases, and exam 70-463, Implementing a Data Warehouse with Microsoft SQL Server 2012. These exams test your proficiency for T-SQL, DBA and ETL. […]
Read moreIntroduction The first article of this series shows how to catalog files and folders using Power Query. Now that you know the mechanism as to how to do it, this article discusses whether you should do so, looking at the advantages and disadvantages. Advantages of using Power Query Firstly, Power Query is free. You can download it from the Microsoft […]
Read moreIntroduction This is the first of three articles about an add-in for Microsoft Excel called “Power Query”. Among other features, it allows files and folders to be cataloged from within Microsoft Excel. (It also does other things, which are perhaps what it is more used for.) This article shows the process where files can be listed. It walks through each […]
Read moreIntroduction In the previous two articles in this series, I discussed scenarios when you might suddenly have a lot of new data to investigate, and how to efficiently view the folder tree and create analyses based on the file type. In this article, I will discuss another important property for initially investigating your new files – the date range of […]
Read moreThis is the second of a series of articles which concern how best to investigate tens of thousands of files that you are seeing for the first time. The previous article addressed when that might occur, and how to examine and export the folder structure so you can start to understand it. This article addresses how to look at the […]
Read moreIf you want to download random documents, such as Microsoft Word, as used in the articles “What document properties are actually used in .doc/.docx files“, then go to Google and click on Advanced Search. Unfortunately, the location of Advanced Search changes according to which version of Google you are using. One way is to do a search, and click on […]
Read more