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

Rss
Headlines today   August 26, 2016

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 | 12,874 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 | 1,704 reads
Previous headlines

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,224 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 | 3,373 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 | 573 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 | 15,461 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,176 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 | 1,938 reads

Trace Flag 2389 and the new Cardinality Estimator

Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.  Read more...
By Additional Articles 2016/08/23 | Source: SQLPerformance.com | Category: trace flag
Rating: (not yet rated)  Rate this |   Briefcase | 1,896 reads

A Tutorial With the Azure CLI (Command-Line Interface) and Azure SQL Database

In this article, we will show how to install Azure CLI and then create an Azure SQL Server and a SQL Database.  Read more...
By Daniel Calbimonte 2016/08/22 | Source: SQLServerCentral.com | Category: command
Rating: |  Discuss |   Briefcase | 495 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Go, Go, Golang!

WHAT!   Yep, you read that right. I’m building tools in Go. I can hear you now…. But Wes you are a SQL...  Read more...
By Wesley Brown 2016/08/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 730 reads

Install ReadyRoll via Command Line

command line install options ReadyRoll has some great features, including the ability to use without cost on a build server. If...  Read more...
By SqlBarbarian 2016/08/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 506 reads
Question of the Day

Union Date/Time Data Types

By David Fundakowski 2016/08/26 | Category: data types
Rating: (not yet rated) |  Discuss |   Briefcase | 713 reads

How many rows does the following query return?



SELECT GETDATE()
UNION
SELECT CAST(GETDATE() AS DATETIME2)
UNION
SELECT CAST(GETDATE() AS DATETIME)
UNION
SELECT CAST(GETDATE() AS SMALLDATETIME)
UNION
SELECT CAST(GETDATE() AS DATETIME2(7))  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
rvsc48
1176 1587 SSCommitted  
2.
GP Van Eron
669 1835 SSCommitted  
3.
veenavidyakaran
450 1856 SSCommitted  
4.
nilanaksha
333 547 Mr or Mrs. 500  
5.
mike.francis
321 384 Old Hand  
Latest forum posts