Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.
An interesting point was made by a reader about the price of SQL Server licenses when R2 is released. Steve Jones comments about a penalty that some of you may find if you look to build a SQL Server 2008 server later this year.
MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in Microsoft SQL Server 2008.
In part 1 of this series, Shahfaisal Muhammed brings us one method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.
A sample chapter from a new book on Analysis Services. Check it out and see if this is the book for you.
Most of us, by definition, are average. That's fine most of the time, but when you want a new job, standing apart from the average Joe is a good idea. Steve Jones talks about working on standing apart from the crowd.
A holiday in the US has Steve Jones on the slopes. A short reminder of patches released last week is the editorial today.
Steve Jones talked about the announcements of Service Pack 4 for SQL Server 2005 and Service Pack 2 for SQL Server 2008 in this editorial.
A partnership with Pragmatic Works brings you some basic SQL Server training through a series of webinars.
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...
BCA KCP Pusat Pasar Minggu HUB.Tlpn.0821•3111•185 Jl. Lenteng Agung Raya No.26 EF, Ps. Minggu,...
Jl. S. Parman No.66, Kebun Kenanga, Kec. Ratu Agung, Kota Bengkulu, Bengkulu 38223
BCA KCP Iskandar Muda II Telpon/wa:0813.7887.595.Jalan Sultan Iskandar Muda No.78 RT.003/05, RT.10/RW.2, Kby. Lama...
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