(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.
Tag: sql server
(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.
(Melissa Coates) Dataflows in Power BI are a really interesting capability for centralizing and reusing Power Query logic among many different PBIX files.
(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.
(Rick Dobson) Please provide an introduction for how to analyze contingency tables with SQL. Demonstrate how to derive contingency tables from a simple dataset. Also, provide a SQL framework for analyzing a contingency table via the Chi Square test statistic.
(Allan Hirt) I teased this blog post a little while back at SQLBits, but I’m finally getting a chance to finish this blog post. No stale, scheduled content here – it’s always hot off the presses.
(Kenneth Fisher) And if you are still reading you probably fit into one of the following categories.
(Tibor Karaszi) Short answer: probably not. Long answer: read on.
(Pinal Dave) Let me tell you about a real-world scenario which I often see at organizations I work with. In the perfect world, as organizations grow, their team should grow too. But often that isn’t the reality.
(Chris Webb) Most of the focus on Power BI dataflows so far has been on the use of Power Query Online to load data from external data sources.