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

Headlines today   October 6, 2015

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 | 2,328 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: (not yet rated) |  Discuss |   Briefcase | 340 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,000 reads
Previous headlines

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 | 4,587 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,583 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,436 reads

SQL Server Stored Procedures and SET options

SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.  Read more...
By Nakul Vachhrajani 2015/10/02 (first published: 2013/08/29) | Source: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 13,898 reads

How to Avoid Conditional JOINs in T-SQL

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.   Read more...
By Additional Articles 2015/10/02 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,855 reads

Navigating Hadoop Resources

Learn where to get the latest installation and learning resources for the ever-evolving components of Hadoop ecosystem and how those components may complement Microsoft SQL Server common everyday tasks.  Read more...
By Daniel Klionsky 2015/10/01 | Source: | Category: big data
Rating: |  Discuss |   Briefcase | 2,885 reads

Creating Dashboards for Mobile Devices with Datazen

In this fourth installment, Arshad Ali demonstrates creating filters, publishing dashboards to the Datazen server and creating drill-through dashboards.  Read more...
By Additional Articles 2015/10/01 | Source: Database Journal | Category: mobile dashboard
Rating: (not yet rated)  Rate this |   Briefcase | 2,197 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

Calculate Percentage Share in Power BI (DAX)

What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI...  Read more...
By Samuel Vanga 2015/10/06 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,018 reads

Intro to the Social DBA with a bit of #SQLHelp

Are you a Social DBA?  No I don’t mean that you are a DBA and attend a myriad of merry mixers,...  Read more...
By Robert Pearl 2015/10/06 | Source: | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 816 reads
Question of the Day

Filetable Trivia

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

Did the word trivia in the title of a Question of the Day make you shiver? Or cackle with anticipation? Let's see if you really know your Filetable from your Kitchentable! (select...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1035 1101 Ten Centuries  
Piotr ER
967 4460 SSCarpal Tunnel  
851 1405 Ten Centuries  
397 834 SSC Eights!  
Iwas Bornready
388 5490 SSCertifiable  
Latest forum posts