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,880,821 DBAs, developers and SQL Server users

Rss
Headlines today   February 27, 2017

Performance Dashboard Error: Could not find stored procedure

In this article, you will learn how to troubleshoot error when you try to launch the main Dashboard Report.  Read more...
Rating: |  Discuss |   Briefcase | 408 reads

The Last Week for SQL Bits 2017 Discounts

This is the last week for a discounted registration to SQL Bits 2017. The price goes up after Mar 4, so register today.  Read more...
By Press Release 2017/02/27 | Source: SQLBits | Category: sqlbits
Rating: (not yet rated)  Rate this |   Briefcase | 680 reads

Encrypting SQL Server: Using an Encryption Hierarchy to Protect Column Data

SQL Server Encryption is an essential part of what is required for protecting data. Column-level encryption can be a very effective way of doing this. In the first in a series of articles on the theme of SQL Server Encryption, Robert Sheldon once more makes it all seem easy.  Read more...
By Additional Articles 2017/02/27 | Source: SimpleTalk | Category: encryption
Rating:  Rate this |   Briefcase | 1,063 reads
Previous headlines

Enumerate Windows Group Members

Here a quick script showing how to get all the Active Directory users in a AD group.  Read more...
By Lowell Izaguirre 2017/02/24 (first published: 2016/03/17) | Source: SQLServerCentral.com | Category: active directory
Rating: |  Discuss |   Briefcase | 3,130 reads

Using SQL SERVER and Cloud Hosted Databases with OBIEE 11g

If your organisation is committed to using Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g /12c as their BI solution, you aren't thereby committed to using Oracle throughout your organisation. You can use a range of data sources including SQL Server, and save a great deal of money by doing so. Sadly, Oracle will only support the use of the venerable SQL Server 2008 R2. Zafar Ali demonstrates how to connect OBIEE to the world beyond Oracle.  Read more...
By Additional Articles 2017/02/24 | Source: SimpleTalk | Category: business intelligence (bi)
Rating:  Rate this |   Briefcase | 2,169 reads

SQL Server Trace Flags - Complete list

Article in markdown format: https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md  Read more...
By Konstantin Taranov 2017/02/23 | Source: SQLServerCentral.com | Category: trace-flag
Rating: |  Discuss |   Briefcase | 1,374 reads

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.  Read more...
By Additional Articles 2017/02/23 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 6,087 reads

Stairway to Exploring Database Metadata Level 7: Extended Properties

In this level, I’ll introduce Extended Properties. As with the previous levels, I want to illustrate as much as possible with practical and immediately useful code.   Read more...
By Phil Factor 2017/02/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 639 reads

Questions About the Use of PowerShell That you were Too Shy to Ask

Let's forget the actual PowerShell code for a moment: Why is PowerShell important? Why should I use it? Where did it come from? Why did it take so long to arrive? These and many other basic questions are answered in William Brewer's latest addition to the series that answers those seemingly simple questions that you were too shy to ask in public.  Read more...
By Additional Articles 2017/02/22 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,298 reads

In Search of Elasticity

An Evaluation of the Azure SQL Database Ecosystem.  Read more...
By Alex Chamchourine 2017/02/21 | Source: SQLServerCentral.com | Category: azure sql database
Rating: |  Discuss |   Briefcase | 806 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Azure Cognitive Services Text Analytics – An API Calling Application

Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in the Gold Coast on Azure...  Read more...
By Rolf Tesmer (Mr. Fox SQL) 2017/02/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 506 reads

Digital Privacy is the Wild West

Who has the legal right to access your personal and private digital assets? The answer can be complex, and will...  Read more...
By Tim Mitchell 2017/02/27 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 479 reads
Question of the Day

DBCC PAGE

By Henrico Bekker 2017/02/27 | Category: dbcc
Rating: (not yet rated) |  Discuss |   Briefcase | 354 reads

What permissions are required to execute DBCC IND and DBCC PAGE in SQL Server?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
10533 58335 SSC Guru  
2.
Jeff Moden
9334 55310 SSC Guru  
3.
Steve Jones - SSC Editor
5505 42362 SSC-Forever  
4.
Lowell
3926 19058 SSCoach  
5.
Lynn Pettis
3213 27677 One Orange Chip  
Latest forum posts