Topic : Build ETL efficiently (10x) with Minimal Logging
Presentation File Download Link
Posted by Simon Cho on 09/24/2016
Posted in Common | Tagged: #563, Dallas, SQL Saturday | Leave a Comment »
Posted by Simon Cho on 09/22/2016
We need to check a couple of setting.
Script
— #1 : First failover only. Remove AG required. After run the script we can rejoin it.
SELECT name FROM sys.databases WHERE is_broker_enabled=1— If you don’t see your DB. need to run below command.
ALTER DATABASE <ServiceBrokerDB> SET ENABLE_BROKER
GO— #2 : Concorrunt connection may be interuppted. First failover only.
SELECT name FROM sys.databases WHERE is_trustworthy_on=1
— If you don’t see your DB. need to run below command.
ALTER DATABASE <ServiceBrokerDB> SET TRUSTWORTHY ON
GO
— #3 : Need to execute it every failover. More detail please see “Service Master Key” document.
OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘x’ — Should be encrypted! See below
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
Posted in Common | Tagged: Service Broker, Service Broker in AG | Leave a Comment »
Posted by Simon Cho on 09/22/2016
https://blogs.msdn.microsoft.com/mattm/2012/09/19/ssis-with-alwayson/
https://technet.microsoft.com/en-us/library/ms182754%28v=sql.110%29.aspx
Temporary solution : Alter master key again with service master key
OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘x’ — Should be encrypted! See below
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
Here is SQL server 2016 AG setting.
It seems like working with SQL 2014 as well.
Posted in Common | Tagged: Service Master key | 1 Comment »
Posted by Simon Cho on 09/12/2016
Build ETL efficiently (10x) with Minimal Logging
Here is the Presentation file. Link
http://saturdaynightsql.sqlpass.org/Home.aspx?EventID=5824
I wish to have 2-3 hour presentation length.
1 hour is short to share all those information.
Posted in Common | Leave a Comment »