I'm Speaking at SQLLunch
I am excited to be speaking at SQLLunch.com on March 1st. SQL Lunch is a great website event where Host...
2010-02-21
351 reads
Microsoft AdCenter and SQL Server Analysis Services 2008
There is a recently published whitepaper that talks about Microsoft AdCenter using SSAS 2008 to accelerate performance over 2005. Most...
2010-02-21
532 reads
Disk Partition Alignment
This whitepaper from Greg Lowe talks about the important strategy behind disk partition alignment. This is focused mainly in SQL...
2010-02-21
538 reads
Data Type Precedence and Implicit Conversions
In my last post, I noted that one of the biggest differences between ISNULL and COALESCE was the fact that...
2010-02-21
4,535 reads
Modifying SQL in a Lookup Transform
Oftentimes you need to make a more advanced join that the default LookUp Transform will allow. The challenge is when...
2010-02-20
360 reads
Selecting Top N Rows from Excel Source
Excel is a significant source of data in most enterprises. Therefore there is a large amount of Excel work being...
2010-02-20
276 reads
SSAS Query Processing and Performance Tuning
Any of us can work with some simple MDX queries and get them to do what we want, but in...
2010-02-20
302 reads
Testing Security in SSAS
Security in SSAS is a simple yet powerful application of windows integrated security. MDX adds extra power to this by...
2010-02-20
342 reads
Quotes in Calculation Tab
A quick clarification on something I said the other day to a group of students in one of our quick...
2010-02-20
225 reads
I’m Speaking at the SSWUG VConference in April
Hey All ! I wanted to let you know I will be speaking at the SSWUG Virtual Conference this Spring. This...
2010-02-20
223 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Alamat BCA KCP BSD Sektor I Telp:0821°8200°233
Telp/Wa 628218200233 Komp, BSD City, Ruko Barcelona, Blk. E9 No.30 RK No. 28, 29,...
Alamat BCA KCP Cikupa Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Raya Pemda Blok R-1 No.07, dan No.08, Bojong, Kec. Cikupa, Kabupaten...
Alamat BCA KCP Borobudur Telp:0821°7555°651
Telp/Wa 628217555651 Jl. Borobudur Raya Blok M No. 36-37, Bencongan Indah, Kecamatan Kelapa Dua,...
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers