Subscribe: Simple Talk rss feed
http://www.simple-talk.com/feed/
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
appeared simple  appeared  automating azure  automating  azure  profiler  server  simple talk  simple  sql server  sql  ssms  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: Fri, 20 Oct 2017 12:44:25 +0000

 



Extended Events Profiler (XE Profiler) in SSMS

Fri, 20 Oct 2017 10:09:32 +0000

Starting in SSMS version 15.3, we have an interesting new feature: Extended Events Profiler (XE Profiler). This new feature is in a very early stage, but it seems to be a first step to replace SQL Profiler, which is already deprecated. Two different session templates appear under the new ‘XE Profiler’ item in object explorer: ‘Standard’ …

The post Extended Events Profiler (XE Profiler) in SSMS appeared first on Simple Talk.




Simple SQL: Handling Location Datatypes

Thu, 19 Oct 2017 10:25:17 +0000

How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth system based on the SQL specification of the Open Geospatial Consortium (OGC). However, this is not the only approach, as Joe Celko explains. …

The post Simple SQL: Handling Location Datatypes appeared first on Simple Talk.




Working with Angular and its Technology Stack in .NET

Thu, 19 Oct 2017 09:54:41 +0000

Angular is a great way of creating single-page applications that are easily testable, and have Dependency Injection and Separation of Concerns built-in with the framework. However, it faces you with having to make architectural choices and the best choice depends on the needs of the project, the team's expertise, and the deadlines. So how do you get started, and which is the right path for your particular application?…

The post Working with Angular and its Technology Stack in .NET appeared first on Simple Talk.




Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

Wed, 18 Oct 2017 17:14:59 +0000

Can you imagine it? You are in a group of smart database people, and they are debating the finer points about AWS DMS, and you don't even know what the letters stand for. You just feel too shy to ask those basic questions that seem ridiculous once you're up to speed. Laerte Junior answers all the questions you need answers for when facing the prospect of getting familiar with Amazon's useful Database Migration Servic…

The post Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask appeared first on Simple Talk.




Don’t Stop Learning

Wed, 18 Oct 2017 16:34:01 +0000

A few years ago, I found myself teaching an in-depth SQL Server Reporting Services (SSRS) class at a local tech center. I had some great students in the class, who were engaged and excited about the material. During the breaks, they talked about their careers, and how what they learned would help them do their …

The post Don’t Stop Learning appeared first on Simple Talk.




Even More SQL Server Features that Time Forgot

Wed, 18 Oct 2017 11:30:52 +0000

SQL Server works well, and Microsoft does everything it can to keep it relevant and competitive: As with everything in real life, it doesn't don't always get it completely right, and Rob Sheldon continues his quest through the jungle of past features to rediscover and explore the ones that time forgot. Here, he comes across Lightweight Pooling, XML Indexes, Stretch Databases, SQL Variants, Transaction Savepoints and In-Memory OLTP.…

The post Even More SQL Server Features that Time Forgot appeared first on Simple Talk.




Automating Azure: Creating an On-Demand HDInsight Cluster

Wed, 18 Oct 2017 10:05:21 +0000

This article pulls together the concepts from two previous articles to demonstrate a way to automate the “on-demand” creation and deletion of an HDInsight cluster. This not only serves as a demonstration of the power of automating Azure provisioning, but is a practical solution for the user who only occasionally requires the power of HDInsight for scalable computations.…

The post Automating Azure: Creating an On-Demand HDInsight Cluster appeared first on Simple Talk.




Automating Azure: How to Deploy a Temporary Virtual Machine Resource

Wed, 18 Oct 2017 09:54:13 +0000

Because Azure is designed from the ground-up to allow automated provisioning, It provides a number of interesting opportunities for use. With a .NET language such as C#, it is possible to create a very flexible 'on-demand' infrastructure in Azure, using Azure Resource Manager templates, that allows users to economically deploy the resources they need just for the interval of time that they are required, and then destroy them. …

The post Automating Azure: How to Deploy a Temporary Virtual Machine Resource appeared first on Simple Talk.




Easy way to create policies using SSMS

Mon, 09 Oct 2017 03:28:41 +0000

SSMS has an interesting feature that turns easy the creation of policies to check our servers compliance. Right-clicking an item inside object explorer window, you will find ‘Facet’ item in the context menu. Clicking on it will open the ‘View Facets’ window. In the ‘View Facets’ window, you can see all the facets related to …

The post Easy way to create policies using SSMS appeared first on Simple Talk.




SQL Server Coming in on Another Platform

Thu, 05 Oct 2017 17:25:43 +0000

Why release SQL Server as a Linux, as well as Windows, application? It baffled many DBAs when it was announced, though most shrugged and decided that it must be part of Microsoft’s long-term wrestling match with Oracle. When Microsoft previewed an early version of the Linux SQL Server on Ubuntu and Red-Hat, with ‘core relational …

The post SQL Server Coming in on Another Platform appeared first on Simple Talk.