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

Welcome to

A Microsoft SQL Server community of 1,863,680 DBAs, developers and SQL Server users

Headlines today   July 28, 2016

Data Quality - Addressing non-stated requirements

Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.  Read more...
By David Poole 2016/07/28 | Source: | Category: data quality
Rating: |  Discuss |   Briefcase | 393 reads

A Real-World React.js Setup for ASP.NET Core and MVC5

React is a front-end user interface library developed by Facebook, originally to help them improve their own site. Since then it has grown into somewhat of a phenomenon, with many active users. In this article, Jon Smith provides multiple examples of how to use React with recently released ASP.NET Core MVC, and the existing ASP.NET MVC5 framework.  Read more...
By Additional Articles 2016/07/28 | Source: SimpleTalk | Category: .net
Rating: (not yet rated)  Rate this |   Briefcase | 745 reads
Previous headlines

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2016/07/27 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 74,672 reads

Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL

A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.  Read more...
By Mike McQuillan 2016/07/27 | Source: | Category: u-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 183 reads

Temporal Data Part 2 - Creating and Deleting System-Versioned Tables

Greg Larsen expands on his topic of how to modify an existing table to take advantage of the new temporal data feature in SQL Server 2016. In this article he shows you how to create and deleted system-versioned tables and the associated history temporal table.  Read more...
By Additional Articles 2016/07/27 | Source: Database Journal | Category: temporal data
Rating: (not yet rated)  Rate this |   Briefcase | 1,203 reads

Azure SQL Limitations compared with a SQL Server Enterprise

In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.  Read more...
By Daniel Calbimonte 2016/07/26 | Source: | Category: azure sql database
Rating: |  Discuss |   Briefcase | 1,371 reads

What's "Actually" going on with that Seek?

Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.  Read more...
By Additional Articles 2016/07/26 | Source: | Category: seeks
Rating: (not yet rated)  Rate this |   Briefcase | 2,098 reads

Redgate’s 2016 Roadmap

What do you get for your Support & Upgrades package? Read this blog post to learn about the new functionality and improvements Redgate is releasing this year. Find out more.  Read more...
By Additional Articles 2016/07/26 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,444 reads

Additional Data Files and Proportional Fill

Additional files can be added to to a database to increase the storage. When more data is added to the files, Extended Events shows how SQL Server spreads data across multiple files.  Read more...
By David Fundakowski 2016/07/25 | Source: | Category: filegroups
Rating: |  Discuss |   Briefcase | 875 reads

The IT Manager's perspective: People as an Asset

Information Technology is fast-changing, but the people who work in IT need to have a good chance of a long-term career. That means keeping up to date, not only in their current speciality, but in the wider sphere of the technology they work with. IT managers must make sure that keeping up to date with technology is part of the day to day activity of their people. How should they make sure it happens?  Read more...
By Additional Articles 2016/07/25 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 1,998 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Learn About SQL Server Master Data Services 2016

SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have...  Read more...
By Hemantgiri S. Goswami 2016/07/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 530 reads

Monitor Query Performance

Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here. Sooner or later when you’re working...  Read more...
By Grant Fritchey 2016/07/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 717 reads
Question of the Day

Tempdb defaults in SQL Server 2016

By Steve Jones 2016/07/28 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 322 reads
What are the initial default size and growth for tempdb data files in a new SQL Server 2016 instance installation? (choose 2)
Top Members (last 30 days)
# Name Score Level
30 days All-time
GP Van Eron
1035 1166 Ten Centuries  
338 3332 Hall of Fame  
265 275 SSC Veteran  
Clive Roberts
259 1073 Ten Centuries  
252 411 SSC-Addicted  
Latest forum posts