Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 21 to 40 of 15568    Older >>
 

Why DevOps? Employee Satisfaction

Another reason why a DevOps process is a good idea.  Read more...
By Steve Jones 2017/03/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 56 reads

Backups in Azure SQL Data Warehouse

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.  Read more...
By Daniel Calbimonte 2017/03/20 | Source: SQLServerCentral.com | Category: azure
Rating: |  Discuss |   Briefcase | 347 reads

Using Power BI in a Hybrid Environment

Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores. This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources.  Read more...
By Additional Articles 2017/03/20 | Source: Microsoft MSDN
Rating: (not yet rated)  Rate this |   Briefcase | 3,089 reads

Visualizing Data

This week Steve Jones talks about data visualizations, and the opportunities that exist for data professionals.  Read more...
By Steve Jones 2017/03/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 39 reads

Windowing Functions: Tell me when that changes

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource  Read more...
By Michael Morin 2017/03/17 (first published: 2016/02/17) | Source: SQLServerCentral.com | Category: windows functions
Rating: |  Discuss |   Briefcase | 7,007 reads

SQL Server Bulk Insert Row Terminator Issues

We often need to import data into SQL Server from a file. Sometimes unwanted end of line characters are part of the source file and these can create issues when importing the data. One of the ways to avoid this issue is to use SQL Server Integration Services (SSIS), but it doesn't always make sense to use SSIS for simple operations. Rahul Mehta explains that he uses BULK INSERT sometimes faces issues with Line Feeds and Carriage Returns. In this post, Rahul shows some examples and explains how to fix the issue.  Read more...
By Additional Articles 2017/03/17 | Source: MSSQLTips.com | Category: bulk insert
Rating: (not yet rated)  Rate this |   Briefcase | 2,365 reads

Using Trace Flags

Do many of you use trace flags? Steve Jones wonders today.  Read more...
By Steve Jones 2017/03/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 42 reads

Extending DevOps practices to SQL Server databases

In this free webinar, Steve Jones and Arneh Eskandari show how to use migration scripts as part of an automated database deployment. For the demo, they’ll be plugging Redgate’s Database DevOps solution into Git, TeamCity and Octopus Deploy.  Read more...
By 2017/03/17 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,335 reads

Informing the Internal IT Team

One of the ways to build a good team is with communication.  Read more...
By Steve Jones 2017/03/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

Ding - The World’s Largest Mobile Top-up Network Streamlines QA with SQL Server Containers

In this case study, see how database containers can help improve a QA process.  Read more...
By Andrew Pruski 2017/03/16 | Source: SQLServerCentral.com | Category: containers
Rating: |  Discuss |   Briefcase | 306 reads

Installing SQL Server vNext on an AWS EC2 RHEL Instance

The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.  Read more...
By Kenneth Igiri 2017/03/16 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 470 reads

How to Find Queries Using an Index (and Queries Using Index Hints)

Sometimes you know a query is out there, but it’s hard to find the exact query. In this post, Kendra Little gives example code to find queries using a specific index, or using an index hint.  Read more...
By Additional Articles 2017/03/16
Rating: (not yet rated)  Rate this |   Briefcase | 4,709 reads

Enable Trace Flags in SQL Server

Learn how to enable trace flags to change the behavior of your SQL Server instance.  Read more...
By Steve Jones 2017/03/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,048 reads

DevOps Isn't Perfect

Mistakes will still be made with a DevOps process, but the benefits outweigh the mistakes.  Read more...
By Steve Jones 2017/03/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 45 reads

Deployment Automation for SQL Server Integration Services (SSIS)

SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,124 reads

Adding Years, Months and Days

Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.  Read more...
By Pete Revell 2017/03/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,766 reads

Managing Azure SQL Database Recovery

Azure SQL Database offers several benefits, built into the underlying cloud infrastructure, that leverage resiliency and redundancy. You can take advantage of this functionality to facilitate failover and failback in response to events that affect availability of an Azure region.  Read more...
By Additional Articles 2017/03/14 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,347 reads

GUI or CLI

The debate over the CLI or GUI is an age old debate.  Read more...
By Steve Jones 2017/03/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 77 reads

2016 Salary Survey in PowerBI

A PowerBI Presentation using the data from the 2016 Salary Survey  Read more...
By Christopher Huntley 2017/03/13 | Source: SQLServerCentral.com | Category: salary survey
Rating: |  Discuss |   Briefcase | 1,601 reads

Change Your SQL Server Oil

Regular maintenance for your instance is important.  Read more...
By Steve Jones 2017/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads
<< Newer    Items 21 to 40 of 15568    Older >>