The 400,000 Member Milestone
We crossed 400,000 members yesterday and it's a great achievement for us. As a celebration, we've decided to give out some prizes. Read on to see if you're one of the lucky winners.
The In-House Expert
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
Controlling Information as a Strategic Enterprise Resource
Information governance is defined by Larry English as the act or process of leading, directing, controlling and assuring that information is managed effectively as an enterprise resource. (PDF download)
Featured Blog: SQL Server 2008: Spatial indexes
Paul Randal talks about the new spatial data types and their indexes.
The End of Estimation - iPod
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
The End of Estimation - MP3
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
The End of Estimation - WMV
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
Data Driven Subscriptions for Reporting Services (2000 and 2005)
Reporting Services has proven to be one of the more useful subsystems of SQL Server. However the standard editions of both SQL Server 2000 and SQL Server 2005 have limitations with regard to the subscription features. Jason Selberg brings us an updated version of his
code for extending the subscription feature.
Reporting on Activity across Multiple Servers using SQL Backup and SQL Multi Script
Rodney Landrum presents a creative solution for dynamic reporting across all of his SQL Servers, based on use of Red Gate's SQL Backup and SQL Multi Script.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
How do I explain that SQL Server should not be used as a code repository?
This week my BI Developer colleague proudly showed me a new Power BI report...
Question of the Day
Creating a JSON Document III
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