SQL Deep Dives at Intersection in April
SQL Intersection is coming to Orlando in April, along with the rest of the Dev Intersection events the week of...
2014-02-07 (first published: 2014-02-04)
1,575 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
The Cloud
Steve Jones likes the Cloud and gives a few reasons why. He also thinks we'll see more data in the cloud over time.
2014-02-06
199 reads
Virtual Lab – Design and Setup
This is part of a series where I set up a virtual lab for testing and misc work. The other...
2014-02-06
1,294 reads
Just use Version Control
There are free systems out there. If you have no budget, and want to get started, download one of these:
Subversion:...
2014-02-05 (first published: 2014-01-28)
2,944 reads
Zombie Data
Old data can come back to haunt you. Steve Jones talks about potential problems when data comes back to life.
2014-02-04
169 reads
Big Data Comes to Hiring
Big Data is being used to analyze more and more data to produce better decisions. However that doesn't always work as people might expect. Steve Jones talks about some of the issues with using Big Data in hiring.
2014-02-03
179 reads
New Cartoons at SQLServerCentral
SQLServerCentral has commissioned a new cartoon that will be coming later this week.
2014-02-03
2,565 reads
Powershell in a Month Day 15 – Jobs
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-02-03
631 reads
Adding to SQL Server
This week Steve Jones wonders what you might want to add to SQL Server. With SQL Server 2016 likely in the early planning stages, where would you want to see the development effort focused.
2014-01-31
241 reads
Powershell in a Month Day 14 – WMI
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in...
2014-01-31
1,745 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
Alamat kantor resmi BCA KCU MANGGA DUA RAYA Telp:0817866887
WhatsApp:0817866887 Jl. Mangga Dua Raya Jalan Kavling No.1 Blok C-5, RT.11/RW.5, Ancol, Kec. Pademangan,...
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