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

<< Newer    Items 81 to 100 of 15843    Older >>
 

Roll Up All the Versions

Steve talk about the final SQL Server 2012 service pack.  Read more...
By Steve Jones 2017/05/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Azure SQL Database - Dynamic Data Masking

A number of security-related features are built into Azure SQL Database, including Transparent Data Encryption, Row-Level Security, and Azure SQL Database Auditing. Their availability reflects the consistent effort by Microsoft to provide functional parity between Azure SQL Database and SQL Server instances running in Azure virtual machines as well as in your on-premises environment. Another example of this trend is support for Dynamic Data Masking, covered in this article.  Read more...
By Additional Articles 2017/05/30 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,212 reads

Webinar: Microsoft’s Agile Transformation Story

Learn how Microsoft adopted DevOps at scale in this free Redgate webinar on June 12. Donovan Brown, Senior DevOps Program Manager in Microsoft’s US Developer Division, will share how Microsoft embarked on its own DevOps journey reducing a three-year release cycle down to three weeks. Sign up now.  Read more...
By 2017/06/08 (first published: 2017/05/30) | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 9,692 reads

Combining R and SQL Server to diagnose performance bottlenecks

Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.  Read more...
By Nick Burns 2017/05/29 (first published: 2015/12/07) | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 8,954 reads

The Rate of Change of Data

Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.  Read more...
By Phil Factor 2017/05/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 47 reads

Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot

When you are automating a number of tasks, or performing a batch of tests, you want a way of automating the production of your plots and graphs. Nothing beats a good graphical plot for giving the indications of how the process went. If you are using PowerShell and maybe also SQL Server, it pays to use a command-line plotting tool such as Gnuplot to do all the hard work. It turns out to be handy for a range of data jobs, turning PowerShell into a handy data science tool.  Read more...
By Additional Articles 2017/05/29 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,341 reads

Happy Memorial Day 2017

During this US holiday, Steve hopes you have a relaxing day.  Read more...
By Steve Jones 2017/05/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 29 reads

Using striped backups with SQL Clone

If you’re a Redgate SQL Backup customer, occasionally you’ll need to convert your SQL Backup (.sqb) files to the native SQL Server backup format (.bak), perhaps to perform native database restores on a server where SQL Backup isn’t installed. This produces a striped backup, because each thread used when making the backup will produce a separate file. Can we use a striped backup produced in this way, or indeed any striped backup, as the source for a SQL Clone image? Short answer: we can! Let’s see how that works.  Read more...
By Additional Articles 2017/05/29 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 1,807 reads

Do I Need to Learn Linux and R and Python?

The SQL Server platform is growing, but Steve Jones notes that this might not really affect our jobs.  Read more...
By Steve Jones 2017/05/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 552 reads

How to deploy a database plus static data using SQL Compare and SQL Data Compare

This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs to get the current version of a database schema, and its static data, into version control, and then automate database deployments from the version control system using SQL Compare's command line and PowerShell.  Read more...
By Tony Davis 2017/05/26 | Source: Redgate | Category: sql compare
Rating: (not yet rated)  Rate this |   Briefcase | 3,850 reads

Datetime vs. Datetime2

Read a short comparison of datetime and datetime2 types. Learn about their structure, as well as the advantages and disadvantages of each.  Read more...
By Robert Hartmann 2017/05/26 (first published: 2016/01/05) | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 13,846 reads

It’s not you, it’s me (I/O troubleshooting)

Monica Rathburn talks about a few of the more common elements she always checks for when troubleshooting I/O problems.  Read more...
By Additional Articles 2017/05/26 | Source: SQLPerformance.com | Category: io performance
Rating: (not yet rated)  Rate this |   Briefcase | 3,197 reads

The OUTPUT Clause for INSERT & DELETE Statements

In this article, I will provide a set of examples to show case the use of OUTPUT clause for INSERT and DELETE statements.  Read more...
By Amarendra Reddy Thummeti 2017/05/25 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,536 reads

Audio Attacks

We will start to deal with more and more types of data. Steve Jones worries about the possibility of hacking.  Read more...
By Steve Jones 2017/05/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Training: Zero to BIML

A four-day course aimed at BI developers who want to use Business Intelligence Markup Language (BIML) to generate SQL Server Integration Services packages.  Read more...
By Andy Leonard 2017/05/25 | Category: training
Rating: (not yet rated)  Rate this |   Briefcase | 2,966 reads

Getting Started with Azure SQL Data Warehouse - Part 4

Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service. Join Arshad Ali as he discusses round-robin and distributed tables, and how to create them. He also discusses how partitioning works in SQL Data Warehouse and looks at the impact of choosing the right distribution key. As a bonus Arshad shows you how to leverage PolyBase to quickly and easily import or export data from SQL Data Warehouse.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,056 reads

Byte Me: Taking it to the top

By Bob Lang 2017/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 96 reads

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?  Read more...
By Hugo Kornelis 2017/05/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 794 reads

Masking your on-premise database with SQL Data Mask

In the last update from Redgate Foundry three weeks ago, they announced their intention to build a version of SQL Data Mask that would mask on-premise SQL Server databases, as well as Azure SQL Databases. They're pleased to say this version of the prototype is now available - here are the details.  Read more...
By Additional Articles 2017/05/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 2,292 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2017/05/24 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 81,883 reads
<< Newer    Items 81 to 100 of 15843    Older >>