Quietly, Microsoft has been making radical improvements to Reporting Services; but precisely what was introduced, and when? We asked Bill Pearson, the well-known BI expert, to come up with a definitive survey of the more recent changes and how they help the user of Reporting Services.
Outsourcing is a fact of life, but with the economic issues worldwide, it has also slowed. That will change eventually and Steve Jones has some thoughts about what you can do to prevent it for your job.
Learn about how you might solve some issues running SSIS packages using Excel on a Windows 2008 x64 Machine.
SQL Server's UPDATE statement is apparently simple, but complications such as the FROM clause can cause puzzlement. Bob Sheldon starts simply, and introduces the more complex forms painlessly.
Steve Jones talks about the need to perhaps get more depth and breadth to the information that we present at events like SQL Saturday to help people learn at all levels.
This article from Andrew Riley will show you how you can use the RANK and ROW_NUMBER Ranking Functions to deduplicate data in SQL Server 2005
This article describes data driven variable structure generation in SQL. The controlling data can be located higher up on the hierarchical pathway or can be located further down on the pathway producing a look-ahead operation. Multiple pathways can independently produce dynamic data driven structures and these dynamic structures can be nested allowing a very flexible and powerful dynamic automatic data structure generation capability. These different controls of structure generation can be combined.
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
Why would database performance remain low and fragmentation high event though the entire database has been defragmented every night? In this tip we cover how SHRINKFILE works and some of the issues it might create.
The start of a new series from Leo Peysakhovich that looks at some of the issues with moving data around between systems and ensuring that it is in sync between them.
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Ruko Mayor Oking Blok B. 1, Jl. Mayor Oking No. 35, RT 002/001, Cirimekar,...
BCA KCU GAJAH MADA Telpon/WA.0853•5504•2311 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 LODAN CENTER, Ruko Jl No.6-7 Blok O, Ancol, Kec. Pademangan, Jkt Utara, Daerah...
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