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

Rss
Headlines today   April 25, 2017

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: (not yet rated) |  Discuss |   Briefcase | 197 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/25 (first published: 2017/04/04) | Source: Redgate | Category: competition
Rating: |  Discuss |   Briefcase | 1,071 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 | 535 reads
Previous headlines

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,559 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 | 223 reads

6 shades of masking your data

The Redgate Foundry team have been researching data masking, and have found that generally speaking there's six common approaches. In this blog post, Toby Smyth runs through all six.  Read more...
By Additional Articles 2017/04/24 | Source: Redgate | Category: data masking
Rating: (not yet rated)  Rate this |   Briefcase | 1,217 reads

Stairway to Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.  Read more...
By Hugo Kornelis 2017/04/21 (first published: 2015/04/29) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,734 reads

Extending DevOps practices to SQL Server databases

In this free demo webinar, Grant Fritchey and Arneh Eskandari will show how Redgate tools enable you to push and pull database changes in Git, then set up an automated database build and deployment process using TeamCity and Octopus Deploy.   Read more...
By 2017/04/21 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,088 reads
 


Ask SQL Server Central

From the SQLServerCentral Blogs

Power BI and Data Security – Row Level Security (RLS)

As Power BI becomes more prevalent in data analytics and visualization within the enterprise, data security becomes a significant concern....  Read more...
By DataOnWheels 2017/04/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 383 reads

Weaning yourself off of SQL Profiler (Part 1)

In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting...  Read more...
By Wayne Sheffield 2017/04/25 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 487 reads
Question of the Day

Creating an Azure SQL Data Warehouse

By Steve Jones 2017/04/25 | Category: azure sql data warehouse
Rating: (not yet rated) |  Discuss |   Briefcase | 125 reads

I am connected to a SQL Server instance in Azure and want to create an Azure SQL Data Warehouse database. One of the important parameters is the edition. What are...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Jeff Moden
16526 85372 SSC Guru  
2.
GilaMonster
13847 86830 SSC Guru  
3.
Steve Jones - SSC Editor
11539 62070 SSC Guru  
4.
Grant Fritchey
10434 39480 SSC-Dedicated  
5.
Lynn Pettis
6057 39111 SSC-Dedicated  
Latest forum posts