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

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

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,165 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,206 reads

AlwaysON Availability Group and Jobs Part 2

This article will provide the actual implementation of the control mechanism.  Read more...
Rating: |  Discuss |   Briefcase | 776 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,126 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 | 79 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,892 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,035 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,619 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 | 260 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,470 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,897 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,053 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,548 reads

Three Days and a Notebook

Steve Jones is off to Seattle for the rest of the week attending Microsoft Build 2017.  Read more...
By Steve Jones 2017/05/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Basic data masking for development work using SQL Clone and SQL Data Generator

This article describes a lightweight copy-and-generate approach for making a sanitized version of a production database available to development teams with SQL Clone and SQL Data Generator.  Read more...
By Additional Articles 2017/05/08 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 3,315 reads

The Power BI Pivot

This week Steve looks at the Power BI announcement of a new server product.  Read more...
By Steve Jones 2017/05/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 52 reads

Azure Machine Learning - Your first experiment

In this chapter, we will show how to create a Machine Learning experiment from our Azure SQL Warehouse.  Read more...
By Daniel Calbimonte 2017/05/05 (first published: 2016/06/14) | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 3,959 reads
<< Newer    Items 41 to 60 of 15751    Older >>