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

Headlines today   October 8, 2015

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,758 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 | 2,900 reads
Previous headlines

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,623 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,396 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,339 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 | 521 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,793 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,080 reads

Learning about FOR JSON

Links and information about the FOR JSON clause in SQL Server 2016.  Read more...
By Site Owners 2015/10/05 | Source: | Category: for json
Rating: |  Discuss |   Briefcase | 2,846 reads

Power Query Formula Language in Power BI Desktop

The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch. In this article, Rob Sheldon demonstrates how to use it in Power BI Desktop to extract data from its source, filter rows, specify the columns, clean the data, and create visualisations.  Read more...
By Additional Articles 2015/10/05 | Source: SimpleTalk | Category: power bi
Rating:  Rate this |   Briefcase | 1,694 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Session Event Metadata

There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to...  Read more...
By Jason Brimhall 2015/10/08 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 526 reads

Bitwise XOR in DAX

In T-SQL and other languages we have bitwise XOR natively supported; the T-SQL operator is simply ^. Here’s the explanation of...  Read more...
By Jared Zagelbaum 2015/10/08 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 991 reads
Question of the Day

Filetable Insert Triggers

By Andy Warren 2015/10/08 | Category: filetable
Rating: (not yet rated) |  Discuss |   Briefcase | 608 reads

Using SQL 2014 we've enabled filestream access and successfully created a filetable called Documents and tested adding files to it via the file system emulator (right click the table, click...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1036 1102 Ten Centuries  
Piotr ER
889 4521 SSCarpal Tunnel  
782 1405 Ten Centuries  
Iwas Bornready
399 5531 SSCertifiable  
397 834 SSC Eights!  
Latest forum posts