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

Rss
Headlines today   August 25, 2016

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 | 306 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 | 891 reads
Previous headlines

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 | 493 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 | 14,425 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 | 1,581 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,834 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,694 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 | 468 reads

Software Animism

Have you ever accused an application of deliberately trying to make your life a misery? Simple Talk's Tony Davis talks animism in this week's editorial, and wants to hear your stories in the comments for the chance to win a $50 Amazon gift card.  Read more...
By Additional Articles 2016/08/22 | Source: SimpleTalk | Category: simple talk
Rating: (not yet rated)  Rate this |   Briefcase | 2,453 reads

Writing Better T-SQL: Top-Down Design May Not be the Best Choice – Part II

A second part to the series by Mickey Stuewe on writing better T-SQL looks at some of the issues of using views in a complex query.  Read more...
By Mickey Stuewe 2016/08/19 (first published: 2015/06/23) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,400 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

RBAR vs Batch

Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s...  Read more...
By Kenneth Fisher 2016/08/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 726 reads

SSMS is now High-DPI ready

One of the most popular posts on this bog describes how to enable bitmap scaling is SSMS on high DPI displays,...  Read more...
By Gianluca Sartori 2016/08/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 605 reads
Question of the Day

min Function (XQuery)

By Mikael Eriksson 2016/08/25 | Category: xml
Rating: (not yet rated) |  Discuss |   Briefcase | 222 reads

What is returned by the query?


select @X.value('min(/X/@value)', 'varchar(10)');Where the XML is

<X value="one" />
<X value="01" />
<X value="001" />
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
rvsc48
987 1398 Ten Centuries  
2.
GP Van Eron
731 1835 SSCommitted  
3.
veenavidyakaran
450 1856 SSCommitted  
4.
mike.francis
381 384 Old Hand  
5.
nilanaksha
325 532 Mr or Mrs. 500  
Latest forum posts