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

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

Generating Completely Random Sample Output from a Dataset

This short article shows a simple example of how to generate completely random sample output from a Dataset  Read more...
By Adam Aspin 2018/07/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 654 reads

Help Redgate do a better job (and win a $250 Amazon voucher)

Could you spare a few minutes to help Redgate improve its products and services? They’re running a survey of their users and the wider SQL Server community and they’d appreciate your insights. As a thank you for taking part, you’ll also be entered in a prize draw for a $250 Amazon Voucher.   Read more...
By 2018/07/17 (first published: 2018/07/09) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,663 reads

Principles of Data Protection

Protecting data in SQL Server is not as simple as setting a few properties. While there are great security features in SQL Server, such as Transparent Data Encryption, production data may end up in places throughout the organization. In this article, Brian Kelley talks about the best ways to secure data using the concept of least privilege.  Read more...
By Additional Articles 2018/07/12 | Source: SimpleTalk | Category: data privacy and protection
Rating: (not yet rated)  Rate this |   Briefcase | 2,073 reads

AI Regulators

AI may help enforce the GDPR.  Read more...
By Steve Jones 2018/07/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 27 reads

SQL Change Automation with PowerShell Scripts: getting up-and-running

In this article, Phil Factor demonstrates how to use SQL Change Automation, a PowerShell script, to take the contents of a source control directory for a database, check that it is possible to build from it, document it and then create a NuGet package and place the code in it, along with the documentation.   Read more...
By 2018/07/12 | Source: Redgate | Category: sql change automation
Rating: (not yet rated)  Rate this |   Briefcase | 2,149 reads

Stairway to AlwaysOn Crossword

This crossword puzzle is based on the contents of the Stairway to AlwaysOn.  Read more...
By Kenneth Fisher 2018/07/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Stairway to SSAS Tabular Level 1: Why use Analysis Services

In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.  Read more...
By Thomas LeBlanc 2018/07/11 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 820 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/07/11 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 97,882 reads

Examples of using XQuery to update XML Data in SQL Server

What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three operational keyword sets: insert, replace value of, and delete. Seth Delconte takes a closer look.  Read more...
By Additional Articles 2018/07/11 | Source: MSSQLTips.com | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 1,891 reads

Ensuring Each Client has a Full Set of Key-Value Pairs

In this piece, we find out about a business issue that can occur when using key value pairs in your database to describe information about other entities.  Read more...
By Steve Jones 2018/07/10 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 523 reads

Serverless Code

Steve talks about the costs of serverless computing in the cloud.  Read more...
By Steve Jones 2018/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 reads

Automatic Query Performance Tuning in SQL Server Database

In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.  Read more...
By Additional Articles 2018/07/10 | Source: Database Journal | Category: performance and tuning
Rating: (not yet rated)  Rate this |   Briefcase | 3,332 reads

Building Better Test Data with SQL Provision

Steve Jones discusses building Better Test Data with SQL Provision  Read more...
By 2018/07/10 | Source: Redgate | Category: sql provision
Rating: (not yet rated)  Rate this |   Briefcase | 2,081 reads

Installing SSDT and creating your first SSIS Package

SQL Server Data Tools (SSDT) is a toolset which provides an environment for you to carry out all your database design work in SQL Server. It can be used to build to build SQL Server relational databases.   Read more...
Rating: |  Discuss |   Briefcase | 840 reads

The GDPR is Coming to the US

Steve discusses a new California law and data privacy.  Read more...
By Steve Jones 2018/07/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 63 reads

Dealing with Disparate Goals

Grant talks about the lessons of history when the goals of different groups don't align.  Read more...
By Grant Fritchey 2018/07/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 47 reads

Help Redgate do a better job (and win a $250 Amazon voucher)

Could you spare a few minutes to help Redgate improve its products and services? They’re running a survey of their users and the wider SQL Server community and they’d appreciate your insights. As a thank you for taking part, you’ll also be entered in a prize draw for a $250 Amazon Voucher.   Read more...
By 2018/07/17 (first published: 2018/07/09) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,663 reads

Azure and Windows PowerShell: Getting Information

In the second part of his series, Nicolas Prigent describes in detail how to automate the login process using PowerShell and Azure CLI. Nicolas also explains how to retrieve information about your Azure subscription.  Read more...
By Additional Articles 2018/07/09 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 1,628 reads

Who Likes NULL?

The use of NULL values in a database can be controversial. Today Steve talks about his views on this concept.  Read more...
By Steve Jones 2018/07/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2018/07/06 (first published: 2016/01/26) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,478 reads
<< Newer    Items 21 to 40 of 16992    Older >>