You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon describes a poorly-documented but important technique for Business Intelligence.
As we ask developers to deliver software quicker, are we helping improve the quality of software? Steve Jones asks the question today.
This article will show you how to scan SQL Server Error Logs with ease and track important information that is stored there.
PASS Professional Development Virtual Chapter will be hosting a session on what managers need to know about SQL Licensing, presented by Joseph D'Antonio on September 11, 2013.
SQL Saturday is coming to Johannesburg, South Africa on Saturday, September 14 2013. Join us for a free day of SQL Server training and networking.
You are tasked with examining poor performance for queries on a certain table, or range of tables. Perhaps a sales report is timing out or running unacceptably slow; perhaps your web application is failing to return the result set before the application timeout is reached. You need to find out what's causing the bottleneck, and optimize either the queries used, the table schemata, or both.
Are there good and bad interview questions? Are there some you prefer or hate? Steve Jones comments on some of the strange ones out there and how hiring is changing.
Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.
With ODBC, you can summarise, and select just the data you need, in an Excel workbook before importing it into SQL Server. You can join data from different areas or worksheets. You can even get data from the result of a SQL Server SELECT statement into an Excel spreadsheet. Phil Factor shows how, and warns of some of the pitfalls.
The announcement that the MCM program was being discontinued brings us a few thoughts from Gail Shaw, one of the 0.08% to achieve the certification.
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...
Anda cukup menghubungi CS resmi BookCabin di nomor 082162909071 Dan Bisa Via wa resmi...
Cara nya cukup menghubungi CS resmi BookCabin di nomor 082162909071 Dan Bisa melalui whatsapp...
Telp/WA.0821°3111°179 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, 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