Tags » Data Warehouse

How dashDB Helps Media Channels Boost Revenues And Viewership

By Harsimran Singh Labana

Did you ever wonder how a media channel decides which ad comes at what time? Well, there is an analytics science behind this. 359 more words

Data Warehouse

10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )

This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good friend, Mitch Pearson (blog… 1,602 more words

SSAS

SQL Add Database file to filegroup

ALTER DATABASE MyDW
ADD FILE
(
NAME = MyDW_2012,
FILENAME = N’D:\DB\MyDW_2012.NDF’,
SIZE = 100MB
)
TO FILEGROUP MyDW_2012
GO

ALTER DATaBASE MyDW
ADD FILE… 337 more words

Data Warehouse

Defining Business Intelligence (BI)

According to Gartner (http://www.gartner.com/it-glossary) Business intelligence (BI) is an umbrella term that includes the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance.  30 more words

SQL Partition Function

–DROP PARTITION FUNCTION MyDW_RangePF

CREATE PARTITION FUNCTION MyDW_RangePF (datetime)
AS RANGE RIGHT FOR VALUES (
‘20130101’,
‘20140101’,
‘20150101’,
‘20160101’,
‘20170101’,

‘20180101’,
‘20190101’,
‘20200101’,
‘20210101’,
‘20220101’,

‘20230101’,
‘20240101’,
‘20250101’,
‘20260101’,
‘20270101’,

‘20280101’,
‘20290101’,
‘20300101’
)

Data Warehouse

SQL Partition Scheme

CREATE PARTITION SCHEME MyDW_PSC
AS
PARTITION MyDW_RangePF
TO (

MyDW_2012,
MyDW_2013,
MyDW_2014,
MyDW_2015,
MyDW_2016,
MyDW_2017,
MyDW_2018,
MyDW_2019,
MyDW_2020,

MyDW_2021,
MyDW_2022,
MyDW_2023,
MyDW_2024,
MyDW_2025,
MyDW_2026,
MyDW_2027,
MyDW_2028,
MyDW_2029,
MyDW_2030
)
GO

Data Warehouse

Deep Dive in a Big Data Lake

Big Data has been talked a lot in every part of business, and if you don’t, you are ostracized, criticized, demonized…Ok, let’s stop it… 505 more words