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

Previous headlines

Centrally collect replication conflicts and send an alert

Automatically capture replication conflicts and generate an automated email notification.  Read more...
By Kimberly Killian 2016/02/05 (first published: 2011/10/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,478 reads

Microsoft Survey on Backup and Security

Microsoft is looking for some people to talk to for ~20 minutes via phone/Skype and as a thank you for sharing, will provide a $10 Amazon gift card after the call.  Read more...
By Press Release 2016/02/05 | Source: SQLServerCentral.com | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 235 reads

How to read data from multiple Excel worksheets with SQL Server Integration Services

Read this tip to learn how to import data from multiple Excel worksheets into SQL Server using SSIS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,831 reads

SQL Azure Performance Benchmarking

An evaluation of the SQL Azure Database Performance Levels recommended by the DTU Calculator service, and a comparison with on premise SQL Server performance.  Read more...
By Paul Brewer 2016/02/04 | Source: SQLServerCentral.com | Category: sql azure
Rating: |  Discuss |   Briefcase | 904 reads

Monitoring In-Memory OLTP: What's Important?

In-Memory OLTP has evolved to be a great solution. However, a production system that uses it needs careful monitoring to avoid stress conditions becoming problems. As with many new features of SQL Server, it pays to plan a monitoring strategy to ensure that you are alerted as soon as possible when things go awry.  Read more...
By Additional Articles 2016/02/04 | Source: SimpleTalk
Rating:  Rate this |   Briefcase | 1,459 reads

Stairway to Database Source Control Level 4: Getting a Database into Source Control (Distributed Repository)

Now that we have our database under source control, we will want to share our work with other developers. If we are in a centralized source control system, our changes may be committed straight into the central repository. When we are working in a distributed system, it means pulling down any changes from other developers, addressing any areas of conflict, and pushing our changes up to allow others to benefit from our work. This allows our changes to be synchronized with the changes other developers have made. This level is principally about setting up a distributed source control system, namely Git, and how to commit database development changes to a local repository, before pushing them into a remote 'central' repository for sharing with other developers. The next level will delve a little deeper into Git's versioning mechanisms, and show some examples of how to share database changes during development, and how to deal with conflicting changes.  Read more...
By Dave Green 2016/02/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,549 reads

Simplify SQL Server ETL Processes with T-SQL Stored Procedures

Jeremy Kadlec introduces the Enhanced Data Integration Suite (EDIS), a SQL Server T-SQL stored procedure based solution to automate, manage, and audit ETL processes so you no longer have to manually build SSIS Packages.   Read more...
By Additional Articles 2016/02/03 | Source: MSSQLTips.com | Category: etl
Rating:  Rate this |   Briefcase | 3,448 reads

SQL Server System Audit Report

Ensuring that your SQL Server is secure is the job of every Database Administrator. In this article I will provide a script to help perform easier audits of your system.  Read more...
By Rudy Panigas 2016/02/02 | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 2,628 reads

Data security, SQL Server 2016, and Your Business

From an IT infrastructure and compliance perspective, the importance of protecting data is clear. But it also has profound business implications and can even be a competitive differentiator by helping drive customer loyalty and retention. David Hobbs-Mallyon talks about Microsoft’s approach to data security.  Read more...
By Additional Articles 2016/02/02 | Source: TechNet Blogs | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 2,076 reads

Find and Remove Duplicate Records SQL Server

Learn a quick method to find and remove duplicate records in your SQL Server tables.  Read more...
By Ginger Keys 2016/02/01 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 5,558 reads
 
Ask SQL Server Central



Question of the Day

CHECKSUM_AGG

By Steve Jones 2016/02/05 | Category: checksum_agg
Rating: (not yet rated) |  Discuss |   Briefcase | 714 reads

What does the CHECKSUM_AGG() function do?

  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Ed Wagner
385 7914 SSCertifiable  
2.
Hugo Kornelis
312 7098 SSCertifiable  
3.
Orlando Colamatteo
308 7664 SSCertifiable  
4.
ALPESH.KARP
273 1133 Ten Centuries  
5.
Rick.Cornell.SME
258 5302 SSCertifiable  
Latest forum posts