Naming Conventions for SQL Server Objects
Phil Factor feels that as a community we can do more to help people who are wrestling with SQL coding standards.
How to Linux for SQL Server DBAs — Part 2
SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security works in Linux. In this article, Kellyn Pot'Vin-Gorman demonstrates how to manage user accounts in Linux and why working while logged in as root is a bad idea.
The Real World: Implementing Data Compression in SQL Server 2008 R2
Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008
Your SQL Server is Bored: What Low Wait Times Mean
In which you ask your assistant to fetch your coffee, and time them.
Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server
Auditing the password changes using LOGIN_CHANGE_PASSWORD_GROUP Server Level Audit Group.
Using your critical eye to see something positive
As DBA's we are often looking for issues and hole is things, but it is also important to see positives and seek a better solution.
Creating Machine Learning Applications using Azure Cognitive Services
Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.
Installing the Database Server - Level 2 of the Stairway to SQL Server on Linux
In this next level, we learn how to install SQL Server on Linux and verify that everything is working.
Using Tools That Fit
The right tool is important for a good job. Andy Warren asks if you're thought about the tools you use on a daily basis.
Using Azure Quickstart Templates
In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
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