Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,857,731 DBAs, developers and SQL Server users

Headlines today   April 28, 2016

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,011 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 | 1,534 reads
Previous headlines

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: | Category: ssis
Rating: |  Discuss |   Briefcase | 848 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,518 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: | Category: server-level collation
Rating: (not yet rated)  Rate this |   Briefcase | 1,426 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: | Category: resource governor
Rating: |  Discuss |   Briefcase | 1,136 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: | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 1,839 reads

The Practical Problems of Determining Equality and Equivalence in SQL

In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.  Read more...
By Additional Articles 2016/04/26 | Source: SimpleTalk
Rating: (not yet rated)  Rate this |   Briefcase | 2,623 reads

Verify SQL Backups With SQL Powershell

With SQL Powershell, you can check all your database backups in minutes, whether you have ten SQL servers or 100.   Read more...
By Geoff Ruble 2016/04/25 | Source: | Category: sql backups
Rating: |  Discuss |   Briefcase | 1,678 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/25 (first published: 2014/09/04) | Source: | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,517 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Server Service Broker – Error Handling  

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...  Read more...
By Colleen M. Morrow 2016/04/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 622 reads

SQL Server 2016: What’s the best new feature?

With SQL 2016 around the corner, and my blog without a post this year, I thought I would write about...  Read more...
By 2016/04/28 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,519 reads
Question of the Day

A Token Escape

By Andy Warren 2016/04/28 | Category: sql agent
Rating: (not yet rated) |  Discuss |   Briefcase | 630 reads

Picture if you will the prototypical DBA. Smart, good looking, calm in the face of danger? That's the one! Now imagine that you look over to the cube next to...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1372 3393 Hall of Fame  
559 1108 Ten Centuries  
545 1464 Ten Centuries  
521 3207 Hall of Fame  
444 3576 Hall of Fame  
Latest forum posts