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,762 reads
Video
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,096 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,873 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,360 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,199 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,041 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,536 reads
Viewing the Data Profiling Task Data - SQL School Video
It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.
2009-01-27
5,122 reads
Blogs
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common...
A New Word: Lackout
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Delta Lake over Spark Connect
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Forums
Shades and Reflecting on SQLBits and the Bright Future of Data
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
Merge techniques
In Azure SQL DB, i want to merge records from the staging table to...
SSRS error: The Value for the image 'Image1' has a constant value...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers