How to install SQL Server 2022 step by step
In this article, we cover how to install SQL Server 2022.
AI Ethics
I found this article to be an interesting look at how we might add ethics to AI systems in one area. As the article points out, "... today there is no broadly accepted AI ethics framework, or means to enforce it. Clearly, ethical AI is a broad topic ...". Glad someone is thinking, or many […]
Infographic Designer Visuals in Power BI
Learn how you can make your visuals more interesting with the Infographic Designer Visual.
Query SQL Server with Python and Pandas
In this article, we examine how to read SQL Server data and parse it directly into a dataframe and perform operations on the data using Python and Pandas.
Summarizing data using GROUP BY and HAVING clauses
You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how.
Query Tuning, Why Bother?
Today Grant wonders why we spend so much time trying to learn about query tuning.
Establishing a Connection to PostgreSQL with GoLang
Learn how to use golang to connect to a PostgreSQL database.
Columnstore Indexes are Finally Sorted in SQL Server 2022
There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column.
Power BI - How to Download and Get Started
In this article learn how to download, install and get started building your first Power BI report using SQL Server data.
Blogs
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Finding the Next Sequence Value: #SQLNewBlogger
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
Forums
Auto Update Statistics not triggering on filtered indexes
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
What is the difference between SQL Server and SQL Database?
I created a SQL Database in Azure Portal but I've just noticed it also...
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers