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,921 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,649 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,779 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 | 1,989 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,404 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,765 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,902 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,438 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 | 549 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,939 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,191 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 | 801 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
890 4568 SSCarpal Tunnel  
705 1405 Ten Centuries  
397 834 SSC Eights!  
Iwas Bornready
390 5531 SSCertifiable  
Latest forum posts