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

   Items 1 to 20 of 16188    Older >>
 

All DevOps All Day

An online DevOps conference is taking place tomorrow, October 24, 2017.  Read more...
By Steve Jones 2017/10/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 12 reads

Azure DWH part 19: Backup and Restore SSAS

In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.  Read more...
By Daniel Calbimonte 2017/10/23 | Source: SQLServerCentral.com | Category: ssas
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads

Tell the Judge You Have No Backup

The NYPD is claiming there isn't a backup for one of their databases.  Read more...
By Steve Jones 2017/10/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 17 reads

9 New Features with SQL Server 2017

Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.  Read more...
By Additional Articles 2017/10/23 | Source: Database Journal | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 1,485 reads

How Redgate use SQL Clone internally to provision databases

A common thread behind the software Redgate develop is a problem or issue they’ve come across in the software development process. They then adopt the software themselves, which gives us a real understanding of the features that need to be developed further. To gain a deeper insight into SQL Clone, this interview was conducted with Joseph Woodhouse, Redgate's IT Manager, to find out about how it’s being used to implement a new database provisioning process at Redgate.  Read more...
By 2017/10/23 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 389 reads

A Tale of Partition Schemes and Disappearing Dragons

A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.  Read more...
By Porter James 2017/10/20 (first published: 2015/11/02) | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 3,966 reads

The Remote Balance

Telecommuting and remote work are growing in many fields, but especially technology. However the practice needs to be balanced with the notion that you still have a life outside of work.  Read more...
By Steve Jones 2017/10/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 172 reads

Overview of Azure Data Lake

Azure Data Lake stores petabytes of data and analyzes trillions of objects in one place with no constraints. Data Lake Store can store any type of data including massive data like high-resolution video, medical data, and data from a wide variety of industries. Data Lake Store scales throughput to support any size of analytic workload with low latency. Read on to learn more.  Read more...
By Additional Articles 2017/10/20 | Source: Database Journal | Category: azure data lake
Rating: (not yet rated)  Rate this |   Briefcase | 1,823 reads

Top Talent Leaves

Why do employees leave their companies? There are a variety of reasons, but when your most talented people leave, that's a concern. Steve Jones comments on what we might do about this.  Read more...
By Steve Jones 2017/10/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 359 reads

SQL Server Performance Benchmarking with Patterns

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.  Read more...
By Paul Brewer 2017/10/19 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 610 reads

Simple SQL: Random Thoughts

How does one get a truly random sample of data of a certain size from a SQL Server database table. Well, there are simple non-portable tricks one can use, such as the NewID() function, but then refining those can be tricky. Take the Rand() function for a start. Can it really provide you with a truly random number? Why doesn't the TABLESAMPLE clause give you a set number of rows? Joe Celko scratches his head a bit, explains some of the issues and invites some suggestions and tricks from readers.  Read more...
By Additional Articles 2017/10/19 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,322 reads

Discover database DevOps and more at PASS Summit

PASS Summit lands in Seattle from October 31 to November 3 this year, bringing with it the latest thinking and developments in the SQL Server world. This blog post from Annabel Bradford gives the details of what Redgate willl be presenting on, when this year's Redgate Rocks party will be, and how you can get involved with the team!  Read more...
By 2017/10/19 | Source: Redgate | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 1,575 reads

Software Patents

Patents are one way that governments can spur innovation. However many people think software patents should be eliminated. Steve Jones doesn't think so, but would like reform.  Read more...
By Steve Jones 2017/10/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 145 reads

Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.  Read more...
By David Durant 2017/10/18 (first published: 2014/11/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 28,196 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2017/10/18 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 88,998 reads

SQL Server AlwaysOn Availability Groups Using an Azure Template

There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,595 reads

Don’t Underestimate the Importance of Good Co-workers

It is important to have people that do good work and are good to work with.  Read more...
By Ben Kubicek 2017/10/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 70 reads

Introduction to Statistics

This article will give a brief overview of how statistics are generated, stored, and used in SQL Server.  Read more...
By Johnny Bieber 2017/10/17 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 1,260 reads

A Freecon Halloween at the PASS Summit

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.  Read more...
By Press Release 2017/10/17 (first published: 2017/10/13) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 282 reads

Key Lookups and ColumnStore Indexes

Erik figures out why SQL Server really doesn't like combining these two things in a query plan.  Read more...
By Additional Articles 2017/10/17 | Source: Brent Ozar Unlimited Blog | Category: key lookup
Rating: (not yet rated)  Rate this |   Briefcase | 2,621 reads
   Items 1 to 20 of 16188    Older >>