SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2018/03/01 to 2018/03/08

TDE with Automatic Database Seeding

Transparent Data Encryption on an Availability Group and Automatic Database Seeding  Read more...
By Evgeny Garaev 2018/03/08 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 531 reads

Azure Cosmos DB Partitioning

One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables. Selecting the optimal partitioning model has both performance and pricing implications. In this article, we will explore the rationale behind these implications and review the partitioning options.  Read more...
By Additional Articles 2018/03/08 | Source: Database Journal | Category: azure cosmos db
Rating: (not yet rated)  Rate this |   Briefcase | 2,174 reads

Stairway to U-SQL Level 19: Azure Data Lake Metadata with PowerShell

Need to inspect your Data Lake objects and files? Want to automate the process? Find out how with PowerShell.  Read more...
By Mike McQuillan 2018/03/07 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 220 reads

SQL Provision adds fully integrated data masking

SQL Provision launched in January, offering users blazingly fast database copying, with a light storage footprint, centralized management, and the ability to mask any sensitive data, prior to distribution. This new release takes compliant provisioning one step further, by integrating data masking directly into SQL Clone’s image creation process, rather than running it as a separate step prior to the image creation.  Read more...
By 2018/03/07 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,365 reads

Questions About Data Breaches that You Were Too Shy to Ask

News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not immune. William Brewer answers the question about data breaches that you may be too shy to ask.  Read more...
By Additional Articles 2018/03/07 | Source: SimpleTalk | Category: security
Rating:  Rate this |   Briefcase | 2,491 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2018/03/07 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 93,828 reads

The Many Levels Of Concurrency

When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.  Read more...
By Additional Articles 2018/03/06 | Source: Brent Ozar Unlimited Blog | Category: concurrency
Rating: (not yet rated)  Rate this |   Briefcase | 3,045 reads

Understanding Machine Learning

This article describes about the understanding Machine Learning and bits of Artificial Intelligence as it’s a superset of Machine Learning.  Read more...
By Narendra Bhogavalli 2018/03/06 | Source: SQLServerCentral.com | Category: machine learning
Rating: |  Discuss |   Briefcase | 1,370 reads

Quality-Driven Software Development

While software is among the most widely used products in human history, it also has one of the highest failure rates due to poor quality. In this article, Cynthia Dzikiti explains how quality should be part of all aspects of the software lifecycle.  Read more...
By Additional Articles 2018/03/05 | Source: Redgate | Category: software development
Rating: (not yet rated)  Rate this |   Briefcase | 2,332 reads

Misuse of the scalar user-defined function as a constant

If you use an unverified scalar function, then the query will be grindingly slow because you will be executing it on every row whether it has a parameter or not. This post explains the issue in more depth, and shows how SQL Prompt code analysis rules can help you avoid it altogether.   Read more...
By 2018/03/05 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 3,145 reads

Query to Excel Stored Procedure

Transform your query result into an Excel file using this technique.  Read more...
By Darko Martinovic 2018/03/05 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,045 reads

SQL Server Machine Learning Services – Part 5: Generating multiple plots in Python

Visualization is often the first step in analyzing data. Python makes visualization easy. In this article, Robert Sheldon demonstrates how to generate multiple charts from one dataset using Python with SQL Server Machine Learning Services.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,267 reads

The top 7 benefits of DevOps for CEOs

If you were asked what the benefits of DevOps are, you could probably name two or three straight away. Maybe four or five. But – and here’s the thing – what if the person down the corridor was asked the same question? Someone who works in the same place, but does a different job.  Read more...
By 2018/03/02 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,530 reads

Scripting Environments in SSIS

Demo and script on how to script out SSIS Environments and their associated variables  Read more...
By Jeff Jordan 2018/03/02 (first published: 2016/01/21) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 6,249 reads

PASS Marathon GDPR in partnership with Redgate

This special edition of the PASS Marathon series will focus on the General Data Protection Regulation (GDPR). You’ll learn how the legislation impacts SQL Server data professionals around the globe and practical steps you can take to help ensure you’re ready for when GDPR enforcement takes effect on May 25th.  Read more...
By 2018/03/01 | Source: PASS | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,226 reads

Staying Current on Power BI Dashboards

Power BI Dashboards can be kept current using simple DAX formulas in your data models. Save yourself time and energy by understanding how dashboard tiles work on PowerBI.com and what can be done to set your dashboards to a current period.  Read more...
By Angel Abundez 2018/03/01 | Source: SQLServerCentral.com | Category: powerbi
Rating: |  Discuss |   Briefcase | 935 reads

Object Security in Analysis Services Tabular 2017

Koen Verbeeck looks at how to hide tables or columns in Analysis Services Tabular 2017 for certain users so they are not able to use them in reports or query them.  Read more...
By Additional Articles 2018/03/01 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,236 reads