Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,874,418 DBAs, developers and SQL Server users

Headlines today   December 7, 2016

Stairway to Exploring Database Metadata Level 5: Exploring Facts About Tables

Now that we've explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.  Read more...
By Phil Factor 2016/12/07 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 743 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2016/12/07 (first published: 2013/08/07) | Source: Redgate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 78,345 reads

SQLBits 2017

SQLBits 2017 has been announced. The conference will take place on April 5-8, 2017 in Telford, UK.  Read more...
By Additional Articles 2016/12/07 | Source: SQLBits | Category: sqlbits
Rating:  Rate this |   Briefcase | 1,369 reads

Cloning a SQL Server Login with all permissions using PowerShell

Cloning a SQL Server login with permissions that match another login is a common task. In this post, Jeffrey Yao shows how this an be done using PowerShell.  Read more...
By Additional Articles 2016/12/07 | Source:
Rating:  Rate this |   Briefcase | 1,648 reads
Previous headlines

Non-Numeric Measures in DAX

Enhance the functionality of your SSAS Tabular and PowerBI output, by understanding HOW-, WHY- and WHEN to leverage the power of DAX to create text, date or Boolean measures.  Read more...
By James McGillivray 2016/12/06 | Source: | Category: dax
Rating: |  Discuss |   Briefcase | 482 reads

Azure SQL Database - Authenticating Application Access by Using Azure AD Tokens

Learn how to leverage Azure Active Directory when connecting to Azure SQL Database from applications or services in a non-interactive manner, by relying on token-based authentication.  Read more...
By Additional Articles 2016/12/06 | Source: Database Journal | Category: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,664 reads

Have you adopted database DevOps?

Redgate invites you to participate in a survey to uncover rates of adoption of DevOps practices among Microsoft SQL Server database users. The survey will take between 5 and 10 minutes to complete. All respondents who provide a valid email address will be sent a copy of the research report when available, as well as being entered into a prize draw to win a $250 Amazon gift card.  Read more...
By 2016/12/06 (first published: 2016/12/02) | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 4,733 reads

Maintenance Routines for AlwaysOn

How to determine what replica(s) to perform maintenance routines  Read more...
By Ginger Keys 2016/12/05 | Source: | Category: always on
Rating: |  Discuss |   Briefcase | 853 reads

Representing Hierarchical Data for Mere Mortals

Why is it that we use XML, but with so little enthusiasm when it does so much, and is so feature-rich? Phil Factor argues that there are better ways of doing it, more complete than JSON, but easier to read than XML. To try to convince you, he gives a set of flying demos, using PowerShell and his PSYaml module, to illustrate how YAML can let you work faster, and more accurately.  Read more...
By Additional Articles 2016/12/05 | Source: SimpleTalk | Category: hierarchical data
Rating:  Rate this |   Briefcase | 2,224 reads

Use SSMS and Visual Studio?

Redgate is running a short survey to better understand the tools you're using for database development. There are eleven questions, and three $50 Amazon gift cards up for grabs as a thank you for responding.  Read more...
By 2016/12/05 | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 2,763 reads
Redgate DevOps Survey

From the SQLServerCentral Blogs

VMware vSphere 6.5 breaks your SQL Server vNUMA settings

VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine,...  Read more...
By kleegeek 2016/12/07 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,686 reads
Question of the Day

Password Policy

By Steve Jones 2016/12/07 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 563 reads

I am creating a login and see there is a CHECK_POLICY option. What does this do?

Top Members (last 30 days)
# Name Score Level
30 days All-time
Eirikur Eiriksson
312 6562 SSCertifiable  
262 283 SSC Veteran  
244 244 SSC Veteran  
Jeff Moden
236 42077 SSC-Forever  
Ed Wagner
203 9955 SSCrazy Eights  
Latest forum posts