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,673 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,767 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,843 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,106 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,877 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,369 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,211 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,049 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,921 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,547 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
Question of the Day
Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers