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  code  data  database source  database  session variables  simple talk  simple  source control  source  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: Mon, 23 Jan 2017 14:41:38 +0000

 



Working with Windows Containers and Docker: The Basics

Mon, 23 Jan 2017 10:20:06 +0000

When you begin to work with containers, you will notice many similarities between a container and a virtual machine; but, in fact, these are two quite different concepts. Containers are going to change the way that we do Windows-based development work in the coming year, and they already underpin much of the devops work of speeding the delivery process. Nicolas Prigent explains how to use the Windows Containers feature.…

The post Working with Windows Containers and Docker: The Basics appeared first on Simple Talk.




Handling Graphs in SQL

Fri, 20 Jan 2017 18:01:56 +0000

Many practical database problems can be tackled more simply and intuitively by graphs or networks, which in this sense are graphs in which attributes can be associated with the nodes and edges. It is a natural way to study relationships within the data. SQL databases aren't the easiest way of doing it, but it makes sense where the scale permits it. Because of the range of graphs and techniques, some Graph theory is unavoidable before you get stuck into the code, and who better to introduce graph databases than Joe Celko? …

The post Handling Graphs in SQL appeared first on Simple Talk.




Continuous Code Quality Inspection with SonarQube

Fri, 20 Jan 2017 17:23:14 +0000

There are many ways that static code analysis can help to speed software delivery. It can pick up, as a preliminary to check-in, errors and weaknesses in code that can happen incidentally to even the most experienced developer. It can give the team a measure of technical debt, and remove the obvious 'noise' from code before it is reviewed. Vishwas introduces a popular Code-quality inspection tool, SonarQube, and takes you through the basics of using it with C# and Java. …

The post Continuous Code Quality Inspection with SonarQube appeared first on Simple Talk.




Tying Down the Source Code

Thu, 19 Jan 2017 17:49:16 +0000

Database source code analysis can flush out weakly-authenticated database users, over-privileged users and roles, or stored procedure code that concatenates a parameter directly into the dynamic SQL string that is to be executed, and so is vulnerable SQL injection. This is great for the development team, but it is also wonderful for the hacker. Getting …

The post Tying Down the Source Code appeared first on Simple Talk.




Core Database Source Control Concepts

Fri, 13 Jan 2017 18:21:02 +0000

Sometimes, it isn't the technicalities or details of database source control that people find difficult, but the general concepts and workflow. In this article, taken from Robert Sheldon's book 'SQL Server Source Control Basics' , he takes a step back from the details to explain the whole purpose of database source control and the most important operations within source control such as versioning, branching and merging.…

The post Core Database Source Control Concepts appeared first on Simple Talk.




Using AWS’s Simple Workflow Service (SWF) with C#

Thu, 12 Jan 2017 17:44:42 +0000

Amazon's Simple Workflow Service (SWF) in AWS provides a model of workflow that is simple to understand but is it simple to get a robust and durable workflow in place? Tom Fischer guides you through the bewildering early stages of your first SWF application, and concludes that workflows inherently take time and effort to get right, but SWF provides a formidable cloud-based solution …

The post Using AWS’s Simple Workflow Service (SWF) with C# appeared first on Simple Talk.




Encrypting SQL Server: Transparent Data Encryption (TDE)

Thu, 12 Jan 2017 16:20:23 +0000

Transparent Data Encryption (TDE) encrypts the data within the physical files of the database, the 'data at rest'. Without the original encryption certificate and master key, the data cannot be read when the drive is accessed or the physical media is stolen. The data in unencrypted data files can be read by restoring the files to another server. TDE requires planning but can be implemented without changing the database. Robert Sheldon explains how to implement TDE.…

The post Encrypting SQL Server: Transparent Data Encryption (TDE) appeared first on Simple Talk.




When a Single ASP.NET Client makes Concurrent Requests for Writeable Session Variables

Thu, 12 Jan 2017 15:11:11 +0000

The design of ASP.NET includes the valuable session variables that enable the application to keep track of individual sessions. Unfortunately the ASP.NET pipeline will not process requests belonging to the same session concurrently but queues them, and executes them serially. MVC locks session variables to ensure thread safety and concurrency control, but takes a conservative approach to polling for these locks. Do you always need this level of thread safety? If not, what can you do to improve performance when you need to use writeable session variables?…

The post When a Single ASP.NET Client makes Concurrent Requests for Writeable Session Variables appeared first on Simple Talk.




Printing from ASP.NET MVC

Thu, 12 Jan 2017 11:22:02 +0000

Even though we're less inclined to print web-pages nowadays, it often makes sense to save useful content from a website as a PDF file to read offline. Modern browsers give us everything we need to do that, and there is much that the website designer can do to improve the results. However, there are times that something more demanding is required, such as a properly-formatted invoice or chart, and then the web application needs a way of creating PDFs directly. …

The post Printing from ASP.NET MVC appeared first on Simple Talk.




Deployment Automation for SQL Server Integration Services (SSIS)

Thu, 12 Jan 2017 09:52:04 +0000

SSIS was not originally designed with automated deployment in mind. However, any database that uses SSIS projects and their packages needs a way of scripting the deployment of them if the database is to be deployed rapidly, or via a build server. Nat Sundar shows a technique that can be extended to manage the scripted deployment of SSIS projects. …

The post Deployment Automation for SQL Server Integration Services (SSIS) appeared first on Simple Talk.