Have you ever wanted a query that would give you a list of all the indexes that exist in your database along with details of the index type and all the columns that are a part of the index key and all included columns?
Well have a look at this query. It might help:
In this article “Excel is more than a calculator! - Part 2” we will be looking at Pivot Tables, Pivot Charts and Filters. If you have never used these before prepare to be impressed!
Pivot Tables and Pivot Charts enable you to explore your data and analyse business measurements in different ways, for example:
We have now introduced a new entry level Microsoft Office course “Introduction to Microsoft Office” aimed at those who are completely new to Microsoft Office or need a refresher of the basics:
And how old is Windows (Server version)? 23 years old.
UNIX is twice the age of Microsoft Windows (Server version)!
We are seeing an increasing number of our clients wanting to get more out of their databases and as a result we are seeing an increase in demand for business intelligence and data analysis courses.
Are you being asked questions about reports running on your SSRS servers?
Microsoft Word offers a very powerful table feature, but it can be a bit of an art working with tables sometimes. In a series of blogs I aim to run through some simple, but essential tasks when working with tables in Word.
It is easy enough to copy and paste a data set into Word from a source such as a Microsfot Excel workbook as a lot of default formats are applied when the data is pasted, but formatting it to your requirements is then often the challenge.
In Working with Tables in Microsoft Word - Part 1 we will look at:
Last week while teaching a PowerPivot course I was asked if it was possible to import data into a Power Pivot table from text files with non-standard delimiters.
The answer is – YES!!
PowerPivot uses the Microsoft ODBC Desktop Database Drivers.
Excel is great at adding up numbers, but it can be used for so much more!!
