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

<< Newer    Items 21 to 40 of 17734    Older >>
 

Introduction to SQL Server Security — Part 3

SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.  Read more...
By Additional Articles 2019/03/14 | Source: SimpleTalk | Category: data protection
Rating: (not yet rated)  Rate this |   Briefcase | 2,750 reads

Badly Encrypted Databases

Database encryption is hard, and somewhat controversial. Steve thinks we ought to do a better job of it.  Read more...
By Steve Jones 2019/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Using Client Tools - Level 4 of the Stairway to SQL Server on Linux

In the next level of the Stairway to SQL Server on Linux learn about the client tools available to connect to your instance.  Read more...
By Danilo Dominici 2019/03/13 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 280 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 2019/03/13 (first published: 2014/03/05) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 80,323 reads

SQL Server Referential Integrity Across Databases Using Triggers

In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.  Read more...
By Additional Articles 2019/03/13 | Source: MSSQLTips.com | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,109 reads

Dealing with Technical Debt

Technical debt can cripple software development, much like financial debt hurts individuals and organizations. Steve wants to know if you measure your debt today.  Read more...
By Steve Jones 2019/03/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 61 reads

Isolation Levels in SQL Server

Details discussion on the different isolation levels available in SQL Server  Read more...
By Sucharita Das 2019/03/12 | Source: SQLServerCentral.com | Category: sql server
Rating: (not yet rated) |  Discuss |   Briefcase | 878 reads

A Re-Introduction to HIPAA and SOX

SQL Provision can help organizations ensure compliance with regulations such as HIPAA and SOX. But what exactly are these legislations asking of DBAs and how does this impact the work you do? Robert Sheldon provides an overview of the two US regulations in this four-part series.  Read more...
By Additional Articles 2019/03/12 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,187 reads

Using Azure Resource Manager Templates To Provision Azure SQL Databases

Azure provides a number of different methods that can be used in order to implement and configure its resources. Each of the methods differs to some extent in regard to functionality and intended use cases.  Read more...
By Additional Articles 2019/03/12 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,713 reads

Who should have Sysadmin rights?

The point of this article is that only service accounts and/or specific network sql admin accounts should have sysadmin rights.  Read more...
By Ben Kubicek 2019/03/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 55 reads

SQL Server DevOps with Production Databases and Git

Learn how to start using DevOps techniques to upgrade your database containers with the latest version of your code from a git repository.  Read more...
By Paul Stanton 2019/03/11 | Source: SQLServerCentral.com | Category: devops
Rating: |  Discuss |   Briefcase | 624 reads

Microservice Reality

Phil Factor argues that very few processes, even in well-established businesses, mimic the dreamy clarity and autonomy of a microservice.  Read more...
By Phil Factor 2019/03/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 48 reads

Calling all Oracle Database users

We’re excited to announce that Redgate is doubling its efforts on Oracle and committed to aligning its DevOps solution across both SQL Server and Oracle. Please take a few minutes to complete this short survey to stay up-to-date on our Oracle developments.  Read more...
By Additional Articles 2019/03/11 | Source: Redgate | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 2,016 reads

The BI Journey: The Expert’s Advice – Part 1

Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is spent on the underlying model, it won't be adaptable enough to grow. In this article by Gogula Aryalingam, you'll see how the advice of a mentor helped a newbie understand how to create a flexible model that will lead to a valuable BI solution.  Read more...
By Additional Articles 2019/03/11 | Source: SimpleTalk | Category: bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,883 reads

The OUTPUT Clause for the MERGE Statements

In this article, I will provide a set of examples to showcase the use of OUTPUT clause within the MERGE statement and how to capture the OUTPUT clause results into an archive table.  Read more...
By Amarendra Reddy Thummeti 2019/03/08 (first published: 2017/06/08) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,502 reads

Databasee Brainstorming

We sometimes need to think differently about different situations. Steve notes that we might approach the way we solve problems in new ways.  Read more...
By Steve Jones 2019/03/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Benefits of Data Masking highlighted in Gartner’s 2018 Market Guide

Gartner released their 2018 Market Guide for Data Masking, providing an in-depth analysis of the market with recommendations and representative vendors – including Redgate. Gartner says that "Test data (or copy data) virtualization is a technology that is increasingly popular, when used in combination with SDM (Static Data Masking), to speed up the provisioning of and updates to target environments, in addition to significantly reducing the amount of storage required by these environments.”   Read more...
By Additional Articles 2019/03/08 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,754 reads

What does Azure SQL DB Automatic Index Tuning actually do, and when?

Azure SQL DB’s Automatic Tuning will create and drop indexes based on your workloads. Brent's latest blog post shows how to enable it and explains what it actually does.   Read more...
By Additional Articles 2019/03/08 | Source: Brent Ozar Unlimited Blog | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,461 reads

Common Data Challenges

Steve wonders about the common challenges you may face.  Read more...
By Steve Jones 2019/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Introducing SQL+ Dot Net

SQL+.net is the first real innovation in data access for quite some time, and was built exclusively for SQL developers.  Read more...
By Alan Hyneman 2019/03/07 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 1,889 reads
<< Newer    Items 21 to 40 of 17734    Older >>