Which Work Is Suited for In-Person?
What is the best way to use an office? Or is there even a best way? Steve asks the question today.
[From the archives] Your guide to choosing the right monitoring tool [Video]
Join Grant Fritchey in this 35 minute video to learn his top tips for evaluating monitoring tools and vendors, the common pitfalls when implementing a new solution, and how you can demonstrate Return on Investment (ROI) to the business post-purchase.
SQL Server 2022: Backup Database Options to AWS S3 Bucket - Part 2
In this article we look at how to backup a SQL Server 2022 database using AWS S3 storage along with all the supported backup options.
How to Find the Start and End Dates for the Current Week (and more)
Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
Cross-RDBMS Version Checks in Flyway
How does one check that a database is definitively at the version that Flyway says it is? Or that a test teardown procedure leaves no trace in the database? Or verify that an undo script returns a database's metadata to that state it should be in for the version to which you're rolling back? This article shows how to do high-level version checks, by comparing JSON models.
SQL Server 2022: Backup and Restore database to AWS S3 bucket - Part 1
In this article we look at how to configure AWS to allow backup and restore from a SQL Server 2022 database using AWS S3 storage.
Power BI Report Builder Parameters Tutorial
Learn how you can adjust the way users interact with reports and change font sizes as well as add parameters for filtering.
Rebooting for a Reason
Steve wasn't happy with the tech support advice of rebooting a computer. He feels better now.
Datamarts and exploratory analysis using Power BI
During Build 2022, Microsoft announced a new feature, Datamarts for Power BI. MVP Dennes Torres explains this new feature and provides and example.
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