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

Headlines today   October 9, 2015

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,488 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,591 reads
Previous headlines

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,969 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,346 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,748 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,793 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,425 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 | 547 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,900 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,176 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Licensing

Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to...  Read more...
By SQL DBA in HK 2015/10/09 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,183 reads

How to View and analyze SQLite Blob Data?

SQLite is one of the most commonly used database engine in the world. Its source code is available in public...  Read more...
By zorastalin 2015/10/09 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 504 reads
Question of the Day

Whats the count???

By twin devil 2015/10/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 771 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
897 4568 SSCarpal Tunnel  
734 1405 Ten Centuries  
397 834 SSC Eights!  
Iwas Bornready
390 5531 SSCertifiable  
Latest forum posts