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

Welcome to SQLServerCentral.com

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

Rss
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: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 638 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,111 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,216 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: MSSQLTips.com
Rating:  Rate this |   Briefcase | 1,342 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: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 474 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,508 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,650 reads

Maintenance Routines for AlwaysOn

How to determine what replica(s) to perform maintenance routines  Read more...
By Ginger Keys 2016/12/05 | Source: SQLServerCentral.com | Category: always on
Rating: |  Discuss |   Briefcase | 842 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,178 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,617 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,530 reads
Question of the Day

Password Policy

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

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

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Eirikur Eiriksson
317 6561 SSCertifiable  
2.
alok.seth
244 244 SSC Veteran  
3.
Jeff Moden
233 42072 SSC-Forever  
4.
Ed Wagner
203 9954 SSCrazy Eights  
5.
princerastogi
195 216 SSC Veteran  
Latest forum posts