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

<< Newer    Items 41 to 60 of 15755    Older >>
 

Cracking the SQL Code

Checking for coding style and reviewing code is so much easier when using techniques and tools to help, as long as the tools are your slave, and not your master.  Read more...
By Phil Factor 2017/05/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 68 reads

Backing Up SQL Server Databases Hosted on Azure VMs

Join Marcin Policht as he provides a comprehensive overview of the different backup options applicable to Azure SQL Server VMs with database files stored on VM disks.  Read more...
By Additional Articles 2017/05/15 | Source: Database Journal | Category: azure vm
Rating: (not yet rated)  Rate this |   Briefcase | 2,212 reads

Why people flocked to the SQL Clone live stream event

On March 29, over 650 people tuned in from around the world to find out more about Redgate's new database provisioning tool, SQL Clone. The webinar answered the FAQs, included some in-depth demos, and gave a look into the technology behind the tool. Catch up with the recording.  Read more...
By Additional Articles 2017/05/15 | Source: Redgate | Category: video
Rating: (not yet rated)  Rate this |   Briefcase | 2,720 reads

How Long Before Your Database Runs Out of Space?

Almost all SQL Server databases grow in size over time. Capacity planning is an important activity for the DBA. You need to know how long before you run out of space long before you actually do. Here are some helpful tips and tricks.  Read more...
By John F. Tamburo 2017/05/12 (first published: 2016/06/09) | Source: SQLServerCentral.com | Category: capacity planning
Rating: |  Discuss |   Briefcase | 5,824 reads

Less QA?

It seems that QA is being cut more and more as software development advances. Is that a good thing? Steve Jones has some thoughts.   Read more...
By Steve Jones 2017/05/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 188 reads

Displaying Backup or Restore Progress

Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.  Read more...
By Additional Articles 2017/05/12 | Source: Database Journal | Category: backup and restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,210 reads

Backup and restore of a SQL Clone

SQL Server sees the cloned database as a user database, meaning that you can treat it as one, including backup and restore - Steve Jones explains.  Read more...
By Additional Articles 2017/05/12 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 3,209 reads

AlwaysON Availability Group and Jobs Part 2

This article will provide the actual implementation of the control mechanism.  Read more...
Rating: |  Discuss |   Briefcase | 779 reads

Performance Myths: Table variables are always in-memory

Guest author Derik Hammer dismisses the common myth that table variables perform better than temp tables because they are always in memory.  Read more...
By Additional Articles 2017/05/11 | Source: SQLPerformance.com | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 5,134 reads

What do you do when you have a repetitive task to do?

When faced with repetitive tasks how do you go about doing them in a focused timely manner?  Read more...
By Ben Kubicek 2017/05/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 78 reads

So, you didn’t get the job; maybe it is YOUR fault.

Why I am now motivated to brand myself.  Read more...
By Rodney Hess 2017/05/10 | Source: SQLServerCentral.com | Category: employement
Rating: |  Discuss |   Briefcase | 83 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new 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/05/10 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 35,900 reads

AlwaysON Availability Group and Jobs Part 1

In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios.   Read more...
Rating: |  Discuss |   Briefcase | 703 reads

Using an R Package within SQL Server with Real time analysis in Power BI

We all know how easy it is to run R, together with dependent packages, from SQL Server on order to do statistical analysis, and then turn the result into a real-time graph using Power BI; but can you actually do it? Saurabh Desai gives a step-by-step hand-holding guide to turn even the most timid into a BI guru. There is nothing difficult in using R in SQL Server 2016 once you know the steps.  Read more...
By 2017/05/10 | Source: SimpleTalk | Category: r package
Rating:  Rate this |   Briefcase | 4,045 reads

SQL Data Mask: now featuring configurable masks

SQL Data Mask is the latest prototype to come out of Redgate Foundry. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. Here are the details.  Read more...
By Additional Articles 2017/05/10 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,620 reads

Balloons and Data

A common misconception for users is how tempdb, and data files in general work.   Read more...
By Steve Jones 2017/05/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 261 reads

Best option for working with Files in SSIS

This time we will compare different solutions to copy system folders using different SSIS tasks.  Read more...
By Daniel Calbimonte 2017/05/09 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,474 reads

Date and Time Conversions Using SQL Server

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.  Read more...
By 2017/05/09 | Source: MSSQLTips.com | Category: date conversion
Rating:  Rate this |   Briefcase | 3,900 reads

View R Plots from within SQL Server Management Studio

Describes how to view R plots in SSMS and gives a brief introduction to R plotting  Read more...
By Bill Palace 2017/05/08 | Source: SQLServerCentral.com | Category: r services
Rating: |  Discuss |   Briefcase | 1,056 reads

Deploying Multiple SSIS Projects via PowerShell

When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous Integration can get tricky. Nat Sundar describes how he created a Deployment script that is intended to provision a Data Warehouse for System Integrated testing (SIT).  Read more...
By Additional Articles 2017/05/08 | Source: SimpleTalk | Category: ssis
Rating:  Rate this |   Briefcase | 3,556 reads
<< Newer    Items 41 to 60 of 15755    Older >>