Find and fix SQL Server databases with empty owner property using dbatools PowerShell module
A few days ago I came across with a error that says “Property Owner is not available for database [XXXXXXX].”....
2017-01-19
1,152 reads
A few days ago I came across with a error that says “Property Owner is not available for database [XXXXXXX].”....
2017-01-19
1,152 reads
I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using...
2017-01-26 (first published: 2017-01-19)
1,488 reads
If you’re in the Boston area tomorrow, I urge you to go to this year’s Virtualization Technology Users Group (VTUG)Winter...
2017-01-18
358 reads
In a prior blog post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option....
2017-01-18
429 reads
Someone once told me at the shop that we have plenty of software utilities laying around that could be very...
2017-01-18
535 reads
Microsoft’s end goal is for Azure to become the best cloud platform for customers to run their data workloads. This...
2017-01-18
370 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-18
672 reads
The power and capabilities of Azure SQL Data Warehouse are pretty amazing. However, it’s still basically SQL Server under the...
2017-01-25 (first published: 2017-01-18)
1,116 reads
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re database people, not email mavens, and the newsletter does...
2017-01-18
17 reads
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re database people, not email mavens, and the newsletter does...
2017-01-18
11 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