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  new  server  simple talk  simple  sql server  sql  storage  system  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, 22 Mar 2017 18:09:03 +0000

 



Glasnost in IT: Discarding the Old Certainties

Mon, 13 Mar 2017 15:09:45 +0000

Three of Redgate’s tools are now part of the 2017 release of Visual Studio Enterprise (as announced last week), as components of the Data Storage and Processing ‘workload’. Some might be surprised to find third-party tools being included in the Visual Studio installer, but it’s an interesting sign of the times. No longer can any …

The post Glasnost in IT: Discarding the Old Certainties appeared first on Simple Talk.




Introducing DLM Techniques for a Multi-Database Multi-Server System

Thu, 09 Mar 2017 20:53:21 +0000

Although the techniques of Database Lifecycle Management can reduce the timescales for the delivery of new functionality to business systems, what if the database 'layer' consists of several large interdependent databases and data flows with replication and audit? Does DLM scale to this level of complexity? Margaret Cruise O'Brien starts a series of articles that describes the practicalities of improving DLM within an existing framework and team supporting a multi-database multi-server system, by describing some of the database management problems and solutions in an enterprise-scale database.

The post Introducing DLM Techniques for a Multi-Database Multi-Server System appeared first on Simple Talk.




Using the DbFit Framework for Data Warehouse Regression Testing

Wed, 08 Mar 2017 18:00:05 +0000

It is ironic that the users of database application need to rely on the very technologists that created the system to then devise and run their acceptance tests. Surely someone has devised a test system for databases that is simple enough for ordinary tech-savvy people to use and for them to create the tests? Yes they have. Fitnesse DbFit is a mature product that can, and does, test SQL Server databases, and Nat Sundar explains how to set it up and do it.…

The post Using the DbFit Framework for Data Warehouse Regression Testing appeared first on Simple Talk.




Encrypting SQL Server: Dynamic Data Masking

Wed, 08 Mar 2017 17:39:21 +0000

Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an application. It doesn't encrypt the data, and a knowledgeable SQL user can defeat it. However it provides a simple way to administer from the database what data the various users of a database application can and can not see, making it a useful tool for the developer.…

The post Encrypting SQL Server: Dynamic Data Masking appeared first on Simple Talk.




Working with Windows Containers and Docker: Up and Running

Tue, 07 Mar 2017 16:36:17 +0000

Deployments can be made easier, in many different ways, by using Docker and Windows Containers; but how do you set about working with them? As part of his practical series on Windows Containers and Docker, Nicolas shows how to deploy a Container Host to the Microsoft Azure cloud. retrieve Images from Docker Hub, build your own container image, and push your images to the Docker Hub. …

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




Introduction to Azure Logic Apps

Tue, 07 Mar 2017 16:16:09 +0000

LogicApps are a managed service that provides the Lego blocks of Azure serverless architecture that you can use to create, develop and deploy cloud-based integrations and workflows. The developer merely strings together off-the-self, ready-made components with as little effort as possible. The aim is to go from development to production in a few simple, reproducible steps. Microsoft are investing strongly in this technology, introducing many new connectors in line with the demands of the integration requirements of enterprises.…

The post Introduction to Azure Logic Apps appeared first on Simple Talk.




Old is the New New: SQL Server 2016 Learns Ancient Auditing Tricks

Mon, 06 Mar 2017 15:12:17 +0000

The new temporal tables in SQL Server 2016 are interesting, in that they seem a much better way of storing any financial information than conventional relational tables. They have been referred to by some as “SQL Server’s time machine”. They are system-versioned tables that allow SQL Server to maintain the different versions each row, using …

The post Old is the New New: SQL Server 2016 Learns Ancient Auditing Tricks appeared first on Simple Talk.




Using an R Package within SQL Server with Real time analysis in Power BI

Tue, 28 Feb 2017 09:16:06 +0000

We all know how easy it is to run R, together with dependent packages, from SQL Server on order to do statistical analysis, and then turn the result into a real-time graph using Power BI; but can you actually do it? Saurabh Desai gives a step-by-step hand-holding guide to turn even the most timid into a BI guru. There is nothing difficult in using R in SQL Server 2016 once you know the steps.…

The post Using an R Package within SQL Server with Real time analysis in Power BI appeared first on Simple Talk.




Deploying Multiple SSIS Projects via PowerShell

Mon, 27 Feb 2017 17:32:10 +0000

When there are several SSIS projects with packages in a SQL Server Database or Data Warehouse development, automated deployments as part of Continuous Integration can get tricky. Nat Sundar describes how he created a Deployment script that is intended to provision a Data Warehouse for System Integrated testing (SIT).…

The post Deploying Multiple SSIS Projects via PowerShell appeared first on Simple Talk.




Exploring Azure Storage for SQL Server DBAs – Part 2

Mon, 27 Feb 2017 15:36:13 +0000

Managed Disks have simplified way that Azure storage interacts with the users' virtual machines, thanks to the way that it eliminates the need to deal with the Storage Account. It is now easier to add new disks to a virtual machine, either in PowerShell or via the portal. The Storage Spaces feature in Windows Server can be used to aggregate disks together and obtain higher levels of performance. Joshua Feierman explains how to do it all.…

The post Exploring Azure Storage for SQL Server DBAs – Part 2 appeared first on Simple Talk.