Statistics with TSQL and R: Chi Square Test
As I move on from descriptive and largely univariate (one variable based) analysis of data into more multivariate data – one...
2016-09-21 (first published: 2016-09-13)
4,614 reads
Top 5 Books for Database Developers
My Top 5 series of books has proved very popular. The first post titled Top 5 books for Enterprise Architecture was the...
2016-09-13
1,790 reads
DBCC CHECKFILEGROUP
Well, with the name “blobeater” it was about time I did another post on CHECKDB. This time I want to...
2016-09-14 (first published: 2016-09-13)
1,233 reads
World is changing so DBA should
I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL...
2016-09-13
384 reads
SQL Server 2016 In-Memory OLTP and After Trigger Support
SQL Server 2016 supports AFTER triggers! I could find no good example of how to do this with a project...
2016-09-12
759 reads
Azure Cognitive Services API’s with SQL Server 2016 CLR
[read this post on Mr. Fox SQL blog] Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that have the ability to do some truly amazing...
2016-09-12
27 reads
Azure Cognitive Services API’s with SQL Server 2016 CLR
[read this post on Mr. Fox SQL blog]
Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that...
2016-09-20 (first published: 2016-09-12)
2,109 reads
SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects
Abstract
This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with...
2016-09-20 (first published: 2016-09-12)
2,072 reads
The Clustered Index Is Vital To Your Database Design
This is post #9 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
You get one clustered index per table.
That...
2016-09-19 (first published: 2016-09-12)
2,514 reads
Load Testing Results Might Not Be What You Think
Bottlenecks in your testing tools, infrastructure, or methodology might just hurt your load test results, and the results can skew...
2016-09-16 (first published: 2016-09-12)
1,323 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