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  database lifecycle  linq  management  powershell  simple talk  simple  sql server  sql  talk  virtual 
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: Sat, 10 Dec 2016 19:32:37 +0000

 



The Dangers of TechnoMarketingBabble

Thu, 01 Dec 2016 17:18:14 +0000

Everyone’s encouraged to be a content producer these days. It’s not marketing, it’s content! Sometimes the tell-tale signs are obvious. The author feels obliged to lapse into unrestrained hyperbole in the first paragraph, proclaiming unprecedented greatness for some unproven new feature or technology that represents a “total revolution” in the way you tackle a certain …

The post The Dangers of TechnoMarketingBabble appeared first on Simple Talk.




Lists With, or Without, Ranges in both T-SQL and PowerShell

Thu, 01 Dec 2016 15:19:02 +0000

Whether you are working in a procedural language like PowerShell or in T-SQL, there is something slightly bothersome about having to deal with parameters that are lists, or worse with ranges amongst the values. In fact, once you have a way of dealing with them, they can be convenient, especially when bridging the gulf between application and the database. Phil Factor shows how to deal with them.…

The post Lists With, or Without, Ranges in both T-SQL and PowerShell appeared first on Simple Talk.




LINQ Debugging and Visualization

Thu, 01 Dec 2016 14:01:21 +0000

LINQ is certainly extraordinarily useful. It brings the power of query expressions to C#, allowing an easy way of getting the data you need from a variety of data sources. Up to now, there hasn't been a VS debugger for LINQ that gives you the means to visualise the data at every point in the chain. Michael Sorens, a keen LINQ user, describes a third-party tool that now promises to make using LINQ something we can all participate in.…

The post LINQ Debugging and Visualization appeared first on Simple Talk.




How to Build Your First SQL Server Virtual Lab in Windows Azure

Thu, 01 Dec 2016 13:49:41 +0000

If you are a DBA who hasn't so far dived in head-first into using Azure, it is worth setting up an Azure 'Virtual Lab' environment the easy way, using a template. This will then allow you to experiment, try things out with SQL Azure, and get familiar with Resource Groups. Joshua shows how to build a virtual lab, from the ground up in the first of a series that aims to give you a grounding in Azure.…

The post How to Build Your First SQL Server Virtual Lab in Windows Azure appeared first on Simple Talk.




Reconciling Data Across Systems Using a Reconciliation Hub

Thu, 01 Dec 2016 13:38:50 +0000

In many enterprises, where there are a number of separate systems engaged in processing data, there arises the daunting task of checking and reconciling data as it flows between systems. Discrepancies in data must be detected, tracked and corrected as quickly as possible: there is no room for error in doing this. A Reconciliation Hub can provide the answer, as Rahul Gupta explains.…

The post Reconciling Data Across Systems Using a Reconciliation Hub appeared first on Simple Talk.




Planning for Successful Data Management

Tue, 29 Nov 2016 15:50:24 +0000

It is the data, in particular, that sets Database Lifecycle Management apart from the mainstream of application delivery. Data entities, and the way that organisations understand and deal with them, have their own lifespan. If we neglect the management of data, we risk disaster for the organisations that use it. If we take data management seriously, databases become a lot easier. …

The post Planning for Successful Data Management appeared first on Simple Talk.




Determining What Happens When You Force an Execution Plan via the Query Store

Tue, 29 Nov 2016 13:40:00 +0000

When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request to force a plan will fail, and you will want to know when and why. There are several ways of getting feedback, ranging from the built-in reports to using extended events. Enrico explains the details.…

The post Determining What Happens When You Force an Execution Plan via the Query Store appeared first on Simple Talk.




Virtue in the Virtual

Mon, 21 Nov 2016 15:50:31 +0000

Are we now seeing just a frisson of excitement amongst database professionals at the potential of virtualization, and containerization technologies? I read with interest Andrew Pruski’s recent post on SQL Server and containers. Wow, I thought: so I can now run a Docker SQL Server Express in a Hyper-V Container on Windows Server 2016! Then …

The post Virtue in the Virtual appeared first on Simple Talk.




DevOps and Database Lifecycle Management

Fri, 18 Nov 2016 18:12:44 +0000

Database Lifecycle Management (DLM) aims to provide a roadmap of what is required, and when, to deliver and maintain effective databases that can respond quickly to business change. How does the DevOps movement, as it applies to databases, fit into this? William Brewer explains how DevOps provides the organisational change between delivery and operations to make important parts of the process easier to introduce.…

The post DevOps and Database Lifecycle Management appeared first on Simple Talk.




Hyper-V and PowerShell: The Basics

Fri, 18 Nov 2016 11:28:48 +0000

Because it is important with maintaining Virtual Machine environments to be able to repeat routine tasks completely accurately, Windows PowerShell has grown in importance for the job. Now you can manage the Hyper-V environment via PowerShell without needing to use the Hyper-V Manager console. It opens up many opportunities for automation.…

The post Hyper-V and PowerShell: The Basics appeared first on Simple Talk.