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,577 DBAs, developers and SQL Server users

Headlines today   May 23, 2018

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.  Read more...
By Hugo Kornelis 2018/05/23 (first published: 2016/01/20) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,167 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2018/05/23 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 92,066 reads

SQL Server Graph Databases – Part 5: Importing Relational Data into a Graph Database

In the final article of this series, Robert Sheldon shows how to move from a relational structure to a graph structure using the Graph Database feature.  Read more...
By Additional Articles 2018/05/23 | Source: SimpleTalk | Category: sql server
Rating: (not yet rated)  Rate this |   Briefcase | 1,305 reads
Previous headlines

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 | 591 reads

The 2018 State of DevOps Survey. Don’t just wait for it. Be a part of it.

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 | 1,408 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:  Rate this |   Briefcase | 3,202 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 | 1,104 reads

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 | 560 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 | 776 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 | 789 reads

From the SQLServerCentral Blogs

Pushing SQL Server images to the Azure Container Registry

The Azure Container Registry is an online repository for storing Docker images (think the Docker Hub). What’s cool about this is...  Read more...
By Andrew Pruski 2018/05/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,125 reads

Dates and Times in SQL Server: more functions you should never use

Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL...  Read more...
By Randolph West 2018/05/23 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,731 reads
Question of the Day

Python Function Parameter Order

By Steve Jones 2018/05/23 | Category: python
Rating: (not yet rated) |  Discuss |   Briefcase | 402 reads

I build this function that takes multiple parameters.

def AwardRibbons(first, second, third, fourth):
print("Thanks for participating", fourth)
print("The bronze goes to ", third)
print("The silver goes to ", second)
print("The gold goes to... 
Latest forum posts