T-SQL Tuesday #115 – Notes to 20 year old Wayne
There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!)....
2019-06-11
8 reads
Blog Posts
Using Azure Data Factory Mapping Data Flows to populate Data Vault
(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure Data Factory (ADF) last year as a private feature preview. This privacy restriction has been lifted...
2019-06-11 (first published: 2019-05-24)
3,335 reads
What is the key to automated database deployments?
In my blog post here https://the.agilesql.club/blogs/ed-elliott/2019-06-10/steps-to-automated-database-deployments I described the steps you need to go through so you can build up your confidence that you are capable of deploying databases...
2019-06-11
13 reads
What is the key to automated database deployments?
In my blog post here https://the.agilesql.club/2019/06/what-steps-are-there-to-move-to-safe-automated-database-deployments/ I described the steps you need to go through so you can build up your confidence that you are capable of deploying databases...
2019-06-11
6 reads
Azure Cosmos DB Intro
Cosmos DB falls into the “NoSQL” technology group, call it a buzz word if you like but it is very different to classic Relational Databases such as SQL Server....
2019-06-10
208 reads
Do you have rarely used indexes that are hurting performance of writes?
We know that indexes are necessary for query performance but comes with overhead during DML operations. Usually, the overhead is worth the performance gain we get out of them....
2019-06-10 (first published: 2019-05-21)
862 reads
Filtered Index Basics
In this post, we continue with another beginner’s blog of database features that may be unknown to many. Let’s take a look at filtered indexes. Many database administrators are...
2019-06-10 (first published: 2019-05-22)
767 reads
Last Week Reading (2019-06-09)
Hello there! Another week, another roundup of Internet interesting stuff. Press Microsoft Business Applications Summit The event is happening now in the Georgia World Congress Center in Atlanta, GA....
2019-06-10
19 reads
Leverage AWS System Manager Sessions
Use Case
Leveraging aws system manager sessions can help with aws development, by eliminating the need to RDP for work that can be done via a PowerShell session. In addition,...
2019-06-10
12 reads
Machine Learning + DevOps = ML DevOps (Together at Last)
[read this post on Mr. Fox SQL blog] For the longest time data science was often performed in silos, using large machines with copies of production data. This process...
2019-06-10
91 reads
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
Alamat kantor resmi BCA KCU YOGYAKARTA Telp:0817866887
WhatsApp:0817866887 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55223
Alamat kantor resmi BCA KCU HR MUHAMMAD Telp:0817866887
WhatsApp:0817866887 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
Alamat kantor resmi BCA KCU PANTAI INDAH KAPUK Telp:0817866887
WhatsApp:0817866887 Jl. Pantai Indah Kapuk Utara I Blok F, Kamal Muara, Kecamatan Penjaringan, Jkt...
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