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

Rss
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 | 697 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,136 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 | 62,395 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 | 623 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 | 994 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,857 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,882 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 | 277 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 | 387 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 | 695 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 | 467 reads

I see this code in an R script:

24 -> x

What does this do?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
15539 85997 SSC Guru  
2.
GilaMonster
12941 87227 SSC Guru  
3.
Steve Jones - SSC Editor
11002 62462 SSC Guru  
4.
Grant Fritchey
10190 39770 SSC-Dedicated  
5.
Lynn Pettis
5661 39305 SSC-Dedicated  
Latest forum posts