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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,909,322 DBAs, developers and SQL Server users

Headlines today   November 12, 2018

Linear barcodes in SSRS using the Barcode Image Generation Library

The open source Barcode Image Generation Library enables insertion of twenty-seven different types of linear barcode symbols into SSRS reports without the use of barcode fonts.  Read more...
By Stan Kulp 2018/11/12 | Source: SQLServerCentral.com | Category: ssrs
Rating: |  Discuss |   Briefcase | 441 reads

Getting executive buy in for DevOps - 3 top tips Webinar

In this webinar, Microsoft MVP Kendra Little will discuss the value of DevOps from the perspectives of CEOs, CIOs/CTOs, and Managers. She will explore how the role of CIOs and CTOs are undergoing a major transformation, and how DevOps aligns with that transformation.  Read more...
By 2018/11/12 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,050 reads

Testing PowerShell Modules with Pester

In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the functions in a PowerShell module.  Read more...
By Additional Articles 2018/11/12 | Source: SimpleTalk | Category: pester
Rating: (not yet rated)  Rate this |   Briefcase | 989 reads
Previous headlines

Datatypes and the Default Mask with Dynamic Data Masking

This article digs deeper into the ways that Dynamic Data Masking works with different data types.  Read more...
By Steve Jones 2018/11/09 (first published: 2016/03/23) | Source: SQLServerCentral.com | Category: dynamic data masking
Rating: |  Discuss |   Briefcase | 1,726 reads

Unused Indexes - Are they really unused or have they just not been used YET?

Tara explains when index DMVs gets reset by telling a story from her dark past.  Read more...
By Additional Articles 2018/11/09 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,306 reads

2019 State of Database DevOps – Take the survey!

Database development practices are more integral than ever to DevOps success. How are we saving time, automating processes, deploying more frequently, all whilst keeping business critical data secure? Take part in the survey for an advanced copy of the research report, and a chance to win a $250 Amazon voucher.   Read more...
By 2018/11/09 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,178 reads

T-SQL Decommenter Part I

Introduction to a T-SQL query that remove comments from T-SQL code  Read more...
By Toby Ovod-Everett 2018/11/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,084 reads

Azure EA Financial Reporting and Granular Access to Data Through the Enterprise

With the billing data from your Azure Enterprise Agreement collected into one database, it is still necessary to break down the costs and provide access to the correct departments and individuals. This is important for chargeback and further analysis. In this article, Feodor Georgiev demonstrates how to provide granular access to the billing data.  Read more...
By Additional Articles 2018/11/08 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,469 reads

Help Redgate improve Data Masker for SQL Server?

Redgate are looking for people to help them get a deep understanding of compliance and SQL Server data masking requirements in order to ensure they can provide a world class solution. In return for your feedback you’ll have early access to new releases, insights into new features and their ongoing support to get up and running.   Read more...
By 2018/11/08 | Source: Redgate | Category: data masking
Rating:  Rate this |   Briefcase | 1,202 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 2018/11/07 (first published: 2017/06/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,696 reads

From the SQLServerCentral Blogs

SQLCLR vs SQL Server 2017, Part 9: Does PERMISSION_SET Still Matter, or is Everything Now UNSAFE?

(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC ) SQL Server 2017 introduced a new security restriction for SQLCLR in the...  Read more...
By Solomon Rutzky 2018/11/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,403 reads

Zombie SQL

It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but...  Read more...
By Kenneth Fisher 2018/11/12 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,093 reads
Question of the Day

Short Masks

By Steve Jones 2018/11/12 | Category: dynamic data masking
Rating: (not yet rated) |  Discuss |   Briefcase | 356 reads

I put a mask on my OrderDetail table as follows:

ALTER TABLE dbo.OrderDetail
ALTER COLUMN ProductName ADD MASKED WITH (FUNCTION ='partial(5, "xxxxxx", 0)')
In this table, I have a product named... 
Latest forum posts