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

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

dbatools is Growing Up

The dbatools project is rapidly expanding. 
By Steve Jones 2018/03/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 97 reads

Driving up database coding standards using SQL Prompt

This article will demonstrate how a team can use SQL Prompt to establish and share coding standards, through code analysis rules, formatting styles and code snippets.  Read more...
By 2018/03/29 | Source: Redgate | Category: coding standards
Rating: (not yet rated)  Rate this |   Briefcase | 3,435 reads

SQL Server Graph Databases – Part 1: Introduction

SQL Server 2017 now includes a new feature to represent complex relationships in data called Graph Databases. Robert Sheldon introduces Graph Databases in the first article of this new series.  Read more...
By Additional Articles 2018/03/29 | Source: SimpleTalk | Category: sql server graph database
Rating: (not yet rated)  Rate this |   Briefcase | 4,019 reads

The Nightmare Letter

The GDPR may bring nightmare letters like the one linked to from the editorial.  Read more...
By Steve Jones 2018/03/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory

Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.  Read more...
By Mike McQuillan 2018/03/28 | Source: SQLServerCentral.com | Category: azure
Rating: (not yet rated) |  Discuss |   Briefcase | 242 reads

Free eBook: SQL Server Backup and Restore

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.  Read more...
By Press Release 2018/03/28 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 69,096 reads

How does GDPR impact your SQL Server Recovery Plans

With GDPR on the imminent horizon, there are many things that Data Platform engineers need to consider with regards to the rights of data subjects. Primary among these is understanding the impact of requests to be forgotten and updates to a person's data when it comes to restoring databases. If you have data that is within the scope of the GDPR then here are some thoughts on extra processes for your DR planning.  Read more...
By Additional Articles 2018/03/28 | Source: MSSQLTips.com | Category: gdpr
Rating: (not yet rated)  Rate this |   Briefcase | 3,084 reads

SQL Server 2016 Availability Group - Automatic Seeding with SSMS 17.x

In SQL Server 2016 the availability group automatic seeding functionality is implemented. This article will detail the steps to use of SSMS with automatic seeding and its limitations.  Read more...
By PremKumar Raju 2018/03/27 | Source: SQLServerCentral.com | Category: availability group (ag)
Rating: |  Discuss |   Briefcase | 461 reads

How to Send a TDE Encrypted Backup to Someone Outside Your Organization

Once you enable your database to be encrypted with Transparent Data Encryption (TDE), the physical database files, and the database backups are encrypted. If your database and database backup are encrypted, then how can you send the encrypted backup to a person outside your organization?  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,723 reads

Small Changes and Big Impacts

Using new features and changing code can cause problems in your environment. Always test to be sure that the impact is acceptable.  Read more...
By Steve Jones 2018/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

SQL Server 2017 for Linux first impression

Microsoft has released a version of SQL Server 2017 for Linux.  Read more...
By Evgeny Garaev 2018/03/26 | Source: SQLServerCentral.com | Category: sql server 2017
Rating: |  Discuss |   Briefcase | 906 reads

Monitoring and Troubleshooting Deadlocks with SQL Monitor

This article will discuss why deadlocks occur, why they require immediate investigation by the DBA, and the diagnostic data required to troubleshoot them.  Read more...
By 2018/03/26 | Source: Redgate | Category: deadlocks
Rating: (not yet rated)  Rate this |   Briefcase | 3,549 reads

A True Lift and Shift

Microsoft bought a data center. 
By Steve Jones 2018/03/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

READ COMMITTED SNAPSHOT ISOLATION and High version_ghost_record_count

Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it is not without its own pitfalls. In this article, Uwe Ricken describes a situation where long running transactions caused a severe performance degradation when RCSI was in use.  Read more...
By Additional Articles 2018/03/26 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 2,726 reads

Ad Hoc Logs

We often make changes to production systems in an ad hoc manner. Steve asks how much auditing we might have in place.  Read more...
By Steve Jones 2018/03/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

Getting query text from SSMS into a CSV with PowerShell

You have times where you need to copy/paste something out of SSMS' grid view results pane that has a carriage return in it. Trying to copy/paste that data into Excel can be a headache and cause you to waste precious time reformatting. This just offers a tidbit of PowerShell code to help.  Read more...
By Shawn Melton 2018/03/23 (first published: 2015/09/07) | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 5,572 reads

Thinking about microservices? You need DevOps first

With the rise of new virtualization technologies using containers, people are starting to think more and more about using microservices in their organizations. They’ve been getting a lot of attention and companies like Netflix, Amazon, Uber, and Spotify have attributed some of their recent success to using them.   Read more...
By 2018/03/23 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,996 reads

Scripting the Description of Database Tables Using Extended Properties

Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and a CREATE or ALTER script contains everything to reproduce the proc. SQL Server tables, however, are more difficult to document. You can use Extended Properties to document columns and constraints, but working with Extended Properties is difficult at best. Phil Factor demonstrates ways to easily add Extended Properties to your build scripts.  Read more...
By Additional Articles 2018/03/23 | Source: SimpleTalk | Category: extended properties
Rating: (not yet rated)  Rate this |   Briefcase | 3,141 reads

The DefaultBufferMaxRows and DefaultBufferSize Properties in SSIS

This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.  Read more...
By SPT 2018/03/22 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 616 reads
<< Newer    Items 61 to 80 of 16719    Older >>