DQ & MDM Book Available to Download
If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...
2011-06-01
1,227 reads
SQL Server BI Blog
Let’s Get Visual – The Art of Report Design
Paul Turley
Mentor, SolidQ
This article is based on my session at TechEd on May 18th, 2011
Report styles vary depending on the...
2011-05-23
3,615 reads
Correcting Image Distortion in PDF Reports
I’ve seen a few cases where reports exported or rendered to PDF have distorted charts and images. We’ve played with...
2011-05-05
1,695 reads
Designing Reports with Custom MDX Queries – part 2
…continued from part 1:
Building a Report
For the remainder of this article, I will demonstrate query and report design techniques by...
2011-05-04
1,679 reads
Designing Reports with Custom MDX Queries – part 3
Start at part 1
…continued from part 2:
Handling Parameters
When an MDX query is created using the graphic query designer, parameters can...
2011-05-04
1,219 reads
Gartner BI Magic Quadrant 2011
It’s often true that “a picture is worth a thousands words” but sometimes a picture can be such an effectively...
2011-04-23
1,346 reads
Designing Reports with Custom MDX Queries – part 1
This article is the first in a three-part series
On the Microsoft Developer Network (MSDN) forum for Reporting Services and other...
2011-03-27
1,376 reads
Take-aways from the 2011 Microsoft MVP Summit
Every year, Microsoft brings a couple thousand specialists from every corner of the globe together for a few days to...
2011-03-07
630 reads
Can I Add Controls to a Reporting Services Report?
I see this question on the forums all the time and thought it was worth a repost here.
Just this week,...
2011-02-14
1,330 reads
StreamInsight: A new way to think about analyzing data
Last night’s Oregon SQL user
group meeting was very enlightening. Mark Simms form the SQLCAT team came
down from Redmond to talk...
2011-02-11
1,090 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Cilandak KKO I Telp/Wa:0821-8200-233
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Alamat BCA KCP Arkadia Telp/Wa:0821-8200-203
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
BCA KCU KUNINGAN Telp/Wa:0821-8200-174
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers