Subscribe: Simple Talk rss feed
http://www.simple-talk.com/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
appeared simple  appeared  azure data  azure  data lake  data  lake store  server  simple talk  simple  sql server  sql  talk 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Simple Talk rss feed

Simple Talk



A technical journal and community hub from Redgate



Last Build Date: Wed, 16 Aug 2017 12:03:12 +0000

 



IT Aphorisms for Developers

Mon, 14 Aug 2017 18:06:01 +0000

Developers enter their trade fizzing with untamed creative energy. They envision spending their days dashing out intricate algorithms that compile first time, developing creative applications that dazzle colleagues and users alike, before leaving the office each evening, with a swagger in their step, to work their new GitHub ‘side project’, which will one day soon …

The post IT Aphorisms for Developers appeared first on Simple Talk.




Simple SQL: Random Thoughts

Fri, 11 Aug 2017 17:27:44 +0000

How does one get a truly random sample of data of a certain size from a SQL Server database table. Well, there are simple non-portable tricks one can use, such as the NewID() function, but then refining those can be tricky. Take the Rand() function for a start. Can it really provide you with a truly random number? Why doesn't the TABLESAMPLE clause give you a set number of rows? Joe Celko scratches his head a bit, explains some of the issues and invites some suggestions and tricks from readers.…

The post Simple SQL: Random Thoughts appeared first on Simple Talk.




Uploading Files to Azure Data Lake Using a .NET App

Fri, 11 Aug 2017 17:10:41 +0000

Azure Data Lake Store is an extendable store of Cloud data in Azure. You can move data to and from Azure Data Lake Store via Azure data Factory or Azure SQL Database and connect to a variety of data sources. You can script upload files from on-premise or local servers to Azure Data Lake Store using the Azure Data Lake Store .NET SDK. Ambily KK shows how easy it is to get started by setting up a script or App to move data to Azure Data Lake Store.…

The post Uploading Files to Azure Data Lake Using a .NET App appeared first on Simple Talk.




SQL Server R Services: Working with ggplot2 Statistical Graphics

Fri, 11 Aug 2017 16:42:29 +0000

It is when you use R in SQL Server with one of the huge range of packages that comes with it that you can begin to appreciate the power of the system. With a package such as ggplot there are many 'knobs one can twiddle' in order to get spectacular and informative visualisations. Rob Sheldon continues his beginners series for R in SQL Server by showing how to refine the output to get it as you need it.…

The post SQL Server R Services: Working with ggplot2 Statistical Graphics appeared first on Simple Talk.




Should You Consider Agile for Very Large IT Projects?

Fri, 11 Aug 2017 16:00:08 +0000

Many large organisations are compelled to embark on wide-ranging business-transformation IT projects. They are difficult to manage because, in the intervening months before the end of the project, the changing business environment will have forced further changes on the business. Agile holds out the promise of managing these changes more easily. Mohammad Rizvi explains, from experience, some of the the issues you are likely to face, and how you can solve them.…

The post Should You Consider Agile for Very Large IT Projects? appeared first on Simple Talk.




Creating a Custom .NET Activity Pipeline for Azure Data Factory

Fri, 11 Aug 2017 15:39:40 +0000

Azure Data Factory provides a radical new cloud-based way of collecting and preparing data in preparation for its storage and analysis. How do you get started with it to explore the possibilities it provides? Feodor Georgiev shows the practicalities of how to go about the task of preparing a pipeline for use, from preparing the Azure environment to downloading a file from a FTP to a blob storage in the Azure environment…

The post Creating a Custom .NET Activity Pipeline for Azure Data Factory appeared first on Simple Talk.




Monitoring UnmatchedIndexes Warning

Mon, 07 Aug 2017 06:25:22 +0000

If you are using filtered indexes in SQL Server, it worthwhile monitoring the UnmatchedIndexes warning, it can give us very interesting insights. Filtered indexes and parameterized queries are terrible enemies. I explained a bit about parameterized queries in my article about how to identify them using query store, you can read it here. When a …

The post Monitoring UnmatchedIndexes Warning appeared first on Simple Talk.




The Power of Python and SQL Server 2017

Fri, 04 Aug 2017 16:00:09 +0000

Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL Server, but it can be used for far more than this, with any Python libraries or Frameworks. To provide an example of what is possible, Hitendra shows how to use the feature securely to provide intelligent application caching, where SQL Server can automatically indicate when data changes to trigger a cache refresh. …

The post The Power of Python and SQL Server 2017 appeared first on Simple Talk.




Who was that masked man anyway?

Thu, 03 Aug 2017 13:52:27 +0000

Whenever you require a visit to the doctor, or hospital, a lot of personal data will likely be recorded, alongside details of your condition, the treatment you required, drugs prescribed and so on. At some point, you might have signed a consent form, one of the clauses of which allowed your data to be analyzed …

The post Who was that masked man anyway? appeared first on Simple Talk.




Statistics in SQL: Student’s t-test

Thu, 03 Aug 2017 11:29:58 +0000

Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test suitable for students. In fact it was William Sealy Gosset, an Englishman publishing under the pseudonym Student, who developed the t-test and t distribution in 1908, as a way of making confident predictions from small sample sizes of normally-distributed variables. As Gosset's employer was Guinness, the brewer, Phil Factor takes a sober view of calculating it in SQL.…

The post Statistics in SQL: Student’s t-test appeared first on Simple Talk.