Introduction

Introduction to Microsoft R Services in SQL Server 2016

• by Tomaž Kaštrun

• SQLServerCentral.com

• Microsoft

• Article

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.94 (16)

Log in or register to rate

You rated this post out of 5. Change rating

2019-01-25 (first published: 2016-09-15)

8,167 reads

• Discuss

Private Cloud, What Is It and Why Do You Need It?

• by Additional Articles

• SimpleTalk

• Cloud Computing

• Article

Even when organisations cannot make full use of public cloud for reasons of security or bandwidth limitations, many of the advantages of flexibility and rapid deployment can be made by providing a private cloud. Jaap Wesselius wonders if private clouds provide a new paradigm for enterprises.

2014-03-26

4,096 reads

An Introduction to Windows Azure Table Storage

• by Additional Articles

• SimpleTalk

• Azure

• Article

Windows Azure Tables are intended for the storage of large amounts of schemaless data. Tables are just containers of rows of data. Mike Wood describes the practicalities of getting started with using the system.

2014-01-09

2,593 reads

Primary Key Primer for SQL Server

• by Additional Articles

• SimpleTalk

• Primary Key (PK)

• Article

Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules, but if you get them right from the start with a database design, the whole process of database development is simpler, and the result is likely to perform better. We asked Phil for advice, little knowing that the explanation might take a while.

2013-12-19

5,005 reads

PowerShell Data Basics: File-Based Data

• by Additional Articles

• SimpleTalk

• PowerShell

• Article

One of the frustrations of anyone beginning with PowerShell is the simple task of getting data in and out. To help out with this, Michael Sorens begins a series that shows you how to import data from most of the common file formats and sources. He also shows how to export data in a range of formats.

2013-12-10

2,654 reads

RE: Strange behaviour using SQL Server 2000

• by paliz

• SQLServerCentral.com

• Reply

Okay, makes sense, but does not explain why the text suddenly appears when I remove the photo field...?? As I mentioned above it works fine when the text datatype is VARCHAR - what confuses me is that I have used the same datatypes on earlier websites with no problems... Luckily the propertyDescription will not be […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-11-09

Multiple datasets

• by Ron-Fowler

• SimpleTalk

• Topic

I created a RS report that contains 2 datasets.  The first dataset calls a stored procedure that populates a table. The second dataset contains a select statement that pulls from the table that is populated via the stored procedure in the first dataset.  Dataset2 is the source for the report.My problem is that dataset1 correctly […]

2004-03-23

2 reads

RE: Invalid cursor state

• by Frank Kalis

• SimpleTalk

• Reply

Thanks for posting that info!

2004-03-11

RE: Inserting lots of data into a temp table, does not keep sort order

• by john-132685

• SimpleTalk

• Reply

Well this is what the microsoft ratbastards passing themselves off as product developers excel at: changing fundamental functionality from version to version and causing people to have to go back and change their application code.The answer is that now they expect you to use the ORDER BY in statements when you care about sequence (sometimes regardless of […]

2004-03-11

RE: Worst Practice - Not Qualifying Objects With The Owner

• by Mike Good

• SimpleTalk

• Reply

I have accepted this recommendation due to the performance impact, and don't argue that.  But I find that this has killed for me the utility of object-ownership in general.  Has anyone made good use of object ownership since following this "always owner-qualify object references" guideline?  I haven't.  Just an extra "dbo." that I have to add everywhere--more typing with no benefit.   But back […]

2004-03-10