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,664 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,760 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,836 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,095 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,869 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,359 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,196 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,039 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,918 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,533 reads
Blogs
Distributed Availability Group Dashboard
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This...
Comparing My Current Schema with a Backup with SQL Compare
By Steve Jones
A customer asked if they needed to restore a database from backup to compare...
Improving Our Conversations
By Brian Kelley
If we aren't having the same conversation, we aren't going to be heard. That's...
Forums
temp table columns not showing up in CTE
I'm new to the development side of the house and stuck on a CTE...
SSAS Cube Migration to Azure cloud
Dear All, I am currently working on a Proof of Concept (POC) where I...
create a table with data capture for next 3 years
Hello, I would like to build a table capturing data starting from 1st day...
Question of the Day
Local Storage Options
I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?
See possible answers