Advice I Like: Time and Focus
“You don’t need more time because you already have all the time that you will ever get; you need more focus.” – from Excellent Advice for Living Boy, I...
2026-10-30 (first published: 2026-10-23)
171 reads
“You don’t need more time because you already have all the time that you will ever get; you need more focus.” – from Excellent Advice for Living Boy, I...
2026-10-30 (first published: 2026-10-23)
171 reads
This month I want to look at a few of the things I’ve seen posted about cars during the last month. These are a few headlines, as well as...
2026-10-30
241 reads
2026-10-30
1,027 reads
AI LLMs can help find bugs, especially security vulnerabilities, in code. That appears to be happening with SQL Server.
2026-10-28
183 reads
2026-10-28
922 reads
I had a briefing for the 2026 PASS Data Community Summit, which is just a couple of weeks away. Amongst a bunch of admin type stuff, there was a...
2026-10-27
32 reads
The job market is tough and Steve has some advice today on how you approach your career.
2026-10-26
153 reads
2026-10-26
935 reads
Steve talks software design and architecture today with an interesting idea: design it twice.
2026-10-23
101 reads
2026-10-23
1,035 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers