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

Traditional database security doesn’t protect data

Alex Yates proposes that the features we think of as traditional database security are not sufficient to protect your data.  Read more...
By 2018/07/06 | Source: Redgate | Category: data security
Rating: (not yet rated)  Rate this |   Briefcase | 2,745 reads

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

Either you've got too many indexes, or not enough. Here's how to tell.  Read more...
By Additional Articles 2018/07/06 | Source: Brent Ozar Unlimited Blog | Category: sp_blitz
Rating: (not yet rated)  Rate this |   Briefcase | 2,861 reads

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2018/07/06 (first published: 2016/01/26) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,563 reads

Using Parameters for SQL Server Queries and Stored Procedures

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.  Read more...
By Additional Articles 2018/07/05 | Source: MSSQLTips.com | Category: parameters
Rating: (not yet rated)  Rate this |   Briefcase | 3,767 reads

Creating Compound Interest Calculations in SQL

This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills  Read more...
By Adam Aspin 2018/07/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,298 reads

Moving from application automation to true DevOps by including the database

There is a growing motivation, in many organizations, to integrate database changes into a DevOps process. In this article Tom Austin explains the different methods of getting the database under source control, either by storing per-object state, or migration scripts, or usually both.   Read more...
By 2018/07/05 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,668 reads

Missing Data

Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.  Read more...
By Additional Articles 2018/07/04 | Source: SimpleTalk | Category: null
Rating: (not yet rated)  Rate this |   Briefcase | 2,448 reads

Stairway to Columnstore Indexes Level 9: Batch Mode Execution

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.  Read more...
By Hugo Kornelis 2018/07/04 (first published: 2016/08/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,769 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2019/01/30 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 55,391 reads

Azure SQL Database and GDPR Compliance

In recent years, technology landscape has undergone dramatic changes, driven primarily by cloud computing and a continuously increasing level of attention dedicated to security, privacy, and compliance. One of the more significant initiatives that attempts to address these challenges is General Data Protection Regulation (GDPR. In this article, we will explore how Azure SQL Database could help with addressing the GDPR requirements.  Read more...
By Additional Articles 2018/07/03 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,291 reads

What is SQL Change Automation?

William Brewer explores the features of Redgate's SQL Change Automation  Read more...
By 2018/07/03 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 3,395 reads

Importing Tricky CSV Files with PowerShell

A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell  Read more...
By Stewart Campbell 2018/07/03 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 1,342 reads

Machine Learning 101: The Mathematics of an Artificial Neural Network

This article (1) demonstrates an artificial neural network as it learns to recognize alphanumeric characters and (2) elucidates the mathematics of the feed-forward/back-propagation algorithm the artificial neural network employs.  Read more...
By Stan Kulp 2018/07/02 | Source: SQLServerCentral.com | Category: machine learning
Rating: |  Discuss |   Briefcase | 1,868 reads

Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3

R is a powerful language for manipulating data and creating visualizations. In this article in the series, Robert Sheldon demonstrates how R can be used within Power BI Desktop to import data and to create visualizations.  Read more...
By Additional Articles 2018/07/02 | Source: SimpleTalk | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,512 reads

Troubleshooting Blocking in SQL Server using SQL Monitor

Learn what causes blocking and how you can use SQL Monitor to help solve performance issues.  Read more...
By 2018/07/02 | Source: Redgate | Category: blocking in sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,019 reads

Introducing Microsoft BI Reporting and Analysis Tools

Choose the right BI tool by learning about the different strengths of the Microsoft analysis and reporting tools. Microsoft provides a variety of BI tools that can address key workloads, such as Power BI and Excel. The article discusses the workloads and the tools that best support each workload.  Read more...
By Additional Articles 2018/06/29 | Source: Microsoft MSDN | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 3,393 reads

Data Governance, DevOps, and Delivery

Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to all aspects of continuous delivery.  Read more...
By Additional Articles 2018/06/29 | Source: SimpleTalk | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,296 reads

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2018/06/29 (first published: 2016/02/10) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 4,424 reads