Bullet Journal Workshop for April/May!
Edit: The April 26 workshop will be at 10:30am Central Time, because right after that I get my second Covid […]
The post Bullet Journal Workshop for April/May! appeared first...
2021-04-06
23 reads
Edit: The April 26 workshop will be at 10:30am Central Time, because right after that I get my second Covid […]
The post Bullet Journal Workshop for April/May! appeared first...
2021-04-06
23 reads
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
40 reads
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
14 reads
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
22 reads
Dozens of major data breaches have occurred in the last fifteen years. Each one illustrates the massive cost – both in dollars and in reputation – of lax security....
2020-06-22
40 reads
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites!
The...
2020-06-10
21 reads
We’re a large household with a small business, and we find ourselves with an interesting mix of tools for chat, screen sharing, and video conferencing. Here are our favorites!
The...
2020-06-10
25 reads
The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
The post What happens if your SQL Server...
2020-06-03
182 reads
The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
The post What happens if your SQL Server...
2020-06-03
24 reads
We like code better than mouse clicks for three basic reasons: T-SQL lets you do more. T-SQL lets you share your process. T-SQL lets you keep a record.
The...
2020-05-27
34 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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