Excel spreadsheets are useful for distributing data generated by SQL Server. EPPlus is an open source .NET library that reads/writes Excel 2007/2010 files using the Open Office XML format (XLSX). It is a mature project, and plays well with SSIS.
This Friday Steve Jones asks about the market price for your skills. Do you know what it is?
Sergey Gigoyan looks at how to address the warning: Operator used tempdb to spill data during execution with spill level 1.
Today we have a guest editorial from Andy Warren that talks about SQL Server the no one's favorite topic: licensing.
Microsoft's DocumentDB is a late-entrant in the Document-oriented database field. However, it benefits from being designed from the start as a cloud service with a SQL-like language. It is intended for mobile and web applications. Its JSON document-notation is compatible with the integrated JavaScript language that drives its multi-document transaction processing via stored procedures, triggers and UDFs. Robert Sheldon investigates its SQL-like query language.
Data is more important than gut feel, or at least, Steve Jones thinks it should be more important. Today he talks about using data to support decisions.
Tim Radney of SQLskills shows how to measure your network so you have more ammo to take to your network team when there is a performance issue.
Are you a DBA tax on your company? Or an asset that's worth the cost. Steve Jones talks about trying to be the latter and not the former.
How to monitor drive space in T-SQL and calculate when your drives will run out of space.
Arshad Ali explains and demonstrates the impact of enabling the Stretch database feature on backup and restore operations. He also discusses ways to pause, resume, and disable this feature altogether when not needed.
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...
Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah Khusus...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Gn. Sahari No.45, Gn. Sahari Utara, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
Jl. Pegambiran No.2B, RT.12/RW.7, Jati, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus Ibukota...
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