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,866,188 DBAs, developers and SQL Server users

Rss
Headlines today   August 29, 2016

Data Driven Subscription Workaround

A guide for getting around the missing data driven subscription feature in Standard editions of Microsoft SQL Server.  Read more...
By Lucinda Young 2016/08/29 | Source: SQLServerCentral.com | Category: ssrs
Rating: |  Discuss |   Briefcase | 764 reads

Migrating Content Between Report Servers

This topic describes options for migrating content from one SQL Server Reporting Services (SSRS) report server to another report server.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,429 reads
Previous headlines

Query Performance Tuning – A Methodical Approach

Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.  Read more...
By Gail Shaw 2016/08/26 (first published: 2015/06/08) | Source: SQLServerCentral.com | Category: performance and tuning
Rating: |  Discuss |   Briefcase | 13,330 reads

Import data from Azure SQL to Tabular Databases

Daniel Calbimonte shows how to create an Azure SQL Database with the AdventureworksLT data, and how to import the information into a SQL Server Analysis Services Tabular Model Database.  Read more...
By Additional Articles 2016/08/26 | Source: MSSQLTips.com | Category: azure sql database
Rating:  Rate this |   Briefcase | 3,034 reads

Using Microsoft R in Enterprise Environments

This article talks about using the the positive aspects of setting up R in enterprise environment and give instructions on first steps how to do it.  Read more...
By Tomaž Kaštrun 2016/08/25 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,360 reads

SQL Server Access Control: The Basics

No technology yet invented can in any way allow us to neglect the task of ensuring the security of the database by controlling access. Security must be applied in depth, and the database is designed provide a system that will thwart even the most determined external attack. If it seems a bit complicated at first, that is no longer an excuse now that Rob Sheldon has provided this simple guide for getting started.  Read more...
By Additional Articles 2016/08/25 | Source: SimpleTalk | Category: simple talk
Rating: (not yet rated)  Rate this |   Briefcase | 4,254 reads

Stairway to U-SQL Level 7: More Partition Schemes

Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.  Read more...
By Mike McQuillan 2016/08/24 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 601 reads

Free eBook: Inside the SQL Server Query Optimizer

This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way.  Read more...
By Press Release 2016/08/24 (first published: 2012/12/11) | Source: SQLServerCentral.com | Category: books
Rating:  Rate this |   Briefcase | 16,522 reads

Installing Master Data Services in an AlwaysOn Environment

This article describes a solution for Master Data Service (MDS) hosted on AlwaysOn Availability Group configuration. The article describes how to install and configure SQL 2016 Master Data Services on a SQL 2016 AlwaysOn Availability group (AG). The main purpose of this solution is to improve high availability and disaster recovery of MDS backend data hosted on a SQL Server database.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,609 reads

What is the impact of setting SET ANSI_WARNINGS OFF?

Setting ANSI_WARNINGS OFF to avoid NULL value elimination warnings can have an impact on the data quality and system behaviour.  Read more...
By Nakul Vachhrajani 2016/08/23 | Source: SQLServerCentral.com | Category: set options
Rating: |  Discuss |   Briefcase | 2,011 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

PoSh on Ubuntu

I heard about the PowerShell announcement recently where the platform is porting over to Linux and OSX. I think this...  Read more...
By Steve Jones 2016/08/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 704 reads

Getting Started With PowerShell on Linux

Getting PowerShell on Linux Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now...  Read more...
By Anthony Nocentino 2016/08/29 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 634 reads
Question of the Day

tempdb default directories SQL 2016

By Steve Jones 2016/08/29 | Category: tempdb
Rating: (not yet rated) |  Discuss |   Briefcase | 554 reads

Where are the tempdb data and log files stored by default in SQL Server 2016? (choose 2)

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
rvsc48
1176 1587 SSCommitted  
2.
GP Van Eron
697 1893 SSCommitted  
3.
veenavidyakaran
450 1856 SSCommitted  
4.
nilanaksha
337 591 Mr or Mrs. 500  
5.
mike.francis
321 384 Old Hand  
Latest forum posts