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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,878,489 DBAs, developers and SQL Server users

Rss
Headlines today   January 24, 2017

Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)

Using R with Power BI, SSRS or RTVS for easier data visualization  Read more...
By Tomaž Kaštrun 2017/01/24 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 565 reads

Automating the Setup of the Local Developer Machine

On both Windows and Linux, the chore of setting up a development workstation can take several days, and there always seem to be a few configuration settings that get missed. You can reduce the time and tedium dramatically by automating the process by using Vagrant to set up the operating system, followed by your choice of provisioning, configuration management and orchestration applications such as Puppet, Chef, Ansible, Salt, Docker, Chocolatey and Boxstarter. Vishwas shows how to make it easy to do with Vagrant, Chocolatey and Boxstarter.  Read more...
By Additional Articles 2017/01/24 | Source: SimpleTalk | Category: development
Rating:  Rate this |   Briefcase | 1,002 reads

Free Webinar: An Introduction to DevOps

Despite its growing popularity, there is still some confusion over what DevOps actually means, how organizations should do it and what the best way is to get started. Redgate have invited James Betteley, Head of Education at the DevOpsGuys, to run through the basics in this free webinar. Register now.  Read more...
By 2017/01/24 (first published: 2017/01/19) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,580 reads
Previous headlines

Join Two CSV Files with a Common Column

In this example we will join two CSV files with a common column using SQL Server.  Read more...
By Daniel Calbimonte 2017/01/23 | Source: SQLServerCentral.com | Category: join
Rating: |  Discuss |   Briefcase | 1,401 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012. Updated with CU16 for SP2 and CU7 for SP3.  Read more...
By Steve Jones 2017/01/23 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 17,907 reads

Getting Started with R Services in SQL Server 2016 – Part 2

SQL Server 2016 brings native support for doing advanced analytics, using R Services, in the database itself. Arshad Ali takes a look at a detailed conceptual execution flow, executing R scripts from SQL Server Management Studio and other R client tools.  Read more...
By Additional Articles 2017/01/23 | Source: Database Journal | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 1,722 reads

Need to run multiple scripts against multiple servers?

Let Chris Yates give you a quick overview of Redgate's SQL Multi Script to learn more about a quick and easy way to solve the problem.  Read more...
By Additional Articles 2017/01/23 | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 1,504 reads

Data Mining Introduction

Many people that work for years with SQL Server never use the Data Mining. This article has the objective to introduce them to this magic and exciting new world.  Read more...
By Daniel Calbimonte 2017/01/20 (first published: 2012/11/12) | Source: SQLServerCentral.com | Category: server
Rating: |  Discuss |   Briefcase | 51,573 reads

Development Delusions: That it is Enough to Build a Better Mousetrap

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.  Read more...
By Additional Articles 2017/01/20 | Source: SimpleTalk | Category: development
Rating:  Rate this |   Briefcase | 1,848 reads

Keeping Fact Tables Online while Loading via Partition Switching

Provides overview of steps that can be used to keep fact tables online during loading process.  Read more...
By Shubhankar Thatte 2017/01/19 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 965 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 34 – Sankey with Labels)

In this module you will learn how to use the Sankey with Labels Power BI Custom Visual.  The Sankey with...  Read more...
By Devin Knight 2017/01/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 457 reads
Question of the Day

The default PoSh backup

By Steve Jones 2017/01/24 | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 372 reads

I need to run a backup and decide to use the PoSh cmdlet, Backup-SqlDatabase. I use this command with only a few parameters:


Backup-SqlDatabase -ServerInstance SalesSQL -Database ERP

What happens?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
3101 45443 SSC-Forever  
2.
Steve Jones - SSC Editor
1873 36349 SSC-Dedicated  
3.
GilaMonster
1698 47427 SSC-Forever  
4.
SQLRNNR
1068 21151 SSC-Insane  
5.
Koen Verbeeck
1008 16544 SSCoach  
Latest forum posts