Formatting SSAS Measures - SQL School Video
ln this SQL School video, learn how you can format the various measures in your SSAS cubes.
2009-03-05
3,588 reads
Brian Knight
Running A Basic DMX Query - SQL School Video
This SQL School video introduces us to the data mining queries that you can run from BIDS in an Analysis Services project.
2009-02-26
4,671 reads
Running Singleton Queries Against a DMX Data Mining Model - SQL School Videos
Learn how you can run a singleton data mining query against a cube with a mining model.
2009-02-24
1,818 reads
Installing & Congfiguring DM Add-in for Excel - SQL School Video
This SQL School video explains how to use the Data Mining add-in for Excel 2007. The installation and configuration are covered.
2009-02-19
3,012 reads
Creating Mining Structure - SQL School Video
In this SQLSchool video, MVP Brian Knight shows us how to create a simple data mining model in Analysis Services.
2009-02-17
2,852 reads
Data Mining in Excel 2007 Pt.2 - SQL School Video
In this video MVP Brian Knight continues on with more advanced data mining using Excel.
2009-02-12
3,337 reads
Data Mining in Excel 2007 Pt.1 - SQL School Video
Excel has greatly helped ease the process of data mining. In this video MVP Brian Knight shows how you can start using the data mining add-ins for Excel to get started.
2009-02-10
5,142 reads
Mining Model Viewers - SQL School Video
In this video MVP Brian Knight explains how you can use the model viewers to see how the data mining task will process your data.
2009-02-05
2,017 reads
Installing Sample 2008 Databases - SQL School Videos
Installing the sample databases in SQL Server 2008 isn't as straightforward as in previous versions. Brian Knight shows what needs to be done in this video.
2009-02-03
3,901 reads
Using the Timestamp Data Type - SQL School Video
The timestamp data type is a unique data type in SQL Server. Brian Knight shows how it can be used in your tables.
2009-01-29
4,437 reads
Blogs
Goal Progress–Feb 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
How to: exec sp_help on temp tables?
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
Daily Coping 26 Feb 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
MSDTC and Always On AG
Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...
Remove Carriage Returns / Line Breaks / Any other reason the "text" moves down
I know this has been covered ad nauseum all over the internet for years....
Better query to get count based on column value
I am using SQL server 2008 R2 express edition. Out of below 3 method...
Ask SSC