Additional Articles

Scala and Apache Spark in Tandem as a Next-Generation ETL Framework

by Additional Articles

SimpleTalk

Scala

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

Statistics in SQL: Pearson’s Correlation

by Additional Articles

SimpleTalk

statistics

Some people will assure you that you can't do any serious statistical calculations in SQL. In the first of a series of articles, Phil factor aims to prove them wrong by explaining how easy it is to calculate Pearson's Product Moment Correlation.

2017-06-09

4,713 reads

How to partition data in Tabular SSAS

by Additional Articles

MSSQLTips.com

SSAS

Partitioning data is a standard SQL Server administration practice. Partitions enable independent administration of different slices of data. When a SQL Server Analysis Services (SSAS) tabular data model is developed and processed, data is read from the source system and loaded into the tabular data model configured in In-Memory processing mode. Every time the model is processed, the entire data set may not require re-processing. Only certain slices of data containing changes may require re-processing which can be achieved by partitioning data into logical slices. In this post, Siddharth Mehta looks at how to partition tables in Tabular SSAS.

2017-06-08

2,832 reads

Comparing SSIS Catalog Contents Using DBFit Framework

by Additional Articles

SimpleTalk

Integration Services (SSIS)

When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have to check to make sure that the deployment will be successful. These will include such settings as the values in environment variables, Package parameters and project parameters. The DbFit test framework turns out to be ideal for the purpose of doing final checks as part of a deployment process, as Nat Sundar demonstrates.

2017-06-07

3,586 reads

How to style your SQL using SQL Prompt’s new formatting options

by Additional Articles

Redgate

formatting

Prefer tabs but your teammates use spaces? That's not a problem with the brand new formatting options in SQL Prompt. It's now possible to customize, save, and share multiple styles that you can then quickly switch between when working. Here's how it works, and how to get set up.

2017-06-06

4,008 reads

SQL Server Temporary Object Caching

by Additional Articles

SQLPerformance.com

Temporary Objects

Paul White describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.

2017-06-06

3,591 reads

Where is my SQL Server Configuration Manager?

by Additional Articles

Database Journal

SQL Server Configuration Manager

If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.

2017-06-05

4,227 reads

Free ebook: Stairway to SQL Server XML

by Additional Articles

SimpleTalk

Free download to all Simple Talk users. XML has been part of the SQL Standard since 2003, and is essential for any DBA because so many of the dynamic management views return XML data. Now that the industry is more used to data defined by document markup, it is becoming more important than ever for Database Developers and DBAs to understand the technology and to know where it makes sense to use XML.

2017-06-02

6,152 reads

Introducing DLM Techniques for a Multi-Database Multi-Server System

by Additional Articles

SimpleTalk

Database Lifecycle Management

Although the techniques of Database Lifecycle Management can reduce the timescales for the delivery of new functionality to business systems, what if the database 'layer' consists of several large interdependent databases and data flows with replication and audit? Does DLM scale to this level of complexity? Margaret Cruise O'Brien starts a series of articles that describes the practicalities of improving DLM within an existing framework and team supporting a multi-database multi-server system, by describing some of the database management problems and solutions in an enterprise-scale database.

2017-06-02

2,744 reads

Performance Myths : Truncate Can't Be Rolled Back

by Additional Articles

SQLPerformance.com

Performance

Derik Hammer sets out to disprove another pervasive performance myth : TRUNCATE is faster than DELETE because it isn't logged and can't be rolled back.

2017-06-01

4,663 reads

All authors

Additional Articles

Scala and Apache Spark in Tandem as a Next-Generation ETL Framework

Statistics in SQL: Pearson’s Correlation

How to partition data in Tabular SSAS

Comparing SSIS Catalog Contents Using DBFit Framework

How to style your SQL using SQL Prompt’s new formatting options

SQL Server Temporary Object Caching

Where is my SQL Server Configuration Manager?

Free ebook: Stairway to SQL Server XML

Introducing DLM Techniques for a Multi-Database Multi-Server System

Performance Myths : Truncate Can't Be Rolled Back

Blogs

Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation

The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5

A Prompt AI Experiment

Forums

statistics callection intervel in query store ?

Rounding Off issue in SQL Server

how to get notification that my database has corssed 8gb

Question of the Day

SQL Server, Heaps and Fragmentation