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

Previous headlines

Create stunning visualizations with Power View in 20 minutes or less!

Learn about Microsoft’s latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!  Read more...
By Amir Charania 2016/04/29 (first published: 2014/12/30) | Source: SQLServerCentral.com | Category: power view
Rating: |  Discuss |   Briefcase | 11,062 reads

Write for SQLServerCentral - Bonus for Azure

We're always looking for articles, but here are a few ones that I'd like to see written up.  Read more...
By Site Owners 2016/04/29 (first published: 2014/09/04) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,772 reads

Questions About PowerShell Basics That You Were Too Shy To Ask

Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.  Read more...
By Additional Articles 2016/04/29 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,219 reads

Generate a SSIS-package that reads from Twitter using Biml

Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter.  Read more...
Rating: |  Discuss |   Briefcase | 1,302 reads

Azure SQL Database Elastic Database Jobs

In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.  Read more...
By Additional Articles 2016/04/28 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,331 reads

Data Mining Part 38: Text Mining - The term lookup

In this new article, we will show how to use the SSIS term lookup transformation tool.   Read more...
By Daniel Calbimonte 2016/04/27 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 921 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2016/04/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 77,980 reads

How to change server level collation for a SQL Server Instance

Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.  Read more...
By Additional Articles 2016/04/27 | Source: MSSQLTips.com | Category: server-level collation
Rating: (not yet rated)  Rate this |   Briefcase | 1,844 reads

SQL Server Resource Governor

Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.  Read more...
By Arun Sirpal 2016/04/26 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 1,207 reads

Announcing Bilm Academy

Join Andy Leonard the week of May 9-13 for 5 free days of Biml training.   Read more...
By Press Release 2016/04/26 | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 2,207 reads
 
Ask SQL Server Central



Question of the Day

Estimating Vardecimal

By Steve Jones 2016/04/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 593 reads

In SQL Server 2014, I have a table with multiple columns that use the decimal datatype. I am considering implementing row compression and using vardecimal formats. How can I estimate...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Wryan138
1304 3393 Hall of Fame  
2.
BLOB_EATER
482 1109 Ten Centuries  
3.
BillLudlow
463 3243 Hall of Fame  
4.
dbserv
444 3580 Hall of Fame  
5.
ShaynThomas1983
389 1464 Ten Centuries  
Latest forum posts