Daily Coping 19 Dec 2022
Today’s coping tip is to give kind comments to as many people as possible today. Not an easy tip for me to follow as I’ve been a little home...
2022-12-19
11 reads
Blog Posts
jurn - A Command Line Tool for Keeping Track of Your Work
Watch this week's video on YouTube
How do you keep track of your daily work accomplishments?
If you are like me, you wait until the end of the week and then...
2022-12-19
19 reads
jurn - A Command Line Tool for Keeping Track of Your Work
Watch this week's video on YouTube
How do you keep track of your daily work accomplishments?
If you are like me, you wait until the end of the week and then...
2022-12-19
8 reads
New Database Job – The 6 Month Plan
So, we made it through our first 90 days, things start getting tougher now as now we really got to start looking at getting projects
The post New Database Job...
2022-12-19 (first published: 2022-12-01)
297 reads
SQL Homework – December 2022 – What’s new in SQL Server?
SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading
2022-12-19 (first published: 2022-12-01)
454 reads
What is TDE (Transparent Data Encryption)?
TDE is referred to as a “transparent” form of encryption. What that means is that the process of encrypting and decrypting data is fully performed in the background. The...
2022-12-19
92 reads
Creating a user for a STONITH resource in vSphere
I previously blogged about how to create a STONITH resource for a pacemaker cluster in VMWare virtual machines. Ok, I have a confession…you need to specify credentials when creating...
2022-12-16 (first published: 2022-12-01)
102 reads
Daily Coping 16 Dec 2022
Today’s coping tip is to send a gift to someone new. I have been sending gifts to my daughter at college every month or so, but I decided I...
2022-12-16
17 reads
My Office Setup
At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from...
2022-12-16 (first published: 2022-12-01)
290 reads
Daily Coping 15 Dec 2022
Today’s coping tip is to support a charity or cause you care about. My big causes are food, housing, and education for those that are struggling. I like to...
2022-12-15
19 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