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 24, 2018

Using FORMAT() for Dates

Learn how the FORMAT() function works for dates. 
By Steve Jones 2018/05/24 | Source: SQLServerCentral.com | Category: format()
Rating: |  Discuss |   Briefcase | 1,053 reads

SQL in the City Streamed – Compliant DevOps: June 20 2018

Join Redgate’s livestream on June 20 and learn from Microsoft Data Platform MVPs, Steve Jones, Grant Fritchey, and Kathi Kellenberger. The schedule will include sessions to help you learn how to demonstrate compliance with regulations such as the GDPR, HIPAA and SOX. Find out more and register for free  Read more...
By 2018/05/24 | Source: Redgate | Category: compliance
Rating: (not yet rated)  Rate this |   Briefcase | 791 reads

Build and Automate a SQL Server Status Report on Server Restart or Scheduled

Do you know when a SQL Server instance restarts? When you manage many SQL Server instances you may not know when one restarts, so having an automated report emailed to you could be helpful to get an idea what's going on for that instance.  Read more...
By Additional Articles 2018/05/24 | Source: MSSQLTips.com | Category: database mail
Rating: (not yet rated)  Rate this |   Briefcase | 1,147 reads

How DevOps can automate the repayment of technical debt

Looking to DevOps automation to try to create the breathing room needed to break out of the vicious cycle of technical debt.  Read more...
By 2018/05/24 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 908 reads
Previous headlines

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,192 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,197 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,458 reads

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 | 616 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,484 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,357 reads

From the SQLServerCentral Blogs

Cosmos DB for the Data Professional

Cosmos DB is one of the fastest growing Azure services in 2018. As its popularity grows, data professionals are faced...  Read more...
By DataOnWheels 2018/05/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,451 reads

Back to basics: What is a HEAP table?

Understanding the fundamentals is key for success, with everything you do. These days SQL Server has expanded into much more...  Read more...
By Daniel Janik 2018/05/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,009 reads
Question of the Day

Machine Learning Services languages

By Steve Jones 2018/05/24 | Category: machine learning services (mls)
Rating: (not yet rated) |  Discuss |   Briefcase | 299 reads

Which languages can be used with Machine Learning Services in SQL Server 2017?

Latest forum posts