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

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

Explicit Transactions

There are frequent misunderstandings about Explicit Transactions, not limited to use of 'nested transactions'. This article attempts to explain by example many of the behaviors of this feature.  Read more...
By Steve Hall 2018/07/13 (first published: 2015/12/30) | Source: SQLServerCentral.com | Category: explicit transactions
Rating: |  Discuss |   Briefcase | 5,328 reads

The MVP Award Looks Backward

Steve has a few thoughts on the Microsoft MVP award.  Read more...
By Steve Jones 2018/07/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 54 reads

What to Do When SQL Server is Slow

Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.  Read more...
By Additional Articles 2018/07/13 | Source: Brent Ozar Unlimited Blog | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 4,744 reads

Improving legacy code using SQL Prompt code analysis

Tom Walsh explains how to use Redgate's SQL Prompt to improve legacy code  Read more...
By 2018/07/13 | Source: Redgate | Category: sql prompt
Rating: (not yet rated)  Rate this |   Briefcase | 1,934 reads

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 | 659 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,762 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

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,165 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,252 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 | 831 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,979 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,992 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 | 526 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 | 47 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,456 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,176 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 | 848 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 | 64 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
<< Newer    Items 21 to 40 of 16996    Older >>