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  correlation  server  simple talk  simple  sql server  sql  statistics sql  statistics  talk  visual studio 
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: Mon, 24 Apr 2017 14:28:18 +0000

 



Generating HTML from SQL Server Queries

Fri, 21 Apr 2017 17:32:08 +0000

You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.…

The post Generating HTML from SQL Server Queries appeared first on Simple Talk.




A DLM Approach to Database Testing

Thu, 13 Apr 2017 14:22:04 +0000

Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release.…

The post A DLM Approach to Database Testing appeared first on Simple Talk.




Statistics in SQL: Simple Linear Regressions

Thu, 13 Apr 2017 13:38:50 +0000

Although linear regressions can get complicated, most jobs involving the plotting of a trendline are easy. Simple Linear Regression is handy for the SQL Programmer in making a prediction of a linear trend and giving a figure for the level probability for the prediction, and what is more, they are easy to do with the aggregation that is built into SQL.…

The post Statistics in SQL: Simple Linear Regressions appeared first on Simple Talk.




Statistics in SQL: Kendall’s Tau rank correlation

Mon, 10 Apr 2017 10:50:25 +0000

Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating correlation, regression and variance on large quantities of data. It just isn't always immediately obvious how. In the second of a series of articles, Phil factor shows how calculating a non-parametric correlation via Kendall's Tau or Spearman's Rho can be stress-free.…

The post Statistics in SQL: Kendall’s Tau rank correlation appeared first on Simple Talk.




The Oxford Comma and Me

Fri, 07 Apr 2017 12:34:04 +0000

Many people in IT, even at Redgate where I work, see the job title “Editor” and think I spend most of my time fixing spelling mistakes, adding Oxford Commas, and thwarting an author’s ambitions to end a sentence with a preposition. They are sometimes bemused, therefore, when they learn how long a proper technical edit …

The post The Oxford Comma and Me appeared first on Simple Talk.




Ten Unsung Visual Studio Time-Savers

Thu, 06 Apr 2017 16:39:43 +0000

We all have our favourite third-party extensions to Visual Studio, and although we all like Resharper, there are many others that could well make your development work easier. To celebrate the fact that Visual Studio Enterprise now includes ReadyRoll Core, SQL Prompt Core, and SQL Search as part of the Data storage and processing workload, Michael Sorens describes nine of his current favourite extensions, and wonders if he's missing anything in his list.…

The post Ten Unsung Visual Studio Time-Savers appeared first on Simple Talk.




Questions About SQL Server Collations You Were Too Shy to Ask

Thu, 06 Apr 2017 16:15:05 +0000

Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask…

The post Questions About SQL Server Collations You Were Too Shy to Ask appeared first on Simple Talk.




Working with the Azure Blob Storage Service

Thu, 06 Apr 2017 16:06:15 +0000

Azure Blob Storage is the essential foundation of most Azure services. It is important to understand how this service actually works, the types of storage resilience offered and how the service is charged. Christos Matskas gives an overview of one of the most important of all cloud services.…

The post Working with the Azure Blob Storage Service appeared first on Simple Talk.




Scala and Apache Spark in Tandem as a Next-Generation ETL Framework

Thu, 06 Apr 2017 15:52:53 +0000

Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering it as an alternative. After all, many Big Data solutions are ideally suited to the preparation of data for input into a relational database, and Scala is a well thought-out and expressive language. Krzysztof Stanaszek describes some of the advantages and disadvantages of a scala-based approach to implementing and testing an ETL solution. …

The post Scala and Apache Spark in Tandem as a Next-Generation ETL Framework appeared first on Simple Talk.




Statistics in SQL: Pearson’s Correlation

Thu, 06 Apr 2017 15:36:50 +0000

Some people will assure you that you can't do any serious statistical calculations in SQL. In the first of a series of articles, Phil factor aims to prove them wrong by explaining how easy it is to calculate Pearson's Product Moment Correlation.…

The post Statistics in SQL: Pearson’s Correlation appeared first on Simple Talk.