A Hint For Recruiters (And You!)
Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we...
2009-10-04
349 reads
Blog Posts
SQLSaturday 26 Session Files
SQLSaturday 26 Sessions: 10/3 in Redmond, WA
Thanks to everyone that attended my sessions at SQLSaturday 26 in Redmond, WA on...
2009-10-04
1,026 reads
Stupid DBA Tricks
Well, I just learned a valuable lesson about something you should not do as a DBA…
About a month ago, a...
2009-10-04
4,343 reads
Pitching in at SQL University
Jorge Segarra (@SQLChicken) has put together an idea to have on-line basic lessons on SQL Server called SQL University. The idea...
2009-10-03
1,126 reads
Red Gate's SQL Data Generator
I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...
2009-10-03
3,036 reads
Southwest Florida Code Camp II
I presented a Powershel session at the SW Florida .Net Code Camp IIl. The session demonstrated the following uses cases for...
2009-10-03
531 reads
Choosing a career path; which way do I go?
“Should I get an MBA or an MCSE?” What an odd question. At least these days it seems odd. But,...
2009-10-02
301 reads
Editorial on the Incidental DBA
You can read the full text of it in today’s SSC Newsletter, the quick summary is that for many businesses...
2009-10-02
255 reads
Free Stuff and a SQL Server Standard Update
Great news. We’ve managed to get one article all the way through the process. We’ll have our first publication out...
2009-10-02
719 reads
Installer Cache – C:\Windows\Installer
Over the past few months I have been upgrading most of my SQL Server Reporting Services (SSRS) 2005 installs to...
2009-10-02
572 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