SQL Server “Denali”: Details on the next version of SSAS
At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. ...
2011-06-27
3,178 reads
Blog Posts
SQLDIY: Tracking Wait Stats
One of the most important methodologies to date for troubleshooting problems with the SQL Server engine is examining the wait...
2011-06-27
1,056 reads
Where Do You Go for Authoritative SQL Server Best Practices?
Reprinted from my editorial in Database Weekly.
In early 2000, I started a new DBA job with a large organization, as...
2011-06-27
934 reads
Why Two Devices
I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and...
2011-06-27
921 reads
LulzSec: Why You Should Care
Updating Resume is NOT Lulz
Wow, it’s been a crazy last couple of months with LulzSec running around doing what they...
2011-06-26
1,518 reads
ALTER TABLE - Adding Column - Column Order Impact
Most of us would have altered a table structre by adding a column to the table. When an ALTER table...
2011-06-25
977 reads
Who Am I
If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these...
2011-06-25
688 reads
Configuration Manager for Sqldiag
SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor...
2011-06-24
1,103 reads
Five Lines of Code
An interesting story on how a database speeds up by changing some application code. Worth the read for sure.
I caught...
2011-06-24
782 reads
Full Time Employees Per Number of Database Users? FTE/DB users? How Many Servers are too much to Handle?
After several days research, I have been trying to get a rough estimate on how many Full Time Employees are...
2011-06-24
3,239 reads
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
What is the Best Medicine for Pennis?
The optimal therapy for erectile dysfunction depends on individual health conditions, preferences, and treatment...
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...
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