Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Welcome to

A Microsoft SQL Server community of 1,831,954 DBAs, developers and SQL Server users

Previous headlines

How efficient is your covered index?

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.  Read more...
By Simon Liew 2015/10/09 (first published: 2013/08/12) | Source: | Category: covering index
Rating: |  Discuss |   Briefcase | 11,710 reads

Storing Passwords in a Secure Way in a SQL Server Database

Measures such as using special characters and numbers within a password are of little use to security if passwords are then stored in an insecure way. Sergey Gigoyan explains how to encrypt and store passwords in a SQL Server database.  Read more...
By Additional Articles 2015/10/09 | Source: | Category: storing passwords
Rating: (not yet rated)  Rate this |   Briefcase | 2,864 reads

Data Mining Part 32:The Microsoft Data Mining Enemies

In this chapter, we will talk about the competition of Data Mining  Read more...
By Daniel Calbimonte 2015/10/08 | Source: | Category: microsoft
Rating: |  Discuss |   Briefcase | 2,007 reads

SQL and R

There is plenty that is novel and perhaps foreign to a new R user, but it's no reason to abandon your hard-earned SQL skills! In this article, Casimir Saternos explains that not only can you easily retrieve data from SQL Sources for analysis and visualisation in R, but you can also use SQL to create, clean, filter, query and otherwise manipulate datasets within R, using a wide choice of relational databases.  Read more...
By Additional Articles 2015/10/08 | Source: SimpleTalk | Category: r platform
Rating: (not yet rated)  Rate this |   Briefcase | 3,431 reads

Level 4 - Building the Hyper-V VM

In this level of the Stairway to Server Virtualization, learn how to build a Hyper-V virtual machine for SQL Server.  Read more...
By David Klee 2015/10/07 | Source: | Category: virtualization
Rating: |  Discuss |   Briefcase | 2,779 reads

Follow-Up on Cursor Options

In this follow-up to a previous article, Aaron Bertrand reiterates that – while you should never just accept the defaults – you really should think about which options are most applicable to your scenario.  Read more...
By Additional Articles 2015/10/07 | Source: | Category: cursor options
Rating: (not yet rated)  Rate this |   Briefcase | 3,954 reads

SSIS Design Pattern - Staging Fixed Width Flat Files

Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.  Read more...
Rating: |  Discuss |   Briefcase | 3,449 reads

Shorten Audits, Tighten Security with Minion Enterprise

Minion Enterprise can help you with security management in an enterprise.  Read more...
By Press Release 2015/10/06 | Source: | Category: press release
Rating: |  Discuss |   Briefcase | 551 reads

Automatic UNDO in Oracle

Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many UNDO segments to create at startup, and what is the underlying goal of the process? David Fitzjarrell investigates.  Read more...
By Additional Articles 2015/10/06 | Source: Database Journal | Category: oracle
Rating: (not yet rated)  Rate this |   Briefcase | 1,956 reads

Write Cleaner T-SQL Using Version Control

If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to write better, cleaner, more readable code.  Read more...
By Ed Elliott 2015/10/05 | Source: | Category: source control
Rating: |  Discuss |   Briefcase | 5,202 reads
Ask SQL Server Central

Question of the Day

Whats the count???

By twin devil 2015/10/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 809 reads

What will the value in ThatMyRowCount?

SELECT TOP 10 * FROM sys.all_objects
SELECT TOP 5 * FROM sys.all_objects

Top Members (last 30 days)
# Name Score Level
30 days All-time
1035 1103 Ten Centuries  
Piotr ER
876 4568 SSCarpal Tunnel  
658 1405 Ten Centuries  
397 834 SSC Eights!  
Iwas Bornready
380 5531 SSCertifiable  
Latest forum posts