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

Headlines today   October 13, 2015

Find Permission Changes In The Default Trace

Learn how to find who has changed permissions from the default trace   Read more...
By Lori Brown 2015/10/13 | Source: | Category: permissions
Rating: |  Discuss |   Briefcase | 1,064 reads

SQL Server 2014 and Windows Azure Blob Storage Service: Better Together

This technical article will cover in depth SQL Server 2014 Data Files on Azure Blob storage service, starting from step-by-step configuration  Read more...
By Additional Articles 2015/10/13 | Source: Microsoft MSDN | Category: sql server 2014
Rating:  Rate this |   Briefcase | 717 reads

Webinar: Database version control - optional or required?

Join Justin Dearing and Elizabeth Ayer to hear about some of the key challenges of database version control, and why it's only a matter of time before it's as essential as good backups and high performance.  Read more...
By Additional Articles 2015/10/13 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 1,180 reads
Previous headlines

SQL Server Migration

Some SQL migrations require keeping the server name, instance name, IP, and port number. Geoff Ruble shares some notes on his recent experience with a SQL Server migration.  Read more...
By Geoff Ruble 2015/10/12 | Source: | Category: migration
Rating: |  Discuss |   Briefcase | 2,795 reads

Power BI Desktop Web Queries to Screen Scrape Data from Websites

I have heard the new Power BI Desktop can screen scrape data off websites; how does that process work?  Read more...
By Additional Articles 2015/10/12 | Source: | Category: power bi
Rating: (not yet rated)  Rate this |   Briefcase | 1,940 reads

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 | 12,718 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 | 3,701 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,239 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:  Rate this |   Briefcase | 3,944 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 | 3,008 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SQL Data Generator–Masking Production Data

I learned a new trick with SQL Data Generator that I wasn’t aware of previously. I think this is a...  Read more...
By Steve Jones 2015/10/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,637 reads

Trace Flags in Azure SQL Database

One of the ways that you take more direct control over your SQL Server instances is through the use of...  Read more...
By Grant Fritchey 2015/10/13 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 302 reads
Question of the Day


By Satish Chaudhary 2015/10/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 731 reads
What will be the results from this batch?

INSERT INTO #t1 VALUES (1),(2),(3)
SELECT ID... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
1023 1120 Ten Centuries  
Piotr ER
905 4646 SSCarpal Tunnel  
633 1405 Ten Centuries  
397 834 SSC Eights!  
Iwas Bornready
371 5531 SSCertifiable  
Latest forum posts