An error occurred while executing batch. Error message is: Arithmetic Overflow
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records...
2014-07-31
2,491 reads
Tim Radney - Database Professional
Microsoft SQL Server “Most Valuable Professional” MVP
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award. An excerpt from Microsoft’s...
2014-07-01
1,362 reads
I am speaking at the PASS Summit 2014
I am super excited to announce that I have been selected to speak at the 2014 PASS Summit. This is...
2014-06-25
1,227 reads
SQL Server High Availability and Disaster Recovery Options
Working with Microsoft SQL Server for many years I have spent a lot of time discussing the importance of the...
2014-06-11 (first published: 2014-06-10)
3,380 reads
Know Backups and Know Restores – SQL Server Restores
A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving...
2014-05-19
1,289 reads
Making a Difference – #SQLFamily
When I started with the SQL Community I was first encourage to start blogging which I started in Sept of...
2014-05-12
1,212 reads
Using BMC Control-M to Automate Tasks
My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our...
2014-04-14 (first published: 2014-04-04)
4,001 reads
The Primary Filegroup Cannot be Backed Up as a File Backup
File Group backups are great when working with very large databases (VLDB’s) that have been partitioned. Typically when I come...
2014-03-31
2,733 reads
How to check for last SQL Server backup
As a database professional, I get asked to review the health of database environments very often. When I perform these...
2014-02-24 (first published: 2014-02-18)
3,106 reads
SSIS Training class by Andy Leonard
Andy Leonard (b | t | l | f) of Linchpin People, has announced a new training class called ‘From Zero to SSIS‘. The first class...
2014-01-30
1,793 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
BCA KCP Sudirman TLP WA 08218573837
Jl. Jend. Sudirman No.277, Cibadak, Kec. Astanaanyar, Kota Bandung, Jawa Barat 40241
BCA Finance Bekasi Layanan Mobil Tlpn.Wa 083834802131
KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8 blok P5, Medan Satria, Kecamatan...
BCA KCP Batununggal TLP/WA 08218573837
Jl. Batununggal Indah Raya No.149, Batununggal, Kec. Bandung Kidul, Kota Bandung, Jawa Barat 40266
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