The PASS Session Selection Process, My Experience Part 3
In my last two posts I talked specifically about the process. This round I’m going to discuss the tools of...
2010-07-12
610 reads
Wesley Brown
- Interests: Collecting old computers
- Skills: I talk a lot.
The PASS Session Selection Process, My Experience Part 2
In part one I talked about the abstracts. While important, abstracts are only one part of a complicated selection dance....
2010-07-09
475 reads
The PASS Session Selection Process, My Experience Part 1
Well, I have just finished up my part in the abstract selection process for the PASS Summit. This was my...
2010-07-07
545 reads
SQL Saturday #35 Notes and Observations
First of all, I want to congratulate all the volunteers that made this happen. It was a very well organized...
2010-05-25
1,175 reads
What happens when Windows is the step-child? Adventures in Ruby on Rails.
Like many of you I’ve heard the developer community going on about Rails for quite a while now. It wasn’t...
2010-04-02
1,464 reads
What I’ve Read and Recommend to Others – General Database and Theory by C.J. Date
Date on Database: Writings 2000-2006
This is a collection of writings by C.J. Date, one of the fathers of the relational...
2010-02-26
1,885 reads
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-24
2,200 reads
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
2010-02-19
2,937 reads
Sometimes, you have to fix it yourself
The Problem
SQL Server is a huge product with lots of moving parts. Bugs happen. Microsoft has a place to voice...
2010-02-18
2,018 reads
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
2010-02-16
2,598 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
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