Refreshing Excel Power Query & Pivot Tables with SSIS and Task Factory
With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query...
2015-08-15
1,182 reads
Catch up with T-SQL Tuesday
T-SQL Tuesday is a monthly blog party where we get an invitation the first week of the month to write...
2015-08-25 (first published: 2015-08-14)
2,885 reads
015 – Brian Davis - WaterOx Consulting
Brian Davis In WOxPod!, episode # 015 – “Brian Davis” we have...
The post 015 – Brian Davis appeared first on WaterOx Consulting.
2015-08-14
550 reads
SQL Script to find all the triggers defined on a database or on a single table
Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT tbl.name as [Table Name] ...
2015-08-14
17 reads
SQL Script to find all the triggers defined on a database or on a single table
Sometime we need to find all the triggers defined on the database. So in this case, we can use the...
2015-08-14
1,691 reads
We Don’t Trust This Data
“Learning to trust is one of life’s most difficult tasks.” – Isaac Watts
As data professionals, there are times when our jobs...
2015-08-19 (first published: 2015-08-14)
2,990 reads
Hekaton Part 4: Simple Performance comparison - In Memory vs Disk table
Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based...
2015-08-18 (first published: 2015-08-14)
2,942 reads
PASS Board Update: July 2015
I was actually travelling for most of July and some of that was on holiday with the family, the real...
2015-08-13
589 reads
SSMS 2016 CTP 2.2 Setup Failure 0x81f40001
I built a brand new virtual machine running Windows 2012 R2 and SQL Server 2016 CTP 2.2 (the June edition). ...
2015-08-13
1,682 reads
Stranger Danger… The need for trust with constraints
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint....
2015-08-13
433 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers