SSIS Catalog Logging Tables
Making the most of the SSIS catalog requires an understanding of how to access the information stored in the logging...
2017-03-31
898 reads
Making the most of the SSIS catalog requires an understanding of how to access the information stored in the logging...
2017-03-31
898 reads
I was a last minute volunteer to speak at the March meeting and used it as a chance to talk...
2017-03-31
637 reads
SQLBits is only a week away! But before that I’ve been reading…
Backing up SQL Server on Linux using Ola Hallengrens...
2017-03-31
429 reads
SQLBits is only a week away! But before that I’ve been reading…
Backing up SQL Server on Linux using Ola Hallengrens...
2017-03-31
577 reads
Yesterday was the SQL Clone launch livestream from the Redgate office in Cambridge, UK. I flew over on Monday, along...
2017-03-30
1,049 reads
I have a server that uses a third party disk encryption product. It’s configured so that the SQL service account...
2017-03-30
720 reads
Watch your memory configuration! You can’t just throw RAM in a physical server and expect it to work right. Depending on...
2017-03-30
724 reads
In this module you will learn how to use the Attribute Slicer Power BI Custom Visual. Using the Attribute Slicer...
2017-03-29
1,164 reads
I didn’t know about this little gem, so I shared it with my team and they didn’t know about it...
2017-03-29
726 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-03-29
1,011 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...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
Has anyone ever seen this before? I have sysadmin permission on a server. 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 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