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

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

Making Good Use of SQL Server Auditing

SQL Server Auditing is a powerful out-of-the box toolset that captures auditing information and writes to a file or the Event Log. This article examines the little things that might snag you up.  Read more...
By John F. Tamburo 2017/10/05 | Source: SQLServerCentral.com | Category: audit specification
Rating: |  Discuss |   Briefcase | 951 reads

The Basics of Good T-SQL Coding Style – Part 4: Performance

There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse your team colleagues. It can make refactoring a chore or make testing difficult. The most serious problem is poor performance. You can write SQL that looks beautiful but performs sluggishly, or interferes with other threads. A busy database developer adopts good habits so as to avoid staring at execution plans. Rob Sheldon gives some examples.  Read more...
By Additional Articles 2017/10/05 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,496 reads

Rewrite Your Code Tomorrow

Steve Jones notes that we often solve problems better the second time around.  Read more...
By Steve Jones 2017/10/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 58 reads

Stairway to U-SQL Level 18: Populating a Data Lake with PowerShell

Learn how PowerShell can be used to manage files and folders in your Data Lake.  Read more...
By Mike McQuillan 2017/10/04 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 389 reads

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,061 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,123 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,269 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 | 298 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 | 83 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,983 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,665 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 | 446 reads


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 | 73 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,701 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,409 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,145 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,421 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,338 reads
<< Newer    Items 41 to 60 of 16176    Older >>