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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,892,530 DBAs, developers and SQL Server users

Rss
Headlines today   October 17, 2017

Introduction to Statistics

This article will give a brief overview of how statistics are generated, stored, and used in SQL Server.  Read more...
By Johnny Bieber 2017/10/17 | Source: SQLServerCentral.com | Category: statistics
Rating: |  Discuss |   Briefcase | 310 reads

A Freecon Halloween at the PASS Summit

If you're attending the PASS Summit in 2017, there's a Freecon day on Tuesday you can attend.  Read more...
By Press Release 2017/10/17 (first published: 2017/10/13) | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 157 reads

Key Lookups and ColumnStore Indexes

Erik figures out why SQL Server really doesn't like combining these two things in a query plan.  Read more...
By Additional Articles 2017/10/17 | Source: Brent Ozar Unlimited Blog | Category: key lookup
Rating: (not yet rated)  Rate this |   Briefcase | 472 reads
Previous headlines

Loading Data using R and PowerBI

I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.  Read more...
By Nick Burns 2017/10/16 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 506 reads

Webinar: how to cut time & disk space for database provisioning by 99%

If you’ve ever worked in a team that uses a single, shared database for development, you know how time-consuming and frustrating it is to provision copies of production databases for development work. In this webinar on October 17, you’ll see how SQL Clone cuts out the pain of provisioning development databases.  Read more...
By 2017/10/16 (first published: 2017/10/11) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,964 reads

The Power of Python and SQL Server 2017

Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL Server, but it can be used for far more than this, with any Python libraries or Frameworks. To provide an example of what is possible, Hitendra shows how to use the feature securely to provide intelligent application caching, where SQL Server can automatically indicate when data changes to trigger a cache refresh.  Read more...
By Additional Articles 2017/10/16 | Source: SimpleTalk | Category: python
Rating: (not yet rated)  Rate this |   Briefcase | 2,430 reads

A Lightweight, Self-adjusting, Baseline-less Data Monitor

Can data alert us that something is going on, without baselines and thresholds?  Read more...
By Alex Chamchourine 2017/10/13 (first published: 2016/02/23) | Source: SQLServerCentral.com | Category: data monitoring
Rating: |  Discuss |   Briefcase | 3,408 reads

How to import an existing database to ReadyRoll

The SQL Toolbelt includes ReadyRoll, which allows you to adopt a migrations-first approach to database source control and deployment. There are a number of different ways teams can get started with ReadRoll, and customers often ask how to get up and running when there is already an existing development database.  Read more...
By 2017/10/13 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 2,028 reads

Group Managed Service Accounts (gMSAs) in SQL2016

Implementing Group Managed Service Accounts (gMSAs) in existing SQL Server instances with AlwaysON  Read more...
Rating: |  Discuss |   Briefcase | 568 reads
 

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 72 – HTML Viewer)

In this module you will learn how to use the HTML Viewer.  The HTML Viewer allows you to display the...  Read more...
By Devin Knight 2017/10/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 375 reads

Small identity columns

We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small...  Read more...
By Kenneth Fisher 2017/10/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 450 reads
Question of the Day

The GDR patch

By Steve Jones 2017/10/17 | Category: patches
Rating: (not yet rated) |  Discuss |   Briefcase | 139 reads

What types of fixes does a GDR release include? Assume this is for a particular branch of code, such as the RTM release.

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
53065 411441 SSC Guru  
2.
Jeff Moden
48093 377086 SSC Guru  
3.
Steve Jones - SSC Editor
29895 247425 SSC Guru  
4.
Lynn Pettis
20757 166520 SSC Guru  
5.
Grant Fritchey
19612 161195 SSC Guru  
Latest forum posts