Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused
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,397 reads
Useful information and case studies covering Data Warehousing, Data Modeling, and Business Intelligence
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
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,893 reads
Parallel Data Warehouse (PDW) How-To: Avoid ShuffleMove and PartitionMove Operations
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
75 reads
Parallel Data Warehouse (PDW) Tip: Usage of SYSDATETIME() vs GETDATE()
Usage of GETDATE() dates back to the earliest versions of SQL server and has become the primary blade in our...
2012-07-21
2,761 reads
SQL SERVER - CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis
Reblogged from Journey to SQL Authority with Pinal Dave:
Every weekend brings creative ideas and accidents brings best unknown secrets in...
2012-07-12
978 reads
Parallel Data Warehouse (PDW) Basics: CREATE TABLE and CTAS Syntax
After forgetting the syntax for temp tables a couple of times, I decided to write a brief overview of the...
2012-07-12
3,757 reads
Dynamic Multi-Threaded SSIS using C#
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,468 reads
Parallel Data Warehouse (PDW) Lesson 1: – Basic Architecture Overview
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,111 reads
SSIS How-To: Reuse Existing Connection Manager to Execute SQL in Script Task
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
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers