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

<< Newer    Items 61 to 80 of 16623    Older >>

So what is a Data Privacy Impact Assessment and why should organizations care?

If you’ve read anything about the upcoming General Data Protection Regulation (GDPR), you’ll probably have seen the phrase Data Privacy Impact Assessment (DPIA) used. This article explains exactly what it is, and outlines the four areas its expected to address.  Read more...
By 2018/02/26 | Source: Redgate | Category: data privacy
Rating: (not yet rated)  Rate this |   Briefcase | 2,721 reads

How to Suck at Database Administration

Tara Kizer outlines 15 telltale signs that you aren't a very good senior DBA.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,349 reads

Build a Career Radar

A technology radar can help you assess what's important and where to focus your effort. Companies use these, and Steve Jones says you should as well.  Read more...
By Steve Jones 2018/02/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

Get Set For Speed

Loops are common in application code, but set-based solutions are the way to go with SQL.  Read more...
By Tom Staab 2018/02/23 (first published: 2015/12/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,106 reads

"But It Worked in Development!" - 3 Hard SQL Server Performance Problems

You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment.  Read more...
By Additional Articles 2018/02/23 | Source: Brent Ozar Unlimited Blog | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 5,547 reads

Avoid T-SQL Technical Debt using SQL Prompt Code Analysis

SQL Prompt’s new Code Analysis feature helps you discover code issues and hidden pitfalls during code development, as you type. In this article, Catherine shows how the Code Analysis feature works, and illustrates how to use the feature to improve the quality of your team’s SQL code.  Read more...
By 2018/02/23 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,075 reads

Performance Comparison Between SQL Server 2014 and 2016

This article outlines the performance innovations in SQL Server 2016 for Columnstore Index and BatchMode Execution.  Read more...
By Savaram Ravindra 2018/02/22 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 1,389 reads

Introducing a DevOps culture

Your organization’s culture of DevOps will often be the defining factor on whether you have a successful organizational change, or whether the changes that you implement impact pockets of your organization.  Read more...
By 2018/02/22 | Source: Redgate | Category: devops
Rating:  Rate this |   Briefcase | 3,575 reads

An AI Loophole

We can't always explain how AI systems work. Steve Jones wonders if this is a loophole in the GDPR legislation.  Read more...
By Steve Jones 2018/02/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 44 reads

Degree of Duplication

Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe Celko reminisces about the history of database design and how it relates to the concept of ‘Degree of Duplication’ in this article.  Read more...
By Additional Articles 2018/02/22 | Source: SimpleTalk | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 3,073 reads

Brush Up on Your ETL Skills

The need for data imports, exports, and transformations seems to be growing.  Read more...
By Steve Jones 2018/02/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 86 reads

Stairway to Database Design Level 9: Normalization

In the final step of Database Design, Joe Celko gives a simple but effective explanation of the normalization process and why it is important.  Read more...
By Joe Celko 2018/02/21 (first published: 2011/11/11) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,443 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 2018/02/21 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 93,556 reads

SQL Server Reporting Services 2017 Tutorial

SQL Server Reporting Services has been the go to reporting solution for SQL Server for almost a decade now. In many organizations, the ease of development, web front end and security make SSRS the tool of choice.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,061 reads

Virtual Data

The ability to abstract away production databases is becoming a hot technology.  Read more...
By Steve Jones 2018/02/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Solve Sudoku with T-SQL - Part 1

A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.  Read more...
By bevan ward 2018/02/20 | Source: SQLServerCentral.com | Category: tsql
Rating: |  Discuss |   Briefcase | 1,866 reads

How to Move a TDE Encryption Key to Another SQL Server Instance

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only restore the database backup to an instance that contains the same certificate used to originally encrypt the database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,807 reads

Sign up for more free training from Redgate

Redgate has committed to hosting a free virtual event in every quarter of 2018, and will be kicking this off on February 28 with a livestream themed around data privacy and protection. The agenda has now been released, so you can see who will be presenting, what they will be presenting, and how you can tune in to watch.  Read more...
By 2018/02/20 | Source: Redgate | Category: event
Rating: (not yet rated)  Rate this |   Briefcase | 2,990 reads

Production Subsets

Working with data in development or test environments can be challenging. This week Steve Jones asks how you might deal with the volume of data and whether you like subsets.  Read more...
By Steve Jones 2018/02/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 130 reads
<< Newer    Items 61 to 80 of 16623    Older >>