10 Good Things About Reporting Services 2008 R2
The 10 things Microsoft got right about SQL Server Reporting Services 2008 R2 (a sister article shows 10 things which aren't quite so good)
2011-09-05
13,466 reads
Articles
TSQL Challenge 64 - A Payroll calculation Challenge
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays
2011-09-05
1,363 reads
Using a SQL Server Alias for SSIS Package Configuration Database Connection String
In this tip we will walk through setting up the SQL Server Alias and using it with SQL Server package configuration in an SSIS package.
2011-09-05
3,238 reads
Configure SQL Server Database Mirroring Using SSMS
This tip outlines a test environment and then walks through the process of setting up Database Mirroring. This includes the configurations, backups, restores and verification process.
2011-09-02
3,660 reads
2011-09-01 (first published: 2009-09-09)
11,447 reads
Recovery Models
Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.
2011-09-01
7,950 reads
Preventing Problems in SQL Server
It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and patience, but the reward will be an alerting system which allows you to deal more effectively with issues before they involve system down-time.
2011-09-01
3,959 reads
How to Performance Tune the Microsoft SQL Server tempdb Database
If your SQL Server’s tempdb database is heavily used by your application(s), consider locating it on an array of its own (such as RAID 1 or RAID 10). This will allow disk I/O to be more evenly distributed, reducing disk I/O contention issues, and speeding up SQL Server’s overall performance.
2011-08-31
5,236 reads
Raw Materials - The Little Engine that Could
Total Information Awareness can destroy your sanity. Get used to it.
2011-08-30 (first published: 2009-09-02)
11,273 reads
Speeding up database access - part 4 Fixing expensive queries
Part 4 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.
2011-08-30
10,450 reads
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
BCA KCU BINTARO Hub.0851•8812•0691
BCA KCU BINTARO Hub.0851•8812•0691 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7, Pd....
BCA KCP Bintaro Hub.0851•8812•0691
BCA KCP Bintaro Hub.0851•8812•0691 Jl. RC. Veteran. 9, dan No.9A, Daerah Khusus Ibukota Jakarta...
BCA KCP Pasar Kebayoran Lama Hub.0851•8812•0691
BCA KCP Pasar Kebayoran Lama Hub.0851•8812•0691 Jl. Raya Kby. Lama No.174, Cipulir, Kec. Kebayoran...
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