Videos about Microsoft SQL Server, Excel, and much more – for way less than $30
Find out more about the SQL Server 101 Podcast. In Episode 7 of the SQL Server 101 podcast, we look at the following topics: Strings In a previous podcast, we tried to add a string to a numeric field, and found that it didn’t work. In this section, we’ll have a look at the two different main versions, CHAR and NCHAR, […]
Read moreFind out more about the SQL Server 101 Podcast. In Episode 11 of the SQL Server 101 podcast, we look at the following topics: Creation of the Employee Table In the previous few podcasts, we learned all about the different data types, whether they be number, string or date. Now that we know all about these, we can now create […]
Read moreFind out more about the Excel in Office podcast. In Episode 17 of the Excel in Office podcast, we look at the following topics: Applying Number format Numbers can have colors and fonts, but there are many different other ways that numbers can be formatted: number, currency, accounting, date, time, percentage, fraction, scientific, text and special. We’ll have a look […]
Read moreHello. 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 more70-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 moreLearn 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 moreEpisode 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 moreHow accessible is your data? All of it. How quickly can you access your data? If we are talking about your current data, such as your Word documents and project files, then presumably you can access it very quickly. (However, how quickly can you find documents using Word metadata or photographs taken on a particular date?) What about your other ESI data? […]
Read moreInformation putting data into context can be essential, especially if the amount of data involved is huge. As I have written elsewhere, it is often the first step in investigating a huge data set. According to the judge in LLC v Kaplan, the “Plantiff produced a hard drive containing 822,493 pages of email communications”. Reading between the lines, it seemed […]
Read more