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,415 DBAs, developers and SQL Server users

Headlines today   November 15, 2018

T-SQL Decommenter Part II

Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.  Read more...
By Toby Ovod-Everett 2018/11/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 285 reads

SOX and Database Administration – Part 3

Database administrators are typically responsible for the security and availability of financial data. In this article, Robert Sheldon discusses SOX, passed in 2002, that governs financial data of publicly traded companies in the US.  Read more...
By Additional Articles 2018/11/15 | Source: SimpleTalk | Category: compliance
Rating: (not yet rated)  Rate this |   Briefcase | 756 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/15 (first published: 2018/11/26) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,747 reads
Previous headlines

Free eBook: SQL Server Execution Plans, Third Edition

If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.  Read more...
By Press Release 2018/11/14 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 115,514 reads

Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell

This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.  Read more...
By Ben Miller 2018/11/14 (first published: 2015/12/16) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,476 reads

The Benefits of Adopting Compliant Database DevOps at PASS

The GDPR presented a challenge for PASS - a community of over 250,000 data professionals with almost 300 Local Groups around the world and 24 Virtual Groups. This whitepaper shows how PASS were able to introduce compliance by default with the new data privacy regulations by using Redgate's solutions to apply DevOps practices to the database.   Read more...
By 2018/11/14 | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 770 reads

CosmosDB Change Feed Processing

This article was created to help readers understand CosmosDB change feed processing.   Read more...
By Gary Strange 2018/11/13 | Source: SQLServerCentral.com | Category: cosmosdb
Rating: (not yet rated) |  Discuss |   Briefcase | 291 reads

Redgate acknowledged as a representative vendor in Gartner’s 2018 Market Guide for Data Masking

Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking.  Read more...
By Press Release 2018/11/13 (first published: 2018/10/30) | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,917 reads

Overview of In-Memory Technologies of Azure SQL Database

Azure SQL Database offers a straightforward approach to controlling its performance through vertical scaling. Despite its simplicity, scaling up has obvious pricing implications and, while it is an online operation, it might result in rollback of in-flight transactions. If you are looking for a supplemental approach to enhancing performance, then you might want to consider implementing in-memory technologies which are part of the Azure SQL Database feature set.  Read more...
By Additional Articles 2018/11/13 | Source: Database Journal | Category: in-memory
Rating: (not yet rated)  Rate this |   Briefcase | 1,467 reads

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 | 601 reads

From the SQLServerCentral Blogs

Learning New Skills

This post is a response to this month’s T-SQL Tuesday #108 prompt by Malathi Mahadevan.  T-SQL Tuesday is a way...  Read more...
By Bert Wagner 2018/11/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,416 reads

T-SQL Tuesday – Non-SQL Server Technologies

So, this month’s T-SQL Tuesday topic is to think about a non-SQL Server technology that we want to learn. For me,...  Read more...
By david.fowler 42596 2018/11/15 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,248 reads
Question of the Day

Building an AG

By Steve Jones 2018/11/15 | Category: availability group (ag)
Rating: (not yet rated) |  Discuss |   Briefcase | 173 reads

In SQL Server 2016, when deploying an Availability Group on Windows, a Windows Server Failover Cluster (WSFC) is needed.

Latest forum posts