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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,889,399 DBAs, developers and SQL Server users

Headlines today   August 16, 2017

Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD

The first article in this Stairway Series makes the case for test-driven development.  Read more...
By Sebastian Meine 2017/08/16 (first published: 2014/12/31) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,085 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2017/08/16 (first published: 2013/08/21) | Source: Redgate | Category: performance tuning
Rating:  Rate this |   Briefcase | 81,219 reads

Monitoring Azure Cloud and Hybrid Environments

Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data and services are actually hosted. There is much to be said for an integrated approach to providing a unified view of entire application workloads on-premise. hybrid and cloud using the same tools wherever possible.  Read more...
By Additional Articles 2017/08/16 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,011 reads

New permissions features brings access control to SQL Clone

SQL Clone permissions has been high on the wish-list for users and the new feature addresses it in an intuitive way that enables you to allocate and change permissions quickly and easily.  Read more...
By 2017/08/16 | Source: Redgate | Category: sql clone
Rating: (not yet rated)  Rate this |   Briefcase | 705 reads
Previous headlines

Using Database Master Keys in SQL Server

Learn the basics of Database Master Keys and how you can use them in SQL Server.  Read more...
By Steve Jones 2017/08/15 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 779 reads

Let’s Corrupt a Database Together, Part 3: Detecting Corruption

Having already shown how to corrupt a database, and then how nonclustered indexes can be corrupted independently, in this post Brent Ozar explains how you can detect corruption.  Read more...
By Additional Articles 2017/08/15 | Source: Brent Ozar Unlimited Blog | Category: corruption
Rating:  Rate this |   Briefcase | 2,256 reads

SQL Server Management Studio Tips

Complete guide about hidden gems of SSMS 
By Konstantin Taranov 2017/08/14 | Source: SQLServerCentral.com | Category: ssms
Rating: |  Discuss |   Briefcase | 1,826 reads

SQL Server function to check dynamic SQL syntax

Although most of what you read tells you to stay away from dynamic SQL, the reality is there are places where writing T-SQL code dynamically just makes sense. The one downside to dynamic SQL is that if it is not written correctly the code will fail. Eli Leiba shares a function that he created to help determine if the dynamic code is OK prior to execution.  Read more...
By Additional Articles 2017/08/14 | Source: MSSQLTips.com | Category: dynamic code analysis
Rating: (not yet rated)  Rate this |   Briefcase | 3,389 reads

Using multiple custom SQL formatting styles in SQL Prompt

Usually, when coding SQL, you will want to go along with the coding style of the team you are working with. This article shows how to use SQL Prompt formatting styles to create and maintain multiple code styles, each for a dedicated purpose, and to switch between them and apply a new style to existing code, with ease.  Read more...
By 2017/08/14 | Source: Redgate | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 2,333 reads

The ABCs of Database Creation

Creating SQL Server databases is easier than the internet may lead us to believe.  Read more...
By Brandie Tarvin 2017/08/11 (first published: 2015/10/29) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 7,486 reads

Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Server on Linux Series: Moving TempDB

In the last blog post, we added additional drives to the SQL Server machine so that we can scale out...  Read more...
By kleegeek 2017/08/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 651 reads

Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)

Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Do you remember one of the major...  Read more...
By Niko Neugebauer 2017/08/16 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 759 reads
Question of the Day

Building a Matrix

By Steve Jones 2017/08/16 | Category: r language
Rating: (not yet rated) |  Discuss |   Briefcase | 411 reads

I want to build a matrix in R that has 5 rows, 4 columns, and each value in the matrix is 7. How do I do this?

Top Members (last 30 days)
# Name Score Level
30 days All-time
76143 279851 SSC Guru  
Jeff Moden
64547 261421 SSC Guru  
Steve Jones - SSC Editor
40275 175572 SSC Guru  
Lynn Pettis
29035 116008 SSC Guru  
26858 91917 SSC Guru  
Latest forum posts