The New OS Wars
A few countries are looking to reduce their reliance on US technology. While they might leave Windows, Steve thinks they will continue to run SQL Server.
2026-04-20
341 reads
Microsoft
The Microsoft SQL Year in Review
Microsoft gives a year in review from the SQL Server and Azure SQL teams. Steve sees a lot of accomplishments from this past year.
2025-12-20
203 reads
50 Years of Microsoft
Steve looks back at his history with Microsoft and asks what your memories are of using their products.
2025-04-25
163 reads
Microsoft SQL announcements at PASS Data Community Summit 2024
Read a summary of the data platform announcements from Microsoft at the PASS Data Community Summit 2024 last week.
2024-11-18
1,113 reads
Do You Want a Microsoft Solution?
Today Steve wonders if official solutions from a vendor are that important.
2024-11-15
159 reads
2024-11-06
246 reads
Microsoft at the PASS Data Community Summit 2024
Learn about the Microsoft sessions at the 2024 PASS Data Community Summit from Bob Ward.
2024-10-28
230 reads
Microsoft return to PASS Summit 2024 as Sapphire sponsor
Get ready to meet Microsoft's experts on-site in the exhibit hall and in multiple educational sessions (including a pre-con, keynote and learning pathway). Watch a sneak peek of Microsoft's learning pathway 'Becoming an Azure SQL DBA – Advancing the Role of the On-Premises SQL Server DBA'
2024-09-18
Microsoft at the PASS Data Community Summit 2023
Microsoft will be presenting a number of sessions at the PASS Data Community Summit 2023. Read about their plans for the event and register to come if you can.
2024-05-14 (first published: 2023-11-03)
352 reads
AI Thoughts on the Build Keynote
Today Steve has a few thoughts, and links, from the Build Keynote last week, which featured AI technology.
2023-05-26
218 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers