Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,813,297 DBAs, developers and SQL Server users

Rss
Headlines today   July 7, 2015

Translating reports with Analysis Services and MS-Excel

Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment  Read more...
By Jan D'Hondt 2015/07/07 | Source: SQLServerCentral.com | Category: ssas
Rating: |  Discuss |   Briefcase | 2,370 reads

Temporarily Change SQL Server Log Shipping Database to Read Only

I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don't want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.  Read more...
By Additional Articles 2015/07/07 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 966 reads

Monitoring Availability Groups with Redgate SQL Monitor

Anthony Nocentino, experienced Enterprise Architect and Friend of Redgate, explains the challenges presented by monitoring Availability Groups and shows you a technique for monitoring AG replication latency with Redgate SQL Monitor and its Custom Metric functionality.  Read more...
By Anthony Nocentino 2015/07/07 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 696 reads
Previous headlines

Soundex - Experiments with SQLCLR Part 2

Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms  Read more...
By David Poole 2015/07/06 | Source: SQLServerCentral.com | Category: soundex
Rating: |  Discuss |   Briefcase | 2,525 reads

Learning About Temporal Tables

Learn about the new temporal table feature in SQL Server 2016  Read more...
By Site Owners 2015/07/06 | Source: SQLServerCentral.com | Category: temporal tables
Rating: (not yet rated) |  Discuss |   Briefcase | 2,302 reads

Getting to know your customers better – cohort analysis and RFM segmentation in R

It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a range of analyses, and graphs, in order to ensure that you're answering the right question, to explore alternative hypotheses, or to provide insight into a problem. Feodor demonstrates how to quickly, and interactively, explore the ways that customers purchase goods and services using cohort analysis.  Read more...
By Additional Articles 2015/07/06 | Source: SimpleTalk | Category: r language
Rating: (not yet rated)  Rate this |   Briefcase | 1,198 reads

A Quick Tour of the Performance Dashboard Reports

SQL Server Performance Dashboard comprises a set of custom reports that give you nitty gritty details about the performance of your SQL Server instance.  Read more...
By Prett Sons 2015/07/03 (first published: 2013/06/11) | Source: SQLServerCentral.com | Category: performance dashboard reports
Rating: |  Discuss |   Briefcase | 15,793 reads

Press Release: Redgate brings expert SQL Server training to London and Seattle

Cambridge, UK, 2 July 2015 – Redgate, the SQL Server and .NET software company, returns to London and Seattle in October with its enormously popular training event, SQL in the City.   Read more...
By Press Release 2015/07/03 | Source: Redgate | Category: redgate software
Rating: (not yet rated) |  Discuss |   Briefcase | 377 reads

Data Load Optimisation using the SSIS Balanced Data Distributor

Optimize SSIS data loads using parallel processing and the Balanced Data Distributor  Read more...
By Adam Aspin 2015/07/02 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 3,761 reads

How to Fix a Corrupt MSDB SQL Server Database

Keep reading and you will see that there is another way to rebuild the msdb database without compromising the master database.  Read more...
By Additional Articles 2015/07/02 | Source: MSSQLTips.com | Category: msdb
Rating:  Rate this |   Briefcase | 2,685 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Blocking and deadlocking on purpose

Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling...  Read more...
By Kenneth Fisher 2015/07/07 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 979 reads
Question of the Day

Spatial Data Types

By Steve Jones 2015/07/07 | Category: spatial data types
Rating: (not yet rated) |  Discuss |   Briefcase | 649 reads

Is the CurvedPolygon spatial data type a simple or collection type?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Sowbhari
428 1826 SSCommitted  
2.
Jeff Moden
312 37876 SSC-Dedicated  
3.
sgmunson
306 2211 SSCrazy  
4.
JimmyJones
304 449 SSC-Addicted  
5.
GilaMonster
274 42224 SSC-Forever  
Latest forum posts