When Would You Go?
This year TechEd is across two weeks, with a different focus for each. Which one would you rather attend.
Designing and Delivering Rich Office Reports with SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter
This white paper explains how to use SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter to design and deliver full fidelity, data-driven Microsoft Excel and Word reports.
Implementing a Generic Data Access Layer in ADO.NET Part 3
The 3rd and final of the 3 Part Series discussing the implementation of a provider independent Data Access Layer in ADO.NET.
Slipstreaming
Why don't we have updates, patches, and service packs slipstreamed into the base product for new installs?
Parameter Support Objects, Pt II: Support OLAP Parameter Defaults with Datasets
Join BI Architect Bill Pearson as he continues his examination of parameterization within Analysis Services reports. In this article, we provide a solution for supporting parameter defaults that represent the last periods of data entry within our cube.
The Data Stewardship Approach to Data Governance: Chapter 5
Part 5 looks at beginning with a Data Governance Best Practice Assessment
When Would You Go?
This year TechEd is across two weeks, with a different focus for each. Which one would you rather attend.
When Would You Go?
This year TechEd is across two weeks, with a different focus for each. Which one would you rather attend.
When Would You Go?
This year TechEd is across two weeks, with a different focus for each. Which one would you rather attend.
How SQL Server Chooses the Type of Join
How many times have you had a stored procedure run quicker in Query Analyzer than it does in the application? Mike Dillon tracked down one possible cause in this article.
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCP Duta Merlin Tlp/Wa 08216977701
Komp. Duta Merlin Blok A No. 24-25, Jl. Gajah Mada No.3-5, Daerah Khusus Ibukota...
CS FINANCE CIPUTAT Hub.0821•3111•185
CS FINANCE CIPUTAT Hub.0821•3111•185 Jalan R.E. Martadinata.27, Jl. RE Martadinata No.27, Cipayung, Kec. Ciputat,...
BCA KCP Boulevard Timur Tlp/Wa 08216977701
Jl. Boulevard Timur No.54-55 Blok NC 1, Pegangsaan Dua, Kec. Klp. Gading, Jkt Utara,...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers