I started my career in IT nearly 10 years ago and have remained influenced and driven by two particular technology initiatives - Business Intelligence and Data Warehousing. Opportunities for partnership, learning, and innovation will continue to present themselves as we strive to meld people, business, and technology. I look forward to these opportunities as I am fulfilled by my membership to a scientific community that is driven by the development and execution of technology solutions that enhance the way we live and conduct business.

Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

There is a way to view the size of a particular PDW database using the DBCC_pdw_showspaceused command via the NEXUS...

2012-08-28

3,398 reads

Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data Warehouse (PDW) environment. With proper planning and attention to...

2012-08-27

86 reads

Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

There are a couple process hungry operations that can be avoided when developing or migrating T-SQL queries into Microsoft’s Parallel Data...

2012-08-27

3,898 reads

Parallel Data Warehouse (PDW) Tip: Usage of SYSDATETIME() vs GETDATE()

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

Usage of GETDATE() dates back to the earliest versions of SQL server and has become the primary blade in our...

2012-07-21

2,762 reads

Parallel Data Warehouse (PDW) Basics: CREATE TABLE and CTAS Syntax

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

After forgetting the syntax for temp tables a couple of times, I decided to write a brief overview of the...

2012-07-12

3,758 reads

SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

Reblogged from Journey to SQL Authority with Pinal Dave:
Every weekend brings creative ideas and accidents brings best unknown secrets in...

2012-07-12

979 reads

Dynamic Multi-Threaded SSIS using C#

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

Here is a snippet of code that will assist in the dynamic ‘spin-up’ of duplicate SSIS packages. To put it...

2012-07-09

1,469 reads

Parallel Data Warehouse (PDW) Lesson 1: – Basic Architecture Overview

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

I’ll begin my coverage of Microsoft’s Parallel Data Warehouse (PDW) architecture / appliance with a brief overview of the Massively Parallel...

2012-07-09

1,112 reads

SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task

by saldeloera-1

Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence

There’s a myriad of examples out there on how to execute a sql task via OLEDB connections and C# in a...

2012-04-09

3,279 reads

Blogs

Audit – Security Compliance Frameworks (Part 1)

By Vinay Thakur

This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...

Restore SQL Server Database to an OrbStack Container

By MarlonRibunal

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...

Day of Data Baton Rouge Slides and Code

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Read the latest Blogs

Forums

ALAMAT BCA KCU KUNINGAN Telp 08218200174

Via WhatsApp+62 821-8200-174 Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Jl....

ALAMAT BCA KCU PURI INDAH Telp 08218200174

By layanan_Bca88

Via WhatsApp+62 821-8200-174 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk...

SQL 2025 SSMS Nonsense

By Brandie Tarvin

Yeah, I know this is a 2022 forum, but I don't see a 2025...

Visit the forum

Question of the Day

SQL Server Certificates

Which of these is not true for certificates used for SQL Server connections?

See possible answers