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

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

Major new study reveals the true ROI of database DevOps

Redgate has launched a new research study that reveals the benefits different stakeholders can expect from DevOps, and provides a powerful methodology for calculating the ROI of database DevOps.  Read more...
By 2017/12/07 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 2,114 reads

Stairway to SQL PowerShell Level 4: Objects in SQL PowerShell

This far, we have learned about installation and setup of the PowerShell environment. You should now have a foundation of SQL Server PowerShell. We now are ready to learn about Objects in SQL PowerShell.  Read more...
By Ben Miller 2017/12/06 (first published: 2012/10/22) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,791 reads

Pluralsight is Amazing

Steve appreciates his Pluralsight subscription.  Read more...
By Steve Jones 2017/12/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's 2016 In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2017/12/06 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 42,608 reads

Correlation Analysis using Correlation Plot in Power BI Desktop

Power BI provides correlation plot visualization in the Power BI Visuals Gallery to create Correlation Plots for correlation analysis. In this post, Siddharth Mehta shows how to create a correlation plot in Power BI Desktop using a sample dataset of car performance.  Read more...
By Additional Articles 2017/12/06 | Source: MSSQLTips.com | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 1,785 reads

Keeping tables online during loading with schema swapping using SSIS

In this article, we discuss how schema swapping method can be used to keep tables online during the load process.  Read more...
Rating: |  Discuss |   Briefcase | 819 reads

Can Data Save the World?

The authors of Freakonomics talk data science.  Read more...
By Steve Jones 2017/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 56 reads

Book Review: Database Reliability Engineering by Campbell & Majors

Brent Ozar explains why DBAs should read this book about the future of database administration at scale.  Read more...
By Additional Articles 2017/12/05 | Source: Brent Ozar Unlimited Blog | Category: book reviews
Rating: (not yet rated)  Rate this |   Briefcase | 2,350 reads

Introducing the updated HTML comparison report in SQL Compare 13.1

In SQL Compare 13.1, Redgate have updated the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases. This blog post looks at the details of what's new.  Read more...
By 2017/12/05 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,015 reads

Is This Database Being Used?

Can we delete this database, or is someone still using it?  Read more...
By Ginger Keys 2017/12/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,591 reads

A Christmas Bug

A bug in American Airlines scheduling could impact travelers, but certainly will impact their bottom line.  Read more...
By Steve Jones 2017/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

The Appearance of the Flat File Wizard.

After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.  Read more...
By Phil Factor 2017/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 48 reads

A day in the life of a developer with SQL Prompt

There is a lot more to SQL Prompt than IntelliSense and code completion. Tony Davis takes a developer's eye view of its features, as they slot into a typical day of database development work, covering Prompt's snippets, Actions, custom code styling, safe database refactoring, as well as safety net features such as tab coloring and tab history.  Read more...
By 2017/12/04 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,149 reads

Importing JSON Data from Web Services and Applications into SQL Server

To support many applications, it makes sense for the database to work with JSON data, because it is the built-in way for a JavaScript or TypeScript application to represent object data. It can mean less network traffic, looser coupling, and less need for the application developer to require full access to the base tables of the database. However, it means that the database must do plenty of checks first before importing. Phil Factor explains how it can be easily done.  Read more...
By Additional Articles 2017/12/04 | Source: SimpleTalk | Category: json
Rating: (not yet rated)  Rate this |   Briefcase | 3,332 reads

Bones of SQL - Practical Calendar Queries

After the first article created a Calendar table, learn how to use this in a practical sense with some common queries.  Read more...
By Bob Hovious 2017/12/01 (first published: 2016/10/13) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,179 reads

Not Useless Features

There are some useless features in SQL Server, but Steve Jones wants to know which ones aren't and need investment.  Read more...
By Steve Jones 2017/12/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 76 reads

SQL Server Database Provisioning: Getting Started with SQL Clone

This article serves as a ‘first look’ at cloning databases with SQL Clone. It will review some of the database provisioning challenges that we seek to overcome, explain briefly how SQL Clone works, and then walk through a simple example of cloning a database.  Read more...
By 2017/12/01 | Source: Redgate | Category: provisioning
Rating: (not yet rated)  Rate this |   Briefcase | 2,642 reads

Even More SQL Server Features that Time Forgot

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.  Read more...
By Additional Articles 2017/12/01 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 3,824 reads

The Difference Between Rollup and Cube

Learn about the fundamental differences between the ROLLUP and CUBE operators.  Read more...
By Ben Richardson 2017/11/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,261 reads

Certifying Schools

Schools don't necessarily teach people how to code, but they could do a better job.  Read more...
By Steve Jones 2017/11/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 59 reads
<< Newer    Items 21 to 40 of 16342    Older >>