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

Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package

In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,109 reads

Cost estimation for SQL Server Azure VMs

This article provides pricing guidance for SQL Server virtual machines in Azure.  Read more...
By Deepak Prasad Sahu 2018/12/03 | Source: SQLServerCentral.com | Category: azure iaas vm
Rating: |  Discuss |   Briefcase | 580 reads

Monitoring Changes in Permissions, Users, Roles and Logins

Compliance means keeping a close grip on any changes to the permissions and access control of a database. Sadly, the law has had to acknowledge, from bitter experience, that it is not just external intruders who want to do this, but it could also be attempts at fraud or data theft from within the organisation. Permission changes are certainly one of the things that security experts advise you look out for; you need the equivalent of CCTV trained on your servers.  Read more...
By 2018/12/03 | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,793 reads

The Curse of Cursor Options

Books Online says the FAST_FORWARD option has "performance optimizations enabled," but they didn't say if they were good. It turns out they're not.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,019 reads

A Basic Technique for Masking Address Data using Data Masker

Grant Fritchey shows how to use Data Masker to obfuscate address data, wile ensuring that the masked data retains the characteristics and distribution of real address information.  Read more...
By 2018/11/30 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,699 reads

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.  Read more...
By J. Drew Allen 2018/11/30 (first published: 2016/10/06) | Source: SQLServerCentral.com | Category: fifo queues
Rating: |  Discuss |   Briefcase | 3,973 reads

Meeting Preparation for SQL Server Projects

Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.  Read more...
By Additional Articles 2018/11/29 | Source: MSSQLTips.com | Category: meetings
Rating: (not yet rated)  Rate this |   Briefcase | 2,515 reads

T-SQL Decommenter Part IV

Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.  Read more...
By Toby Ovod-Everett 2018/11/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 519 reads

Adopting Compliant Database DevOps at PASS

To help meet the requirements of the GDPR, PASS teamed up with Redgate to implement Compliant Database DevOps. This benchmark process has streamlined PASS’ database development pipeline, and strengthened their ability to uphold data privacy regulations such as the GDPR.   Read more...
By 2018/12/11 (first published: 2018/11/14) | Source: Redgate
Rating: (not yet rated)  Rate this |   Briefcase | 7,098 reads

SQL Server on Amazon Web Services (AWS)

Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazon Web Services (AWS).  Read more...
By Additional Articles 2018/11/28 | Source: Database Journal | Category: aws
Rating: (not yet rated)  Rate this |   Briefcase | 2,383 reads

Stairway to SQL Server Extended Events Level 4: Extended Events Engine - Essential Concepts

In this level, we're going to dig a little deeper into the Extended Events engine, its architecture, and fundamental components. It will give you a deeper understanding of why, in general, an Extended Events session is inherently lower in overhead than an equivalent SQL Trace. We'll also investigate how to design our event sessions to minimize any unnecessary overhead during event data collection, even when we need to create relatively complex event sessions to investigate difficult performance problems.  Read more...
By Erin Stellato 2018/11/28 (first published: 2016/08/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,843 reads

New Whitepaper: Data Protection and Compliance During Provisioning

Data privacy and protection is a large concern across all organizations and knowing how to best approach it can be daunting. Grant Fritchey unpicks US legislations HIPAA and SOX to uncover exactly what is required of you and your team to ensure compliance. Download your free copy.   Read more...
By 2018/11/28 | Source: Redgate | Category: data protection
Rating: (not yet rated)  Rate this |   Briefcase | 2,149 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2019/02/06 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 104,952 reads

SQL Server Auditing for HIPAA and SOX – Part 4

Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.  Read more...
By Additional Articles 2018/11/27 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,291 reads

Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.  Read more...
By Steve Jones 2018/11/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 772 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/27 (first published: 2018/10/30) | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 4,921 reads

Data Migration Assistant tool for Azure SQL DB/Azure VM Assessment

Data Migration Assistant (DMA) to Check for SQL Server Compatibility Issues and Perform assessment when Migrating to Azure SQL Database or to SQL Server on an Azure Virtual machine.  Read more...
Rating: |  Discuss |   Briefcase | 172 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/26 (first published: 2018/11/26) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 5,809 reads

Monitoring Azure Health Status Using Azure Portal - Part 1

In this tip we look at how you can monitor Azure health to know if there are any issues that may interupt your services running on Azure.  Read more...
By Additional Articles 2018/11/26 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,935 reads