SQL Server identity columns are easy to add to a table, but you must understand how they work to use them effectively. In this article, Greg Larsen explains the nuances of SQL Server identity columns.
2021-10-22
Introduction According to the official documentation, the READ COMMITTED isolation level “specifies that statements cannot read data that has been modified but not committed by other transactions”. So, one could think that a record returned under this isolation level existed in the committed state at the time of reading. In this article, I am going […]
2021-10-01
2,163 reads
In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more.
2021-09-27
The SQL Server identity column is used to populate a column with incrementing numbers on insert. In this article, Greg Larsen explains how it works.
2021-09-13
In this article we look at a PowerShell script that you can use to centrally enable and disable any SQL Server Agent Job on any instance of SQL Server.
2021-09-08
Registration is now open for our free and online data platform conference. Join 1000s of your data peers at PASS Data Community Summit and get access to up to 5 days of training, sessions, networking activities, and events. This year's program has been carefully designed to help you achieve your goals, wherever you are in your data career.
2021-09-10 (first published: 2021-09-03)
In this article we demonstrate how to transfer data via a CSV file from a SQL Server database to a Pandas dataframe and then subset the dataframe in Python.
2021-09-03
Dealing with NULL values especially when joining tables can become a challenge. Let's take a look at this issue and how this can be resolved.
2021-09-01
Learn how to execute the same batch of SQL Server commands X number of times using the GO command.
2021-08-27
In this article we look at solving SQL Server database restore issue when backup file does not show up in SSMS restore GUI as well as other permissions issues with backup and restore.
2021-08-23
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
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