Developing pipelines in Azure Data Factory using Template gallery
(2019-Feb-08) I often see demos of Azure Data Factory (ADF) development techniques with a modest set of activity tasks and not...
2019-02-08
688 reads
Blog Posts
Performance on readable replicas in Availability Groups
I apologize in advance if I mess up the terminology.
I’ve worked with a moderate read workload on a readable replica...
2019-02-08
775 reads
Pro SQL Server Linux–Moving to Linux
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-02-08
1,356 reads
Rotating Expired SQL Server TDE Certificates
In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using...
2019-02-08 (first published: 2019-01-23)
1,775 reads
Scheduling things to Run in SQL Server
A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule...
2019-02-08 (first published: 2019-01-23)
2,745 reads
SQL Server 2017 Reporting Services: The Basics Part 3
Note: I’ve been meaning to start a series on the basics of SQL Server Reporting Services (SSRS). The last time...
2019-02-08
744 reads
SQL Server Database Experimentation Assistant - How to Run a Capture
DEA
Very basic look at the setup as I couldn’t find much documentation on this when I last tried this out in 2018. Maybe it will help you get started...
2019-02-08
35 reads
ALTER TABLE Fails on Replicated Tables With Isolation Level SERIALIZABLE or READ UNCOMMITTED on SQL2012 and Earlier
It’s 4am in the morning and my phone starts ringing.
A blury eyed, me picks it up to hear the voice...
2019-02-07
336 reads
Data Warehousing Tip #5 – Use surrogate keys
My fifth data warehousing tip is to always use surrogate keys for your dimension and fact tables.
Surrogate keys are keys...
2019-02-07 (first published: 2019-01-18)
3,063 reads
Dynamic Data Masking in the execution plan
I think Dynamic Data Masking is pretty cool. The idea is basically to provide a mask for certain users when...
2019-02-07
817 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat BCA KCU BEKASI Hub:Cs,0817781222
Wa:0817781222 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks, Jawa...
Alamat Kontak BCA KCU RAWAMANGUN Hub:Cs,0817781222
Wa:0817781222 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Alamat Kontak BCA KCU THAMRIN Hub:Cs,0817781222
Wa:0817781222 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers