Enabling TDE on Databases in an AlwaysOn Scenario
Enabling Transparent Data Encryption on Databases in Always On Scenario
The Digital Woes of Public Records
Public records have been open in the past, but today's digital access might mean problems.
The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs
The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. In using the Query Store to ensure that performance is as good as possible, it isn't long before it becomes important to be familiar with the DMVs that are associated with the query store, and using them in custom queries.
Thinking About the Cloud?
Are you thinking about the cloud yet? Redgate is conducting some research into cloud adoption to better understand both the drivers and the blockers. Whether or not you’ve taken the plunge yet, they would love to hear from you. Participate in the survey and be entered into a draw to win an Amazon gift card worth $100.
Culture and Performance
Culture is important at our workplace. Steve Jones notes this can be important when trying to get the most performance from your employees.
SQL, and Ye Shall Find
Phil Factor reflects on how hard it really is to develop a really effective database that meets the SQL Standards, and how as a result we are only beginning to realize fully the vision of relational orthogonality in databases.
Exploration of SQL Server 2016 Always Encrypted – Part 3
In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.
Centrally collect replication conflicts and send an alert
Automatically capture replication conflicts and generate an automated email notification.
Who's Got a Preteen SQL Server?
This week Steve Jones wonders about the age of your instances and whether you are planning on upgrades or aware of how many out of support instances you might have.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Adira Finance,Telpon/wa 0822-7774-3331
Jl. Raya Jakarta-Bogor No.8, Cirimekar, Kec. Cibinong, Kabupaten Bogor, Jawa Barat 16917
ADIRA Finance Pangandaran,Telpon/wa 0822-7774-3331
8M98+J42, Babakan, Kec. Pangandaran, Kabupaten Ciamis, Jawa Barat 46396
Adira Finance Cabang Sukabumi - Surya Kencana,Telpon/wa 0822-7774-3331
Jl. Surya Kencana Ruko D5-D6, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat 43111
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers