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

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

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,748 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 | 516 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 | 43 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,145 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 | 1,908 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 | 827 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 | 61 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 | 45 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,344 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,492 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 | 90 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,470 reads

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

Either you've got too many indexes, or not enough. Here's how to tell.  Read more...
By Additional Articles 2018/07/06 | Source: Brent Ozar Unlimited Blog | Category: sp_blitz
Rating: (not yet rated)  Rate this |   Briefcase | 2,533 reads

Traditional database security doesn’t protect data

Alex Yates proposes that the features we think of as traditional database security are not sufficient to protect your data.  Read more...
By 2018/07/06 | Source: Redgate | Category: data security
Rating: (not yet rated)  Rate this |   Briefcase | 2,510 reads

Creating Compound Interest Calculations in SQL

This is the first article in a short series of SQL Server query challenges to test and expand your SQL Server querying skills  Read more...
By Adam Aspin 2018/07/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 940 reads

#SQLCareer

Today Steve has a challenge for you. Share what it's like in your daily work.  Read more...
By Steve Jones 2018/07/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 76 reads

Moving from application automation to true DevOps by including the database

There is a growing motivation, in many organizations, to integrate database changes into a DevOps process. In this article Tom Austin explains the different methods of getting the database under source control, either by storing per-object state, or migration scripts, or usually both.   Read more...
By 2018/07/05 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,387 reads

Using Parameters for SQL Server Queries and Stored Procedures

One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.  Read more...
By Additional Articles 2018/07/05 | Source: MSSQLTips.com | Category: parameters
Rating: (not yet rated)  Rate this |   Briefcase | 3,362 reads

Stairway to Columnstore Indexes Level 9: Batch Mode Execution

In this level, Hugo explains what batch mode execution is, how it differs from row mode execution, and what its limitations are.  Read more...
By Hugo Kornelis 2018/07/04 (first published: 2016/08/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,529 reads

The Fourth of July in 2018

Steve talks a bit about the mid year break in the US  Read more...
By Steve Jones 2018/07/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 33 reads
<< Newer    Items 21 to 40 of 16984    Older >>