SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.
There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.
There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.
There's a trend for smaller laptops called netbooks to make traveling with computers easier. However these devices may result in more security issues. Steve Jones comments on some of the problems.
Got a new database you know nothing about? Here's my basic proposal on how to find interesting tables in it.
Join MSAS Architect Bill Pearson as he leads the hands-on creation of a simple bar chart based upon an Analysis Service data source.
Using Excel as a tool for data mining and predictions is very powerful. Learn how to take advantage of SSAS in SQL Server 2005 with Microsoft Office Excel 2007.
With the current economic downturn, many of us are wondering if we will still have a job by the end of this new year. Although DBAs are still in demand, no DBA job is 100% immune from layoffs. Brad suggests that now is the perfect time to invest in yourself.
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...
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
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