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

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

Citizen Scientists

More and more people are becoming citizen scientists, even in companies. Steve Jones thinks this is helpful, but we still need professionals.  Read more...
By Steve Jones 2017/10/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads

How to examine differences with SQL Compare Summary View and SQL View

In this video, Steve Jones introduces the new Summary View that's now available in Redgate SQL Compare.  Read more...
By 2017/10/10 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,369 reads

Don't Use Code Coverage

Code Coverage is a metric that Steve Jones sees often misused.  Read more...
By Steve Jones 2017/10/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

Azure DWH part 18: Working with SQL Server Analysis Services

In this new article, we will learn how to create a cube extracting data from ADWH.  Read more...
By Daniel Calbimonte 2017/10/09 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 266 reads

Unearthing Bad Deployments with SQL Monitor and Redgate’s Database DevOps Tools

Sudden performance issues in SQL Server can have many causes, ranging all the way from malfunctioning hardware, through to simple misconfiguration, or perhaps just end users doing things they shouldn’t. But one particularly common culprit is when deployments go wrong: I don’t know a single DBA who hasn’t been burned by a bad release.  Read more...
By 2017/10/09 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,656 reads

The Achilles Heel

In a long career in IT, Phil Factor cannot recall a 'major incident', where the failure or breach was due to a single 'Achilles Heel', or even a single team of people. They are always due to a whole plethora of slack and ignorant practices.  Read more...
By Phil Factor 2017/10/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 60 reads

Indexing for Windowing Functions: WHERE vs. OVER

Erik Darling shows that if you take SQL Server's word when it asks for an index, things can go horribly awry.  Read more...
By Additional Articles 2017/10/09 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,438 reads

8 Ways to Export SQL Results To a Text File

This tip will show eight ways to export the results of a query to a text file.  Read more...
By Daniel Calbimonte 2017/10/06 (first published: 2016/10/26) | Source: SQLServerCentral.com | Category: export
Rating: |  Discuss |   Briefcase | 5,750 reads

Why Don't You Unit Test Code?

This Friday Steve Jones wants to know what you think of testing code and why you don't do it.  Read more...
By Steve Jones 2017/10/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

SQL Server Integration Services SSIS 2016 Tutorial

SQL Server Integration Services (SSIS) is the integration and ETL (extract – transform – load) tool in the Microsoft Data Platform stack. SSIS is typically used in data warehousing scenarios, but can also be used in common data integration use cases or just to move data around. SSIS is used behind the scenes in the Maintenance Plans of SQL Server and in the Import/Export wizard.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,634 reads

The SQL Prompt Functionality Finder

SQL Prompt does a lot more than just intellisense - in this article, Phil Factor provides a handy table showing all of the tool's functions and where to access them.  Read more...
By 2017/10/06 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,764 reads

Teaching Quickly

Steve Jones talks about learning, teaching, and the need to not waste anyone's time.  Read more...
By Steve Jones 2017/10/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 51 reads

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 | 968 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,544 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/05 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,280 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 | 60 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 | 394 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,075 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,141 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 | 304 reads
<< Newer    Items 41 to 60 of 16188    Older >>