SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2017/10/31 to 2017/11/07

Dynamic Data Masking on Azure SQL Database

Azure SQL Database’s Dynamic Data Masking (DDM) feature limits the exposure of sensitive information to non-privileged users. DDM can mask either the full value or partial value in a column. This method can also mask Social Security and Credit Card Numbers without making any changes to the application. Read on to learn more.  Read more...
By Additional Articles 2017/11/07 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,842 reads

Importing Files in Parallel with SSIS

Run multiple instances of your package in parallel so that each instance processes a portion of the total number of files  Read more...
Rating: |  Discuss |   Briefcase | 1,006 reads

How to record T-SQL execution times using a SQL Prompt snippet

In this quick tip, Phil Factor shares the SQL Prompt snippet he uses as a standard testbed for getting execution times for procedures and functions.  Read more...
By 2017/11/07 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 3,694 reads

SQL Code Smells

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. There are now around 150 of these smells and SQL Code Guard is committed to cover as many as possible of them.  Read more...
By Additional Articles 2017/11/06 | Source: SimpleTalk | Category: sql
Rating:  Rate this |   Briefcase | 5,311 reads

Name Value Pairs Table Handling

While Name Value Pairs Tables are anathema to Relational Database professionals, it is sometimes useful to consider such a structure in a production application. This article illustrates the use of User-defined Table Type to improve such handling.  Read more...
By Jerome Boyer 2017/11/06 | Source: SQLServerCentral.com | Category: user-defined table type
Rating: |  Discuss |   Briefcase | 1,206 reads

Azure SQL Database Long-Term Backup Retention

Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. In addition to Point-in-Time Restore as well as Geo-Restore and Active Geo-Replication, you have the option of implementing long-term backup retention of Azure SQL Database.  Read more...
By Additional Articles 2017/11/03 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,171 reads

Why it’s time to think seriously about SQL Server 2017

SQL Server 2017 is now on general release. The latest version of the heavyweight platform is more than the sum of its parts, however, because it doesn’t just deliver new functionality. Alongside the list of extra features, it also changes two important ways we think about the platform itself.  Read more...
By 2017/11/03 | Source: Redgate | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 5,807 reads

Additional Data Files and Proportional Fill

Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads data across multiple files.  Read more...
By David Fundakowski 2017/11/03 (first published: 2016/07/25) | Source: SQLServerCentral.com | Category: filegroups
Rating: |  Discuss |   Briefcase | 1,662 reads

Loading partitioned table incrementally using SSIS

This article gives an example of loading partitioned tables incrementally using SSIS  Read more...
By Shubhankar Thatte 2017/11/02 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 692 reads

What are the leading DevOps drivers in financial services?

DevOps is gaining ground everywhere. By offering a route to releasing software faster, with fewer errors, it can give companies which adopt it an immediate advantage. Unfortunately, it’s not something you can just buy or decide to do tomorrow. Instead, it’s a shift that needs the right guidance to become reality.  Read more...
By 2017/11/02 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,254 reads

Why is My Database Application so Slow?

When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.  Read more...
By Additional Articles 2017/11/02 | Source: SimpleTalk | Category: performance
Rating:  Rate this |   Briefcase | 4,640 reads

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2017/11/01 (first published: 2014/10/29) | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 6,663 reads

Live Query Plans and Blocking

Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,715 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2017/11/01 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 88,493 reads

Six Scary SQL Surprises

The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially true if the DBA is not checking and monitoring the databases for obvious things such as database corruption, and disk space. However, the really scary surprises are less obvious and provide fewer warning signs. Brent Ozar gives six scary surprises that can be avoided by the shrewd DBA.  Read more...
By Additional Articles 2017/10/31 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,994 reads

Create SSRS Data Driven Subscriptions on Standard Edition

This will allow you to create "Data-Driven" subscriptions on your Standard SQL Server version.  Read more...
Rating: |  Discuss |   Briefcase | 794 reads