Holidays as Benefits
When you take a job, do you ask about holidays? Do you consider them a benefit? Andy Warren asks what those holidays might mean to you.
Basic Administration Tasks - Level 5 of the Stairway to for Azure SQL Database
In this next level, learn how to accomplish a few simple administration tasks that may help you manage your Azure SQL Database.
Rolling Back Migrations
The ways that one rolls back deployed database changes gets more complex with the migration development philosophy.
Generate HTML Formatted Email of SQL Server Database Consistency Check Errors
In this tip we look at to create a SQL Server DBCC CHECKDB errors email formatted in an HTML table. This will report any errors for all of your databases on the server.
Posting SQL Server notifications to Slack
Learn how you can post notifications from SQL Server directly to a Slack channel.
Scheduling SQL Server Tasks on Linux
In this tip we look at how to schedule SQL Server tasks on Linux servers using Cron.
Generate QR Code® barcodes in an SSRS report with the QRCoder library
QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.
Generate two-dimensional QR Code® bar codes in an SSRS report
QR (Quick Response) Code® is the Denso Wave, Inc. trademark for a type of two-dimensional bar code designed for the automotive industry in Japan. The QR Code system has become popular outside the automotive industry due to its speed and greater storage capacity compared to standard UPC bar codes.
Blogs
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...
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...
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