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,852 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,004 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,758 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,072 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,283 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,186 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 | 912 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,896 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,759 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,205 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,095 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 | 574 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
1323 3393 Hall of Fame  
2.
BLOB_EATER
557 1109 Ten Centuries  
3.
BillLudlow
485 3243 Hall of Fame  
4.
ShaynThomas1983
483 1464 Ten Centuries  
5.
dbserv
444 3580 Hall of Fame  
Latest forum posts