SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 41 to 60 of 15843    Older >>
 

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.  Read more...
By Additional Articles 2017/06/12 | Source: SimpleTalk | Category: scala
Rating:  Rate this |   Briefcase | 3,753 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.  Read more...
By Additional Articles 2017/06/12 | Source: Microsoft MSDN | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 3,997 reads

Have production-level PostgreSQL experience?

Redgate are doing some early stage research around PostgreSQL, and would really like to hear about your experiences. If you think you can help, check out their short survey.  Read more...
By 2017/06/12 | Source: Redgate | Category: postgresql
Rating: (not yet rated)  Rate this |   Briefcase | 1,686 reads

They Call Me Andy Null

Who's on first, null edition.  Read more...
By Andy Warren 2017/06/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 102 reads

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.  Read more...
By Ryan Loftin 2017/06/09 (first published: 2016/05/05) | Source: SQLServerCentral.com | Category: openjson
Rating: |  Discuss |   Briefcase | 2,620 reads

Statistics in SQL: Pearson’s Correlation

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.  Read more...
By Additional Articles 2017/06/09 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 3,793 reads

VMware monitoring in SQL Monitor

The Redgate SQL Monitor team has been looking into how you can more effectively monitor SQL Server running on a virtual machine, and are pleased to announce that they've begun this by introducing support for VMware in SQL Monitor version 7.0.11. Find out more about the beta feature in this blog post.  Read more...
By 2017/06/09 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,975 reads

The OUTPUT Clause for the MERGE Statements

In this article, I will provide a set of examples to showcase the use of OUTPUT clause within the MERGE statement and how to capture the OUTPUT clause results into an archive table.  Read more...
By Amarendra Reddy Thummeti 2017/06/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,153 reads

SQL Server is Getting Smarter

SQL Server is becoming more capable all the time, requiring fewer human resources for basic management.  Read more...
By Steve Jones 2017/06/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 reads

How to partition data in Tabular 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.  Read more...
By Additional Articles 2017/06/08 | Source: MSSQLTips.com | Category: ssas
Rating: (not yet rated)  Rate this |   Briefcase | 2,473 reads

Webinar: Microsoft’s Agile Transformation Story

Learn how Microsoft adopted DevOps at scale in this free Redgate webinar on June 12. Donovan Brown, Senior DevOps Program Manager in Microsoft’s US Developer Division, will share how Microsoft embarked on its own DevOps journey reducing a three-year release cycle down to three weeks. Sign up now.  Read more...
By 2017/06/08 (first published: 2017/05/30) | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 10,339 reads

Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016

This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.  Read more...
By Hugo Kornelis 2017/06/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 703 reads

Byte Me: Diagnosis Data

By Bob Lang 2017/06/07 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 64 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2017/06/07 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 79,900 reads

Comparing SSIS Catalog Contents Using DBFit Framework

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.  Read more...
By Additional Articles 2017/06/07 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,506 reads

The OUTPUT Clause for UPDATE Statements

In this article, I will provide a set of examples to showcase the use of OUTPUT clause in capturing the results of the updated rows into a table variable for the UPDATE statements.   Read more...
By Amarendra Reddy Thummeti 2017/06/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,871 reads

The Poor State of Secure Coding

The way we code isn't necessarily getting better.  Read more...
By Steve Jones 2017/06/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 79 reads

SQL Server Temporary Object Caching

Paul White describes temporary object caching in SQL Server – what it is, why it exists, and how to use it to your advantage.  Read more...
By Additional Articles 2017/06/06 | Source: SQLPerformance.com | Category: temporary objects
Rating: (not yet rated)  Rate this |   Briefcase | 3,270 reads

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

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.  Read more...
By Additional Articles 2017/06/06 | Source: Redgate | Category: formatting
Rating: (not yet rated)  Rate this |   Briefcase | 3,452 reads

Wanna Cry? Me too

By Grant Fritchey 2017/06/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 140 reads
<< Newer    Items 41 to 60 of 15843    Older >>