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

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

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2017/10/04 (first published: 2013/08/14) | Source: Redgate | Category: transaction log
Rating:  Rate this |   Briefcase | 88,028 reads

Understanding Azure Data Factory – A Cloud Based Integration Service

Azure Data Factory is a cloud based data integration service. This helps you to define, schedule and manage data pipelines to transfer and transform the data from disparate on premise and cloud data sources. Read on to learn more.  Read more...
By Additional Articles 2017/10/04 | Source: Database Journal | Category: azure data factory
Rating: (not yet rated)  Rate this |   Briefcase | 2,066 reads

Database provisioning from backups using SQL Clone

This article offers a brief, step-by-step guide to provisioning databases from a backup using SQL Clone.  Read more...
By 2017/10/04 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,259 reads

Azure DWH part 17: ADF:Import Data from SQL Server on-premises to ASDW

In this article we will learn to use Data Factory to import table from SQL Server to Azure SQL Data Warehouse.  Read more...
By Daniel Calbimonte 2017/10/03 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 294 reads

No More Service Packs

There won't be any more service packs for SQL Server after version 2016.  Read more...
By Steve Jones 2017/10/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 82 reads

Data in Motion and Data at Rest

Microsoft (StreamInsight), and Azure Stream Analytics represent a very different model for processing data. They are concerned with processing complex event streams of data (CEPs) from such things as sensors to deduce significant patterns and apply filters. Joe Celko discusses the background to an intriguing technology of complex event processing to establish the difference between data at rest, and data on the move.  Read more...
By Additional Articles 2017/10/03 | Source: SimpleTalk | Category: streaminsight
Rating:  Rate this |   Briefcase | 2,925 reads

So, what is GDPR and why should Database Administrators care?

You’ve no doubt heard at least something about the GDPR, the EU’s new privacy and Data Management law with its greatly increased maximum fines for non-compliance and tighter definitions for acceptable use of personal information. If you’ve continued reading past paragraph one of any of the many articles, you’ll be aware that the law applies globally, to all organizations holding EU citizens’ data – it’s not bounded by geography or jurisdiction.  Read more...
By 2017/10/03 | Source: Redgate | Category: gdpr
Rating:  Rate this |   Briefcase | 3,613 reads

Real-time moving averages for IoT with R

Computing an average over all your data is easy, but what if your data arrives incrementally and you need to be able to compute real-time averages on the fly? That's what we are going to look at.  Read more...
By Nick Burns 2017/10/02 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 445 reads

Get-DbaPowerShell

Steve Jones talks PowerShell and how it is a skill that you might find useful.  Read more...
By Steve Jones 2017/10/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 71 reads

Should DBAs learn Linux?

Brent Ozar looks at the similarities between SQL Server on Linux and SQL Server on Windows Core from back in 2012, and asks whether DBAs should bother learning it.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,699 reads

The Worms-eye View

Even the most elaborate team-based development methodology won't compensate for the blinkered attitudes and tribal cultures that come from over-specialization in IT.  Read more...
By Phil Factor 2017/10/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 49 reads

SQL Prompt Tip: how to control when the suggestion box pops up

By default, SQL Prompt shows code auto-completion suggestions automatically, and continuously. 90% of the time this is exactly what you want, but there are other times where you just need a bit of space - Phil Factor shows how.  Read more...
By Additional Articles 2017/10/02 | Source: Redgate | Category: redgate
Rating:  Rate this |   Briefcase | 2,406 reads

3 Things I Wish I Knew When I Started Using Entity Framework

Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.  Read more...
By Bert Wagner 2017/09/29 (first published: 2016/05/17) | Source: SQLServerCentral.com | Category: entity framework
Rating: |  Discuss |   Briefcase | 5,137 reads

A New New World

What do you see in the future? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2017/09/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 54 reads

Implementing SQL Server Failover Clustering in Azure

Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-availability and disaster recovery capabilities in a manner that they can control. Trying to implement this approach in the cloud by following the procedures applicable in on-premises datacenters frequently presents challenges. This article focuses on these differences in the context of deployment of SQL Server Failover Clustering in Azure.  Read more...
By Additional Articles 2017/09/29 | Source: Database Journal | Category: failover
Rating: (not yet rated)  Rate this |   Briefcase | 2,415 reads

A whole new way to see differences in SQL Compare

In the latest release of SQL Compare, Redgate have added a brand new way to examine the differences between two objects in your database. Jamie Wallis provides the details.  Read more...
By 2017/09/29 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,333 reads

Guide to Create a SQL Central Management Server

This post is going to walk you through the process of creating an SQL Management Server.  Read more...
Rating: |  Discuss |   Briefcase | 915 reads

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL Server table that represents a simple hierarchy within an organisation. Well once you know, it is easy and William Brewer is on a mission to tell you how.  Read more...
By Additional Articles 2017/09/28 | Source: SimpleTalk | Category: json
Rating:  Rate this |   Briefcase | 4,007 reads

We Have a Date

SQL Server 2017 has a general availability date.  Read more...
By Steve Jones 2017/09/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 71 reads

Benchmark your Database DevOps maturity level

Whether you’re only just starting to explore the advantages of DevOps or you’re already fully immersed in the journey, including the database brings additional advantages. Take a few minutes to complete our Database DevOps Maturity Assessment and you’ll better understand how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers.  Read more...
By 2017/09/28 (first published: 2017/09/19) | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 3,365 reads
<< Newer    Items 41 to 60 of 16172    Older >>