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

Rss
Headlines today   February 24, 2017

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 | 2,853 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: (not yet rated)  Rate this |   Briefcase | 1,112 reads
Previous headlines

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,188 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 | 4,708 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 | 571 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 | 3,543 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 | 776 reads

Getting Started with Azure SQL Data Warehouse - Part 1

As the demand for data analytics grows so does the need for a technology or platform to process large amounts of different types of data in timely manner. Azure SQL Data Warehouse is a new enterprise-class, elastic petabyte-scale, data warehouse service that can scale according to organizational demands in just a few minutes. Read on to learn more about this data warehouse-as-a-service offering from Microsoft.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,052 reads

Back to Basics: Capturing Baselines on Production SQL Servers

If you have not been capturing baselines on your production servers, then today is the day you can start. This article provides scripts, valid for SQL Server 2005 and higher, which anyone can use to capture basic information about a SQL Server instance.  Read more...
By Erin Stellato 2017/02/20 (first published: 2012/11/27) | Source: SQLServerCentral.com | Category: baselines
Rating: |  Discuss |   Briefcase | 29,744 reads

New CREATE OR ALTER statement in SQL Server 2016 SP1

Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.  Read more...
By Additional Articles 2017/02/20 | Source: MSSQLTips.com | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 3,545 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Improve performance by replacing temp tables with memory optimized tables - Part 3

Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/). Previously we...  Read more...
By SQL DBA in HK 2017/02/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,732 reads

Permanent Employment v Contracting: How the figures stack up

In my latest learning tree newsletter, I discussed analysing some of the salary survey data that the good folks over...  Read more...
By David Postlethwaite 2017/02/24 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,241 reads
Question of the Day

SQL Server Just Runs Faster - TDE

Rating: (not yet rated) |  Discuss |   Briefcase | 343 reads

What enhancement in SQL Server 2016 reduces the CPU load of TDE?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
GilaMonster
8300 55791 SSC Guru  
2.
Jeff Moden
7336 52958 SSC Guru  
3.
Steve Jones - SSC Editor
4555 41129 SSC-Forever  
4.
Lowell
3123 18139 SSCoach  
5.
Lynn Pettis
2627 26964 One Orange Chip  
Latest forum posts