Predicate Order is Critical
I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order...
2015-09-29 (first published: 2015-09-23)
3,194 reads
“sql_handle” is not a recognized table hints option.
I’ve you’ve run a query similar to the following:
SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle);And gotten an error similar to:
Msg 321, Level...
2015-09-23
1,037 reads
Webinar: Kicking the Tires on SSIS 2016
The next version of SSIS is on the horizon. Are you ready?
In next Tuesday’s webinar, I’ll be reviewing and demonstrating...
2015-09-23
591 reads
Setting up a new CI server to build SSDT projects
I am going to ignore the fact that people don't want to install visual studio on a build server, in...
2015-09-23
531 reads
Setting up a new CI server to build SSDT projects
I am going to ignore the fact that people don’t want to install visual studio on a build server, in...
2015-09-23
42 reads
Setting up a new CI server to build SSDT projects
I am going to ignore the fact that people don’t want to install visual studio on a build server, in...
2015-09-23
62 reads
Setting up a new CI server to build SSDT projects
I am going to ignore the fact that people don't want to install visual studio on a build server, in the future there will likely be a way to...
2015-09-23
13 reads
Power BI Custom Visuals Contest Round-up
It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been...
2015-09-22
405 reads
Power BI Custom Visuals Contest Round-up
It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been...
2015-09-22
849 reads
Costumes at the PASS Summit
tl,dr; We’re raising money for Doctors without Borders. Donate and a few of us will dress up at the Summit....
2015-09-22
685 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