Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,812,019 DBAs, developers and SQL Server users

Headlines today   July 1, 2015

Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups

In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.  Read more...
By Perry Whittle 2015/07/01 | Source: | Category: high availability
Rating: (not yet rated) |  Discuss |   Briefcase | 183 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2015/07/01 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 59,238 reads

Survey: Development and Test Databases

Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is doing research to learn how development and test databases are managed within organizations. If you’d like to know more about our plans, or are happy to help us understand the problem, please take part in this 3-page survey.  Read more...
By Additional Articles 2015/07/01 (first published: 2015/06/26) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,432 reads
Previous headlines

Trusting Source Control

One of the benefits of a version control system (VCS) is that you can look at the history of code changes. Ed Elliot shows us a situation where that helps a DBA track down a problem.  Read more...
By ed.elliott 2015/06/30 | Source: | Category: version control
Rating: |  Discuss |   Briefcase | 2,305 reads

Grant User Access to All SQL Server Databases

Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?  Read more...
By Additional Articles 2015/06/30 | Source: | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,716 reads

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?  Read more...
By Alessandro Mortola 2015/06/29 | Source: | Category: foreign keys
Rating: |  Discuss |   Briefcase | 6,398 reads

Learning about Multiple Tempdb Files

References and links to help you learn how to create multiple tempdb files.  Read more...
By Site Owners 2015/06/29 | Source: | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,922 reads

Free Webinar: Can you Automate your Ops Away?

Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!  Read more...
By Additional Articles 2015/06/29 (first published: 2015/06/26) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 2,863 reads

Using a Recursive CTE to Generate a List

Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.  Read more...
By Svetlana Marinova 2015/06/26 (first published: 2013/07/09) | Source: | Category: recursive cte
Rating: |  Discuss |   Briefcase | 19,259 reads

Getting Started with Power BI Designer

The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.  Read more...
By Additional Articles 2015/06/26 | Source: Database Journal | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 2,866 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Azure has T-SQL Jobs - Well Almost

SQL Azure has T-SQL Jobs - Well AlmostJUNE 25, 2015 Introduction One thing that has been lacking in Azure SQL Database is the...  Read more...
By Paul Hebhardt 2015/07/01 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 207 reads
Question of the Day

Dependency between tables

By Junior Galvão - MVP 2015/07/01 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

What does this code return?

Select As 'Source Table',
object_name(rkeyid) 'Reference Table',
object_name(constid) As 'FK Name'
from sys.objects so Inner Join sysforeignkeys sf
on so.object_id = sf.fkeyid
Order By So.Name 
Top Members (last 30 days)
# Name Score Level
30 days All-time
424 1816 SSCommitted  
390 1819 SSCommitted  
372 439 SSC-Addicted  
Jeff Moden
350 37842 SSC-Dedicated  
343 574 Mr or Mrs. 500  
Latest forum posts