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

Headlines today   October 5, 2015

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 | 1,189 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 | 1,044 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: (not yet rated)  Rate this |   Briefcase | 450 reads
Previous headlines

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,159 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: (not yet rated)  Rate this |   Briefcase | 4,184 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,688 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,028 reads

Stairway to MDX - Level 15: Basic Set Functions: The Tail() Function

Return, in order, a specified number of elements from the end of a set. SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Tail() function.  Read more...
By Bill Pearson 2015/09/30 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,376 reads

Install SQL Server Management Studio with Web Installer without Internet Access

One of the new features of SQL Server 2016 is the introduction of a Web Installer for the client tools. In this article, Daniel Farina goes through the entire process of downloading and installing the client tools even on machines without internet access.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,427 reads

Wildcard Searches

Using wildcard to find patterns in strings going from the basics to some more complicated conditions.  Read more...
By Luis Cazares 2015/09/29 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,901 reads
Ask SQL Server Central

From the SQLServerCentral Blogs

SSMS Connection Information

If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...  Read more...
By Kenneth Fisher 2015/10/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 301 reads

Deployed Session Settings

You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking...  Read more...
By Jason Brimhall 2015/10/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 190 reads
Question of the Day

Identity Column

By Shiva N 2015/10/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 220 reads
What is the answer from Query 4?


    id INT IDENTITY(1, 1)

  , sometext VARCHAR(10)

  , somenumber INT


INSERT INTO RandomTableName



      , 1





      , 2;

... 
Top Members (last 30 days)
# Name Score Level
30 days All-time
1028 1094 Ten Centuries  
Piotr ER
928 4367 SSCarpal Tunnel  
851 1405 Ten Centuries  
397 834 SSC Eights!  
Iwas Bornready
345 5447 SSCertifiable  
Latest forum posts