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

   Items 1 to 20 of 17540    Older >>
 

Ensuring Designs have Flexibility

Ensuring your design has some flexibility is important.  Read more...
By Steve Jones 2019/01/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 4 reads

Getting started with SQL 2019 big data cluster in Azure

Installing and connecting to SQL 2019 big data cluster  Read more...
By Blesson John 2019/01/17 | Source: SQLServerCentral.com | Category: big data cluster
Rating: (not yet rated) |  Discuss |   Briefcase | 67 reads

Saving Data to Various Formats, Using SQL

You have many options when exporting data from a database. In this article, Phil Factor compares several methods including XML and array-in-array JSON for speed and file size.  Read more...
By Additional Articles 2019/01/17 | Source: SimpleTalk | Category: sql
Rating: (not yet rated)  Rate this |   Briefcase | 795 reads

Using T-SQL to Fix Bad Data in XML Documents Using FLWOR

Learn how to use T-SQL to fix contents of an XML document using FLWOR  Read more...
By Additional Articles 2019/01/17 | Source: MSSQLTips.com | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 647 reads

Fun with Dates and Times

Steve talks about storing date and time values at SQLServerCentral.  Read more...
By Steve Jones 2019/01/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 55 reads

Pages and Extents: Stairway to SQL Server Indexes Level 4

We've now seen how indexed and non-indexed tables perform in queries, and established "logical reads" as the metric for query performance. Now it is time to explain why logical reads are an excellent metric and also explain what is actually being read.   Read more...
By David Durant 2019/01/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,314 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2019/01/16 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 81,473 reads

Using T-SQL to find the Greatest Common Divisor (GCD) for any number of integers

In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.  Read more...
By Additional Articles 2019/01/16 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,459 reads

Implementing Stretch Database.

Learn how you can enable the Stretch Database feature in SQL Server 2016.  Read more...
By Deepak Prasad Sahu 2019/01/15 | Source: SQLServerCentral.com | Category: stretch database
Rating: |  Discuss |   Briefcase | 663 reads

Measuring Effectiveness

Being effective is important to Steve. Today he talks about the things you might consider when trying to determine if your group is being effective.  Read more...
By Steve Jones 2019/01/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

New Preview of SQL Server Management Studio Available for Download

On September 24th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Now is the time to download this new preview!  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,120 reads

SQL Server Logical Reads – What do they really tell us?

SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading  Read more...
Rating:  Rate this |   Briefcase | 1,965 reads

The SQL Server LAG Function

The LAG function can really improve performance over the old double JOIN.  Read more...
By Mike Byrd 2019/01/14 | Source: SQLServerCentral.com | Category: lag function
Rating: |  Discuss |   Briefcase | 221 reads

Where's that Snippet?

Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?  Read more...
By Phil Factor 2019/01/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 57 reads

The 2019 State of Database DevOps

All the latest insights on DevOps adoption rates among SQL Server Professionals, with a foreword from Donovan Brown Principal DevOps Manager at Microsoft. Read the report to understand the challenges – and the opportunities – of adopting database DevOps alongside broader DevOps initiatives  Read more...
By 2019/01/14 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 595 reads

Introduction to AWS Elastic Beanstalk

The AWS Elastic Beanstalk feature is a web application provisioning service that allows you to automatically scale as needed. In this article, Gerald Bauer explains how to set up and configure Elastic Beanstalks through the AWS dashboard and Visual Studio.  Read more...
By Additional Articles 2019/01/14 | Source: SimpleTalk | Category: aws
Rating: (not yet rated)  Rate this |   Briefcase | 532 reads

Do you have a security to-do list?

Security is important, and Steve wonders if any of us have a list of things we do that improve security.  Read more...
By Steve Jones 2019/01/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 37 reads

Two Things I Would Change in SSISDB Setup

I suggest these two changes to the SSISDB setup to prevent issues down the road.  Read more...
By Ben Kubicek 2019/01/11 (first published: 2016/03/29) | Source: SQLServerCentral.com | Category: ssisdb
Rating: |  Discuss |   Briefcase | 3,470 reads

Never Judge A Query By Its Cost

Erik shows an example where lower-cost queries take longer to run.  Read more...
By Additional Articles 2019/01/11 | Source: Brent Ozar Unlimited Blog | Category: query
Rating: (not yet rated)  Rate this |   Briefcase | 2,898 reads

Manage Data Across Multiple Sources with Azure Data Studio

Azure Data Studio, now the official name of SQL Operations Studio, was released in September. The biggest news regarding the release is the extensions that are now available, as Julie Lerman describes.  Read more...
By Additional Articles 2019/01/11 | Source: Microsoft MSDN | Category: azure data studio
Rating: (not yet rated)  Rate this |   Briefcase | 1,875 reads
   Items 1 to 20 of 17540    Older >>