Subscribe: SQLServerCentral.com Articles
http://www.sqlservercentral.com/sscrss.xml
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
azure sql  azure  data warehouse  data  database  devops  disk bottlenecks  disk  server  source control  sql data  sql server  sql  step 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: SQLServerCentral.com Articles

SQLServerCentral.com Articles



Articles posted on SQLServerCentral.com



 



The Mysterious Case of the Missing Default Value

Fri, 24 Mar 2017 06:00:00 UT

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.




Encrypting SQL Server: Transparent Data Encryption (TDE)

Fri, 24 Mar 2017 06:00:00 UT

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.




Comparing Space Usage for Different Compression Types

Thu, 23 Mar 2017 06:00:00 UT

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.




Getting Started with Azure SQL Data Warehouse - Part 2

Thu, 23 Mar 2017 06:00:00 UT

Arshad Ali discusses the architecture of Azure SQL Data Warehouse and how you can scale up or down, based on your need.




Continuous Delivery and the Development DBA

Wed, 22 Mar 2017 06:00:00 UT

How to do database development with trunk based development and Continuous Delivery




Follow-up #1 on leading wildcard seeks

Wed, 22 Mar 2017 06:00:00 UT

Aaron Bertrand shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.




Webinar: how to get started with DevOps

Wed, 22 Mar 2017 06:00:00 UT

More and more teams are turning to DevOps as way to improve the efficiency and quality of software delivery but it’s not always clear what's the best way to get started. Redgate have invited Steve Thair, CTO of the DevOpsGuys, to share some practical tips on how you can start implementing DevOps in your organization. Register for the free webinar.




TODAY: extending DevOps practices to SQL Server databases

Tue, 21 Mar 2017 06:00:00 UT

In this free webinar later today, 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.




Core Database Source Control Concepts

Tue, 21 Mar 2017 06:00:00 UT

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.




Backups in Azure SQL Data Warehouse

Mon, 20 Mar 2017 06:00:00 UT

This time we explain how to recover an Azure SQL Data Warehouse (ASDW) from a disaster.




Using Power BI in a Hybrid Environment

Mon, 20 Mar 2017 06:00:00 UT

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.




Windowing Functions: Tell me when that changes

Fri, 17 Mar 2017 06:00:00 UT

Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource




SQL Server Bulk Insert Row Terminator Issues

Fri, 17 Mar 2017 06:00:00 UT

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.




Extending DevOps practices to SQL Server databases

Fri, 17 Mar 2017 06:00:00 UT

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.




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

Thu, 16 Mar 2017 06:00:00 UT

In this case study, see how database containers can help improve a QA process.




Installing SQL Server vNext on an AWS EC2 RHEL Instance

Thu, 16 Mar 2017 06:00:00 UT

The steps required to create an Amazon Web Services EC2 instance and install the latest SQL Server version on the EC2.




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

Thu, 16 Mar 2017 06:00:00 UT

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.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Enable Trace Flags in SQL Server

Wed, 15 Mar 2017 06:00:00 UT

Learn how to enable trace flags to change the behavior of your SQL Server instance.

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Deployment Automation for SQL Server Integration Services (SSIS)

Wed, 15 Mar 2017 06:00:00 UT

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.




Adding Years, Months and Days

Tue, 14 Mar 2017 06:00:00 UT

Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.




Managing Azure SQL Database Recovery

Tue, 14 Mar 2017 06:00:00 UT

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.




2016 Salary Survey in PowerBI

Mon, 13 Mar 2017 06:00:00 UT

A PowerBI Presentation using the data from the 2016 Salary Survey




Introducing DevOps to Farm Credit Services of America

Mon, 13 Mar 2017 06:00:00 UT

Identifying a need for better collaboration between teams is only the first step to introducing DevOps workflows into your organization. You also need to define a common DevOps goal, a strategy to achieve it, and then to break down this strategy into series of manageable tasks for each team. Bob Walker describes how Farm Services of America started to "do DevOps".




Understanding Graphical Execution Plans - Part 1: Explaining the Plan

Fri, 10 Mar 2017 07:00:00 UT

Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.




TroubleShooting SQL Server Memory Consumption

Fri, 10 Mar 2017 07:00:00 UT

Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.




How to work with the command line in Azure SQL Data Warehouse

Thu, 09 Mar 2017 07:00:00 UT

This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse




SQL Migrator (Part 2)

Thu, 09 Mar 2017 07:00:00 UT

Automated Upgrade\Migration Tool for SQL Server

(image) How to fix SQL Server disk I/O bottlenecks (without a hammer)
In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now.



Exploring Azure Storage for SQL Server DBAs

Thu, 09 Mar 2017 07:00:00 UT

If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications and barriers in the storage options when you come to provision the server. If you get it wrong, you could end up with an expensive service. Joshua explains the value of using a lab environment to allow you to make well-informed VM storage decisions when the time comes to provision your production system.




Redgate Data Tools in Visual Studio 2017 Enterprise

Thu, 09 Mar 2017 07:00:00 UT

Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.




TempDB Database On a Local Disk for an FCI

Wed, 08 Mar 2017 07:00:00 UT

The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance.