(Fikrat Azizov) Having a background as a SQL Server DBA, I’ve worked with SSIS for on-premises data sources for quite some time. Now with Microsoft’s new cloud integration tool, Azure Data Factory, there has been a bit of learning curve.
Community
Automatic Table Generation in any Database by NHibernate ORM and CodeDom for Code Generation
(Mahsa Hassankashi) This article enables you to generate table in any database such as Oracle, SQLServer, MySQL, SQLite, Sybase, etc. just by typing table name and its fields. Then you can use NHibernate facilities to make query for data layer.
F# Weekly #12, 2019 – F# in Amazon Lambda, Mono tail calls optimizations & IL viewer in Rider
(Sergey Tihon) Welcome to F# Weekly,
SQL SERVER – Difference Between Status in SP_Who2 – Running, Pending, Runnable, Suspended, Sleeping
(Pinal Dave) One of the most popular questions I receive during my Comprehensive Database Performance Health Check is a difference between status in sp_who2 which discusses status as Running, Pending, Runnable, Suspended. Let us today understand them with regards to CPU and IO.
Configuring efficient MySQL Logrotate
(Vignesh Prabhu) I am a Junior DBA at Mydbops. This is my first blog professionally, I would like to brief my encounter with Log-rotate in first few weeks of my work
Creating an Oracle Cloud Infrastructure (OCI) Object Storage Bucket
(Skant Gupta) In this post, you will create a storage bucket using Oracle Cloud Infrastructure (OCI) Object Storage.
Lazy Loading Of Modules In Angular 7
(Puneet Kankar) In this article, we’ll learn the implementation of lazy loading in Angular.
Three Ways to Use Power BI Dataflows
(Melissa Coates) Dataflows in Power BI are a really interesting capability for centralizing and reusing Power Query logic among many different PBIX files.
Filtered Indexes and INCLUDEd Columns
(Rob Farley) Filtered indexes are amazingly powerful, but I still see some confusion out there about them – particularly about the columns that are used in the filters, and what happens when you want to tighten the filters.
Dependent Tables in DB2
(Damir Wilder) Have you ever had a need to quickly find out if a DB2 table has any dependencies, i.e. foreign key relationships to it and from it?