SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,884,175 DBAs, developers and SQL Server users

Headlines today   April 26, 2017

Obsoleting Unused SSRS Reports

Learn about programmatically obsoleting unused SSRS reports from your Report Server.  Read more...
Rating: |  Discuss |   Briefcase | 10 reads

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.  Read more...
By 2017/04/26 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,111 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2017/04/26 (first published: 2014/02/26) | Source: Redgate | Category: replication
Rating:  Rate this |   Briefcase | 61,753 reads

How to setup a tabular data model in SSAS Azure

Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure.  Read more...
By Additional Articles 2017/04/26 | Source: MSSQLTips.com | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 74 reads
Previous headlines

SSRS Audit: All reports executed/not-executed during previous 30 days

This article presents a pair of queries and reports that reads the ReportServer.dbo.ExecutionLog table to list all SSRS reports that were executed or not-executed in the past 30 days, how many times they were executed, and who executed them.  Read more...
By Stan Kulp 2017/04/25 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 918 reads

Selecting and Configuring Hardware for SQL Server 2016 Standard Edition

Glenn Berry explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.  Read more...
By 2017/04/25 | Source: SQLPerformance.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 1,720 reads

Should I Type * or 1 With the EXISTS Logical Operator

In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.  Read more...
By Viacheslav Maliutin 2017/04/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,821 reads

Building Dynamic React Apps with SQL Server Data

This article demonstrates using React and the CData API Server to build dynamic Web pages using SQL Server data.  Read more...
By Jerod Johnson 2017/04/24 | Source: SQLServerCentral.com | Category: react
Rating: |  Discuss |   Briefcase | 267 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

Power BI Custom Visuals Class (Module 47 – Line Dot Chart)

In this module you will learn how to use the Line Dot Chart Power BI Custom Visual.  The Line Dot...  Read more...
By Devin Knight 2017/04/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 115 reads

Query tuning 101: What’s a probe residual?

Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a...  Read more...
By Daniel Janik 2017/04/26 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 130 reads
Question of the Day

Does this work in R?

By Steve Jones 2017/04/26 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 24 reads

I see this code in an R script:

24 -> x

What does this do?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Jeff Moden
15566 85821 SSC Guru  
12950 87105 SSC Guru  
Steve Jones - SSC Editor
11013 62356 SSC Guru  
Grant Fritchey
10197 39711 SSC-Dedicated  
Lynn Pettis
5669 39249 SSC-Dedicated  
Latest forum posts