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  execution plans  overlapping ranges  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: Tue, 24 Apr 2018 06:07:22 +0000

 



SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database

Mon, 23 Apr 2018 20:36:08 +0000

The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships.…

The post SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database appeared first on Simple Talk.




Create Azure VMs with PowerShell Part 1

Sat, 21 Apr 2018 02:21:04 +0000

Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM. …

The post Create Azure VMs with PowerShell Part 1 appeared first on Simple Talk.




Extending the Unity Editor with C#

Wed, 18 Apr 2018 14:55:41 +0000

The next step in learning how to create games in C# using Unity is to add extensions to get custom functionality. Lance Talbert shows you how to create an extension that changes the properties of many objects at once.…

The post Extending the Unity Editor with C# appeared first on Simple Talk.




Finding overlapping ranges of data

Wed, 18 Apr 2018 03:59:58 +0000

This week, I had a problem where I needed to find and eliminate from the results of my query, data with overlapping ranges. I have written about this topic before, in my database design book book, in regards to building a trigger to avoid overlapping ranges. But even though I have written on the topic …

The post Finding overlapping ranges of data appeared first on Simple Talk.




When You Need A DBA: Inhouse Vs Outsourced

Tue, 17 Apr 2018 17:22:32 +0000

One big question for software developers and IT departments in small companies is always “should I hire a DBA?” The fact that one is asking this question demonstrates that there are some symptoms that need a deeper diagnosis than you can handle. This may be a concern about backup procedures, database slowness for users, or errors …

The post When You Need A DBA: Inhouse Vs Outsourced appeared first on Simple Talk.




Sharing is Caring: Using Memory Mapped Files in .NET

Tue, 17 Apr 2018 13:58:02 +0000

Sharing and reusing large objects between components and services can save time and computing resources. Tom Fischer explains how to take advantage of the Memory Mapped Files feature of .NET to help boost performance.…

The post Sharing is Caring: Using Memory Mapped Files in .NET appeared first on Simple Talk.




Provisioning SQL Server Instances with Docker

Mon, 16 Apr 2018 14:49:43 +0000

With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker.…

The post Provisioning SQL Server Instances with Docker appeared first on Simple Talk.




Creating Intelligent Bots Using the Microsoft Bot Framework

Thu, 12 Apr 2018 23:37:57 +0000

Azure, Microsoft's cloud, provides dozens of services to make cloud development fast without the need to worry about infrastructure such as hardware. In this article, Jakub Kaczmarek explains the benefits and challenges of creating a bot using the Microsoft Bot Framework found on Azure. He also walks you through creating a simple bot.…

The post Creating Intelligent Bots Using the Microsoft Bot Framework appeared first on Simple Talk.




Execution Plans and Data Protection

Tue, 10 Apr 2018 15:52:55 +0000

One of the most important tools for query tuning is the ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection. …

The post Execution Plans and Data Protection appeared first on Simple Talk.




SQL Server Closure Tables

Tue, 10 Apr 2018 13:13:52 +0000

SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information that is important to the relationship between objects. In this article, Phil Factor explains how to use closure tables to overcome this deficiency.…

The post SQL Server Closure Tables appeared first on Simple Talk.