2017-06-16
2,571 reads
Articles
Use T-SQL to Find Folders Using the Most Disk Space
Your SQL Server drives are running out of disk space and you want a way to quickly tell which sub-directories are taking the most space - here's how to do it with T-SQL.
2017-06-16
4,950 reads
Setting up R in SQL 2016 – Avoiding Pitfalls
Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.
2017-06-15
2,266 reads
Questions About SQL Server Collations You Were Too Shy to Ask
Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.
2017-06-15
3,969 reads
Setting Variables in Calling T-SQL Code While Using sp_executesql
In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.
2017-06-14
4,088 reads
What is normal? Finding outliers with R
How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.
2017-06-13
1,806 reads
UNION ALL Optimization
Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.
2017-06-13
5,896 reads
Two Approaches to Addressing Circular References in SSDT
Both options have their advantages and disadvantages. Neither is universally right for all situations. Understand the differences before picking the model that works for your situation.
2017-06-12
12,435 reads
Guide to enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform
A new whitepaper published today gives Microsoft SQL customers technical guidance for how to approach GDPR compliance with Microsoft SQL technologies.
2017-06-12
5,192 reads
Scala and Apache Spark in Tandem as a Next-Generation ETL Framework
Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering it as an alternative. After all, many Big Data solutions are ideally suited to the preparation of data for input into a relational database, and Scala is a well thought-out and expressive language. Krzysztof Stanaszek describes some of the advantages and disadvantages of a scala-based approach to implementing and testing an ETL solution.
2017-06-12
4,658 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers