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

Headlines today   October 20, 2016

Basic Data Manipulation for Relational Data in R

In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.   Read more...
By Mala Mahadevan 2016/10/20 | Source: | Category: r programming
Rating: |  Discuss |   Briefcase | 734 reads

SQLServerCentral team in Seattle

The team behind will be in Seattle at the PASS Summit next week, and we’d like to hear from you. If you’re heading to the event, we’d love to get feedback on how you use the site, and hear about any changes you’d like to see. If you’d be willing to have a quick chat, please email us, and we’ll set up some time with Steve and the team.  Read more...
By 2016/10/20 | Source: | Category: pass summit
Rating: (not yet rated) |  Discuss |   Briefcase | 1,675 reads

Getting started with Query Store feature in SQL Server 2016 – Part 3

Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.  Read more...
By Additional Articles 2016/10/20 | Source: Database Journal | Category: query store
Rating: (not yet rated)  Rate this |   Briefcase | 1,604 reads
Previous headlines

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2016/10/19 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 77,505 reads

Join Redgate at PASS Summit 2016

This year Redgate have a breakout session featuring SQL Clone, as well as a booth in the exhibit hall. They'll be giving away all sorts of prizes including SQL-themed playing cards, flying sheep, and a year's worth of the world's strongest coffee! To find out the details of what they'll be up to between October 25 - 28, and to find out how you can attend the exclusive #RedgateRocks party, read this blog post.  Read more...
By 2016/10/19 | Source: Redgate | Category: pass summit
Rating: (not yet rated)  Rate this |   Briefcase | 1,003 reads

PowerShell Just Enough Administration

A major difficulty for a System Administrator who wishes to provide access for auditors, Helpdesk staff, developers and other IT people is that adminstrator roles give users more access than they need. It is too easy to make mistakes, or to make more changes than those that were signed-off. With JEA, it is possible to create role-based access control (RBAC) endpoints that define precisely what actions you’ll let your users carry out without needing a elevated, privileged administrator credentials, and which log and report all operations.  Read more...
By Additional Articles 2016/10/19 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 1,543 reads

Time Traveling with Temporal Tables on SQL Server 2016

One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.  Read more...
By Johan Åhlén 2016/10/18 | Source: | Category: sql server 2016
Rating: |  Discuss |   Briefcase | 1,451 reads

Automatically upload SQL Server Database Backups to Azure with Integration Services

Daniel Calbimonte shows how the Feature pack in SQL Server Integration Services can connect to Azure to automatically copy your SQL Server database backups.  Read more...
By Additional Articles 2016/10/18 | Source: | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,888 reads

Developing Redgate’s SQL Toolbelt

Take a look behind the scenes to learn more about Redgate’s development challenges, what role the SQL Toolbelt plays, and which releases are coming up.  Read more...
By Additional Articles 2016/10/18 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,359 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Control Flow Package Parts in SSIS 2016

Control Flow Package Parts are a new feature in Microsoft SQL Server 2016 that attempts to enable code reuse within SQL Server...  Read more...
By Todd McDermid 2016/10/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 889 reads

Why Can’t I View My Power BI Content Pack?

I had a call with a customer this morning discussing different ways to publish Power BI content and how to...  Read more...
By dustinryan 2016/10/20 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 480 reads
Question of the Day

Remove the Login Trigger

By Steve Jones 2016/10/20 | Category: triggers
Rating: (not yet rated) |  Discuss |   Briefcase | 596 reads

You work with a junion DBA that was told to implement a way to track who is logging into a SQL Server 2016 instance. The DBA wants to use a...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
342 905 SSC Eights!  
GP Van Eron
232 2431 SSCrazy  
Jeff Moden
213 41596 SSC-Forever  
212 644 SSChasing Mays  
Phil Parkin
196 7713 SSCertifiable  
Latest forum posts