The Evolution of Windows
Today Steve looks back at Windows, and how Windows 10 might be the last version. Perhaps this is the model we'll see with SQL Server in the future.
2020-09-01
285 reads
Microsoft
The Computing Revolution
Steve reflects on some of the ideas of how Microsoft imagines the future of computing.
2020-07-27
237 reads
2020-07-06
154 reads
The Build Book of News
Every year Microsoft has held the Build conference for developers. I've been lucky enough to go a few times, and I was hoping to get the chance to attend again. With the pandemic, the entire event went virtual, and was held across 48 continuous hours. I was slightly disappointed as a few sessions I wanted […]
2020-05-23
155 reads
Is 100% Security Possible?
A security breach at Microsoft is disconcerting, especially when they don't share details.
2020-03-05
310 reads
Azure Sphere
The Azure Sphere project is a great piece of research at Microsoft that might help us data professionals with security.
2019-11-25
246 reads
2019-11-11
385 reads
A Mindset Shift
Microsoft has grown and changed their culture in the last few years, which greatly impresses Steve.
2019-11-01
364 reads
Evergreen SQL Server
Microsoft talks about evergreen SQL, where you never need to patch your database.
2025-05-14 (first published: 2019-07-24)
1,648 reads
DevOps and OSS Can Scale
Microsoft has embraced open source software, and has opened much of their code. They have also proven that DevOps development can scale in this environment.
2019-07-17
363 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