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

   Items 1 to 20 of 17178    Older >>
 

Rollbacks Are Normal

At Google, rollbacks from deployments are normal.  Read more...
By Steve Jones 2018/09/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 35 reads

Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages

In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.  Read more...
By Andy Leonard 2018/09/19 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 256 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/09/19 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 99,398 reads

The Changing Role of SQL Server Monitoring

As SQL Server estates continue to grow quickly, and change in nature, due to the ease with which new cloud-based, containerized or virtual machine-based SQL Servers can be provisioned, so too the role of the monitoring tool changes.  Read more...
By 2018/09/19 | Source: Redgate | Category: sql monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,070 reads

Loading CSV Files Using Dynamic SQL

In this article, we will see of a quick way to load CSV files from a directory on your computer.  Read more...
By Steven Tidwell 2018/09/18 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 1,309 reads

Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report

SQL Server Central editor Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps.  Read more...
By 2018/09/18 (first published: 2018/08/31) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 7,788 reads

Monitoring Costs

There are lots of costs to monitoring your systems that many people ignore.  Read more...
By Steve Jones 2018/09/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 35 reads

Azure SQL Database High Availability

Site-wide or region-wide disasters, while undoubtedly more impactful, happen considerably less frequently than downtime resulting from scheduled maintenance events or isolated hardware and software faults. This article provides an overview of the high availability features of Azure SQL Database that mitigate risks affecting services within an individual Azure datacenter, rather than an entire Azure region.  Read more...
By Additional Articles 2018/09/18 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 1,333 reads

Dark Reads During a Migration

An interesting technique for deploying changes.  Read more...
By Steve Jones 2018/09/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

Check your default constraints

Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.  Read more...
By Andy Robertson 2018/09/17 | Source: SQLServerCentral.com | Category: default constraint
Rating: |  Discuss |   Briefcase | 570 reads

We Need Data Privacy Consistency

Steve talks about the disparate regulations we face for data privacy and protection.  Read more...
By Steve Jones 2018/09/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 23 reads

Avoid running out of Disk Space ever again using SQL Monitor

If your SQL Server runs out of disk space, and it is running a database for an enterprise’s trading application, then the company can’t take money until the DBA fixes the problem. In this article Tony Davis shows you how to avoid this scenario using SQL Monitor.  Read more...
By 2018/09/17 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,042 reads

Examples and Function for Using SQL Server LIKE Operator and Wildcard Characters

In this tip we look at different examples of how to use the LIKE operator to get the correct results when strings contain wildcard characters. We will also look a function to make this easier to do.  Read more...
By Additional Articles 2018/09/17 | Source: MSSQLTips.com | Category: like
Rating:  Rate this |   Briefcase | 2,332 reads

How Do You Setup Your Instances?

This week Steve wonders if you have a process for setting up your new instances.  Read more...
By Steve Jones 2018/09/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 reads

Introduction to Microsoft R Services in SQL Server 2016

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.  Read more...
By Tomaž Kaštrun 2018/09/14 (first published: 2016/09/15) | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 4,100 reads

Single-Column-Key Missing Index Recommendations are Usually Wrong.

When Clippy suggests an index with only one key, look closer.  Read more...
By Additional Articles 2018/09/14 | Source: Brent Ozar Unlimited Blog | Category: index count
Rating: (not yet rated)  Rate this |   Briefcase | 2,324 reads

TRY_PARSE

Introducing the PARSE function, brought to us in SQL Server 2012.  Read more...
By Matthew McGiffen 2018/09/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,434 reads

Defending the RDBMS

An attack and defense of using relational data stores.  Read more...
By Steve Jones 2018/09/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 72 reads

How to Linux for SQL Server DBAs — Part 1

As running SQL Server on Linux becomes more common, DBAs must learn and become comfortable with the Linux OS. In this article, Kellyn Pot'Vin-Gorman demonstrates how to create a SQL Server instance running in Linux via a Docker container.  Read more...
By Additional Articles 2018/09/13 | Source: SimpleTalk | Category: linux sql server
Rating: (not yet rated)  Rate this |   Briefcase | 2,288 reads

It’s official: database development is now part of DevOps

You’ll probably have heard of the Accelerate State of DevOps Report from DORA. Now in its fifth year and backed by rigorous research involving 30,000+ professionals worldwide, it has consistently shown that higher software delivery performance delivers powerful business outcomes.  Read more...
By 2018/09/13 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,384 reads
   Items 1 to 20 of 17178    Older >>