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 analysis  code  database code  net mvc  number  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: Fri, 23 Jun 2017 16:57:57 +0000

 



Is It Time To Stop Using IsNumeric()?

Fri, 23 Jun 2017 16:43:44 +0000

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.…

The post Is It Time To Stop Using IsNumeric()? appeared first on Simple Talk.




Database Code Analysis

Tue, 20 Jun 2017 19:10:22 +0000

Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.…

The post Database Code Analysis appeared first on Simple Talk.




Working From Home

Tue, 20 Jun 2017 18:43:25 +0000

The idea that one can do nothing useful as a developer unless you are in an open plan office is rather retro. Although we all get that knowing wink when we announce that we are “Working from Home”, the truth is more complicated, I think. Some people are more productive when they work from home, …

The post Working From Home appeared first on Simple Talk.




Visual Studio 2017 and Swagger: Building and Documenting Web APIs

Tue, 20 Jun 2017 16:30:21 +0000

The OpenAPI ‘Swagger’ Specification defines a protocol that allows applications to discover, and generate documentation of methods, parameters and models of REST APIs, This provides a way for any software to identify the features of a REST API. It does for REST APIs what WSDL (Web Service Description Language) did for web services. Visual Studio now provides it to support proxy creation for REST APIs, as Dennes Torres explains.…

The post Visual Studio 2017 and Swagger: Building and Documenting Web APIs appeared first on Simple Talk.




SQL 2017 new DMF: Managing VLOGs in our databases

Tue, 20 Jun 2017 06:17:03 +0000

SQL Server 2017 brings to us some new interesting DMV’s and DMF’s, one of them is sys.dm_db_log_info. This new DMF allows us to manage VLOGs in our databases. The log files are divided in smaller slices called virtual log files, or vlog. Operations such as log truncations happens over an entire vlog. For example, when …

The post SQL 2017 new DMF: Managing VLOGs in our databases appeared first on Simple Talk.




Monitoring Azure Cloud and Hybrid Environments

Mon, 19 Jun 2017 18:16:31 +0000

Cloud-based services and applications must still be monitored just like the on-premise ones. You still need most of your data center activities that ensure that your planning, budgeting, security and service-level obligations are met wherever the data and services are actually hosted. There is much to be said for an integrated approach to providing a unified view of entire application workloads on-premise. hybrid and cloud using the same tools wherever possible. …

The post Monitoring Azure Cloud and Hybrid Environments appeared first on Simple Talk.




SQL Server R Services: The Basics

Mon, 19 Jun 2017 17:59:29 +0000

It is possible to do a great deal with R within SQL Server, but it is best to start by doing analysis in R on numeric data from SQL Server and returning the results to SQL Server. There is great value to be gained even with this basic foundation. Robert Sheldon is on hand to give you a kick start with the first in his series on beginning with R in SQL Server.…

The post SQL Server R Services: The Basics appeared first on Simple Talk.




Filtering Errors in PowerBI

Fri, 09 Jun 2017 11:19:32 +0000

I just faced this problem when trying to analyze some information from google analytics in PowerBI. In my specific situation, I was trying to extract a number from some URL querystrings and filter the rows without the number. When I set the data type of the column to decimal, the rows without a number receive …

The post Filtering Errors in PowerBI appeared first on Simple Talk.




To Fly, To Serve, To Fry Your Servers

Thu, 08 Jun 2017 14:53:15 +0000

So, the story goes that an Ops engineer walked into a data center with the necessary pass, a cheery wave and a ‘good morning’. Shortly afterwards, he made history. At around 8.30AM, British Airway’s entire communications systems went down at the height of the May holiday, forcing them to cancel flights from the UK’s two …

The post To Fly, To Serve, To Fry Your Servers appeared first on Simple Talk.




Control the Controller in ASP.NET MVC

Thu, 08 Jun 2017 09:49:20 +0000

Because of its obvious importance in coordinating the MVC application, we tend to be wary of being too adventurous with it, but there are some interesting features that can sometimes be exploited to provide for less common requirements. The controller in ASP.NET MVC core, for example, can be a plain-old C# class (POCO), making it easier to create file-based content on the fly. The DefaultControllerFactory class can be changed, and you can override the GetControllerType method with a custom factory to give you localized routes and URLs. Dino explores some of the interesting internals of ASP.NET MVC controllers…

The post Control the Controller in ASP.NET MVC appeared first on Simple Talk.