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

Headlines today   June 30, 2015

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,097 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,282 reads
Previous headlines

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,242 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,881 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,806 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,152 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,815 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/06/26 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,319 reads

Integration Services, MySql and SET FMTONLY ON

Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!  Read more...
By Gerald Britton 2015/06/25 | Source: | Category: integration services
Rating: |  Discuss |   Briefcase | 2,707 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Which user function do I use?

Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you...  Read more...
By Kenneth Fisher 2015/06/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,043 reads

Some simple examples of querying xml with sql

XML is a beast if you've never tackled it. Here are some simple examples of what I discovered as I...  Read more...
By g00p3 2015/06/30 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,600 reads
Question of the Day

Integer lengths (I)

By Tom Thomson 2015/06/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 822 reads

J is a column of type INT.  Under what circumstances does the logical expression

CAST(J as CHAR(8)) =STR(J)
evaluate to true? (Assume that ANSI NULLS is ON, and that SQL 2014 is...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
424 1816 SSCommitted  
390 1819 SSCommitted  
371 438 SSC-Addicted  
Jeff Moden
347 37837 SSC-Dedicated  
343 574 Mr or Mrs. 500  
Latest forum posts