The Cloud is Nothing Special
This week Steve talks about cloud computing, and the fact that a lot of what the cloud does is no big deal. But it can be helpful to IT professionals.
TSQL Challenge 39 - Calculate Gross Profit by Item using FIFO method
This challenge is related to an inventory management application where your job is to calculate the profitability by item (cost v/s sales) using First-In-First-Out (FIFO) processing method.
Identify database features restricted to a specific edition of SQL Server 2008
Ever wanted to know how he can identify whether a database uses any of the features that are restricted to a specific edition of SQL Server 2008. In this tip we will go through the steps a DBA needs to follow to identify a database which uses edition specific features.
Minesweeper in T-SQL
Whatever happened to the idea that programming in TSQL can be fun? A Simple-Talk reader contributes an article to remind us all that there is more to TSQL than wrestling with DMVs and pummelling recalcitrant correlated subqueries.
The MERGE Statement in SQL Server 2008
When the SQL MERGE statement was introduced in SQL Server 2008, it allowed database programmers to replace reams of messy code with something quick, simple and maintainable. The MERGE syntax just takes a bit of explaining, and Rob Sheldon is, as always, on hand to explain with plenty of examples.
From Zero to SSIS! Learning SQL Server Integration Services
Learn SSIS from MVP Andy Leonard in Waltham, MA on Oct 6-8, 2010. This is a paid event. More details inside.
Inside the Optimizer: Constructing a Plan - Part 4
The final part in a series by Paul White exploring the internals of query optimization. Learn how
We Are Not Alone
Today we have a guest editorial from Robert Pearl that talks about the SQL Server community, and how you can get involved.
Conditional report rendering based on render formats for SSRS Reports
When using Report Manager, users can export reports to different formats like PDF, XLS and others. When reports are exported to other formats they also include all of the content from the report, but rendered to the format of the report output. There maybe scenarios where you would not want a particular part or component of report to appear in these other report formats. A practical example of this could be that you want to display images when the report is displayed in HTML, but not when the report is exported to a PDF format. In this tip we take a look at a new feature in Reporting Services that allows us to control these items without having to create multiple report versions.
SQL Saturday #52 - Colorado
A free one day training event in the Denver Tech Center on Sept 25, 2010. Come learn about SQL Server and how to further your career at this one day event.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
Kantor BCA KCP Kas Kendal Telp/wa 085169998803
Telp/wa 085169998803 Jl. Raya Soekarno-Hatta No.258, Pekauman, Pakauman, Kec. Kendal, Kabupaten Kendal, Jawa Tengah...
BCA KCP Pondok Gede Hub.0851•8812•0691
BCA KCP Pondok Gede Hub.0851•8812•0691 Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec....
BCA KCU Bogor Telp/wa 085169998765
Telp/wa 085169998765 Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota Bogor,...
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