Microsoft has released SQL Server 2012 RTM Cumulative Update 4, which is build 11.00.2383.0. By my count, there are 25...

2012-10-16

1,735 reads

SSAS #28 – Setup to Learn SSAS Stored Procedures

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Having worked with SSAS for a while and done some reporting with MDX queries, I started to explore opportunities to...

2012-10-16

1,552 reads

Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT

by saldeloera-1

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

When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data into a new table. Whether the developer needs to...

2012-10-15

41 reads

Parallel Data Warehouse (PDW) Performance Tip: CTAS vs INSERT SELECT

by saldeloera-1

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

When loading tables in Microsoft’s Parallel Data Warehouse (PDW) via T-SQL, one will soon encounter the need to load data...

2012-10-15

1,825 reads

Listing server and database roles for all logins and users in SQL Server – Part 2 – Remote Servers

by TheSQLPro

TheSqlPro.com - Ayman El-Ghazali

Building upon the code in my previous post, I will be retrieving permissions information from remote servers that I have...

2012-10-15

418 reads

Multilanguage Table, How to insert different language text in table ?

by Rohit Garg

MSSQLFUN

Issue :
Today, I received one request from my old friend.
He wants to insert text in different languages in table. He...

2012-10-15

2,989 reads

Lions and Tigers and Bears…

by Jason Brimhall

SQL RNNR

Last Thursday I found myself on a journey of sorts. There weren’t any lions or tigers or bears, but there were plenty of “Oh My”‘s. It all began on...

2012-10-15

10 reads