Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,858,149 DBAs, developers and SQL Server users

Rss
Headlines today   May 5, 2016

Understanding OPENJSON and FOR JSON in Azure and SQL 2016

An example of exporting and importing table data with JSON in Azure and SQL Server 2016.  Read more...
By Ryan Loftin 2016/05/05 | Source: SQLServerCentral.com | Category: openjson
Rating: |  Discuss |   Briefcase | 1,085 reads

ASP.NET Core: A More Realistic Starter Kit

ASP.NET Core is a fascinating platform with many good ideas, but in its present form (RC1)there is a culture shock for experienced ASP.NET developers to experience the effort involved in porting a realistic application. There is an obvious advantage on being able to host an application on any web server, but is this enough to compensate for losing the convenience of an integrated pipeline?  Read more...
By Additional Articles 2016/05/05 | Source: SimpleTalk | Category: asp.net
Rating: (not yet rated)  Rate this |   Briefcase | 1,504 reads
Previous headlines

Data Mining Part 39: Azure Machine Learning vs Microsoft Data Mining

In earlier chapters, we talked about the Microsoft Data Mining enemies. We will talk now about Microsoft Azure Machine Learning.  Read more...
By Daniel Calbimonte 2016/05/04 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 620 reads

Free eBook: SQL Server Internals: In-Memory OLTP

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton.  Read more...
By Press Release 2016/05/04 (first published: 2015/05/13) | Source: Redgate | Category: ebook
Rating:  Rate this |   Briefcase | 21,053 reads

STRING_SPLIT() in SQL Server 2016 : Follow-Up #1

Aaron Bertrand follows up on a recent post about the performance of STRING_SPLIT() with a few additional reader-motivated tests.  Read more...
By Additional Articles 2016/05/04 | Source: SQLPerformance.com | Category: string_split
Rating: (not yet rated)  Rate this |   Briefcase | 2,136 reads

GUI Enhancement on Instant File Initialization (IFI) in SQL Server 201

Ability to enable Instant File Initialization during the installation of SQL Server 2016.  Read more...
Rating: |  Discuss |   Briefcase | 937 reads

Execute Dynamic SQL commands in SQL Server

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?  Read more...
By Additional Articles 2016/05/03 | Source: MSSQLTips.com | Category: dynamic sql
Rating:  Rate this |   Briefcase | 3,604 reads

Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout

Your SQL Agent Jobs may be silently failing when using Linked Servers.  Read more...
By Chad Feghali 2016/05/02 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,089 reads

Announcing Bilm Academy

Join Andy Leonard the week of May 9-13 for 5 free days of Biml training.   Read more...
By Press Release 2016/05/02 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 3,698 reads

Getting started with Azure SQL Data Warehouse

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.  Read more...
By Additional Articles 2016/05/02 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,568 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

Partition to Filegroup Mapping in SQL Server

Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition...  Read more...
By Guy Glantser 2016/05/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,493 reads

Upcoming Florida IT Pro Camps

Two IT Pro Camps coming up, register soon! IT Pro Camp – Jacksonville FL – June 11 at Keiser UniversityIT Pro Camp – Tampa...  Read more...
By Andy Warren 2016/05/05 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 490 reads
Question of the Day

UNICODE

By Steve Jones 2016/05/05 | Category: unicode
Rating: (not yet rated) |  Discuss |   Briefcase | 718 reads

What does this return?


DECLARE @n NCHAR(10);
SET @n = N'??????????';
SELECT UNICODE(@n);
  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Wryan138
845 3396 Hall of Fame  
2.
BLOB_EATER
475 1112 Ten Centuries  
3.
BillLudlow
430 3261 Hall of Fame  
4.
Iwas Bornready
428 7109 SSCertifiable  
5.
Amour
423 423 SSC-Addicted  
Latest forum posts