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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,901,374 DBAs, developers and SQL Server users

Headlines today   May 22, 2018

Scheduling a PowerShell Script Using SQL Server Agent

This article will give you insight to understand how you can schedule a powershell script you have written using SQL Server Agent.   Read more...
By Vishnu Gupthan 2018/05/22 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 465 reads

2018 State of DevOps Report

Redgate is joining forces with DevOps Research and Assessment (DORA) and Google Cloud to support the pursuit of DevOps excellence. The research aim is to better understand the DevOps landscape, and to surface new findings that provide guidance for improvement in resource management, productivity, and quality of technology delivery teams. To have your say and be part of the research, simply take the survey - there are even some great prizes up for grabs!   Read more...
By 2018/05/22 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 967 reads

Why Are You Dropping and Recreating Your Indexes?

Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?  Read more...
By Additional Articles 2018/05/22 | Source: Database Journal | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,480 reads

Monitoring Distributed SQL Servers using SQL Monitor

Many organizations are experiencing rapid expansion and diversification of their SQL Server estate to include Cloud, VMWare and other platforms, alongside traditional on-premise servers. This article explains the basic architecture and components of SQL Monitor, and then how to set up a distributed monitoring solution.  Read more...
By 2018/05/22 | Source: Redgate | Category: monitor
Rating: (not yet rated)  Rate this |   Briefcase | 766 reads
Previous headlines

SQL Server on Linux, does it have Microsoft's full attention?

SQL Server on Linux doesn't support Ubuntu 18.04 LTS. Why weren't Microsoft ready for the next LTS release?  Read more...
By Thom Andrews 2018/05/21 | Source: SQLServerCentral.com | Category: sql server on linux
Rating: |  Discuss |   Briefcase | 527 reads

Working with Windows Containers and Docker: Save the Data

Docker continues to make improvements in their products running on Windows. In this article, Nicolas Prigent explains how to share data between Windows containers and the container host. As a bonus, he also shows how to run a Linux container on Windows Server 2016.  Read more...
By Additional Articles 2018/05/21 | Source: SimpleTalk | Category: windows containers
Rating: (not yet rated)  Rate this |   Briefcase | 538 reads

The State of SQL Server Monitoring 2018

Over 600 technology professionals who work in organizations that use SQL Server recently responded to our survey to discover the current state of SQL Server monitoring.  Read more...
By 2018/05/21 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 573 reads

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.  Read more...
By Joshua Feierman 2018/05/18 (first published: 2015/10/19) | Source: SQLServerCentral.com | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 4,255 reads

Transaction Locking and Row Versioning Guide

This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.  Read more...
By Additional Articles 2018/05/18 | Source: Microsoft MSDN | Category: locking
Rating: (not yet rated)  Rate this |   Briefcase | 4,759 reads

Using SQL Server as a Source with for an Excel Application

I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.  Read more...
Rating: |  Discuss |   Briefcase | 997 reads

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 102 – Slim Data Bar KPI Visual)

In this module you will learn how to use the Slim Data Bar KPI Visual. The Slim Data Bar KPI...  Read more...
By Devin Knight 2018/05/22 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,679 reads
Question of the Day

Page considered Suspect in SQL Server 2017

By Junior Galvão - MVP 2018/05/22 | Category: suspect page
Rating: (not yet rated) |  Discuss |   Briefcase | 409 reads

A page is considered "suspect" when the SQL Server Database Engine encounters one of the following errors when it tries to read a data page. Select the three alternatives that you...  Read more...
Latest forum posts