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

Headlines today   February 8, 2016

tSQLt and the INSERT EXEC Problem

A proposed solution to the INSERT EXEC problem in tSQLt  Read more...
By Charles Silbergleith 2016/02/08 | Source: | Category: ms sql
Rating: |  Discuss |   Briefcase | 1,424 reads

Exploration of SQL Server 2016 Always Encrypted – Part 3

In this third article of the exploring SQL Server 2016 Always Encrypted series, Greg Larsen looks at the differences between an Always Encrypted column that uses an encryption type of Deterministic and those that use encryption type of Randomized.  Read more...
By Additional Articles 2016/02/08 | Source: Database Journal | Category: sql server 2016
Rating: (not yet rated)  Rate this |   Briefcase | 636 reads
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: | Category: replication
Rating: |  Discuss |   Briefcase | 2,533 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: | Category: backup and restore
Rating: (not yet rated) |  Discuss |   Briefcase | 265 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 | 2,004 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: | Category: sql azure
Rating: |  Discuss |   Briefcase | 928 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,541 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: | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,577 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: | Category: etl
Rating:  Rate this |   Briefcase | 3,609 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: | Category: audit
Rating: |  Discuss |   Briefcase | 2,667 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Running code on the startup of SQL Server

Every now and again you need to run code when your instance starts up. For example you might want to...  Read more...
By Kenneth Fisher 2016/02/08 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 413 reads

PowerShell Pester Testing for Parameter Validation

This error caught me out. I am putting this post here firstly to remind me if I do it again...  Read more...
By Rob Sewell 2016/02/08 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 287 reads
Question of the Day

Bitwise OR

By Junior Galvão - MVP 2016/02/08 | Category: bitwise
Rating: (not yet rated) |  Discuss |   Briefcase | 376 reads

The following example creates a table with int data types to show the original values and puts the table into one row. 

USE tempdb;

WHERE TABLE_NAME = 'bitwise')
... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
Ed Wagner
390 7921 SSCertifiable  
Orlando Colamatteo
308 7664 SSCertifiable  
Hugo Kornelis
307 7099 SSCertifiable  
286 1146 Ten Centuries  
258 5302 SSCertifiable  
Latest forum posts