Subscribe: Simple Talk rss feed
http://www.simple-talk.com/feed/
Added By: Feedage Forager Feedage Grade A rated
Language: English
Tags:
algorithm  appeared simple  appeared  application  data  metaphone algorithm  server  simple talk  simple  sql server  sql  tables  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, 17 Feb 2017 15:48:38 +0000

 



Introducing a DevOps Workgroup to Farm Credit Services of America

Thu, 16 Feb 2017 17:12:13 +0000

If you are introducing DevOps workflows into a large organization, you’ll need to plan carefully and prioritize tasks, adapt, maintain a thick skin, communicate constantly, and ensure that all teams have a chance to contribute their solutions. Bob Walker explains how FCSA set up a DevOps Workgroup, its philosophy and its goals for improving database and application deployment processes.…

The post Introducing a DevOps Workgroup to Farm Credit Services of America appeared first on Simple Talk.




A Quick Look At Two New DMV Columns for Tuesday

Tue, 14 Feb 2017 23:39:09 +0000

I have learned over the years that some people really like it when I am verbose, long-winded, redundant and carry an otherwise small sentence on forever until you wonder to yourself, “Really, what it he point here?”, and then there are the other 98% of the people who stumble on my posts and articles and …

The post A Quick Look At Two New DMV Columns for Tuesday appeared first on Simple Talk.




Scaling out SSRS on SQL Server Standard Edition

Tue, 14 Feb 2017 15:33:59 +0000

The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS on SQL Server Standard Edition, it required some creative thinking. This article describes his solution, its merits and drawbacks.…

The post Scaling out SSRS on SQL Server Standard Edition appeared first on Simple Talk.




The Common Problems of Data Grids

Tue, 14 Feb 2017 14:38:59 +0000

Data grids are easy to do in HTML, and if we want anything complicated in terms of scrolling, locking and data entry, we usually shrug and buy a component to do it. However, there is a lot to be said for the approach of creating tables using a basic JavaScript platform such as jQuery, perhaps using a plugin which you can then customise. Dino talks you through this approach, showing how to take the DataTables plugin and implement locked columns, on-demand paging and filtering.…

The post The Common Problems of Data Grids appeared first on Simple Talk.




String Comparisons in SQL: The Metaphone Algorithm

Tue, 14 Feb 2017 12:32:05 +0000

When exploring the use of the Metaphone algorithm for fuzzy search, Phil couldn't find a SQL version of the algorithm so he wrote one. The Metaphone algorithm is built in to PHP, and is widely used for string searches where you aren't always likely to get exact matches, such as ancestral research and historical documents. It is particularly useful when comparing strings word-by-word. With a SQL version, it is easy to experiment on large quantities of data!…

The post String Comparisons in SQL: The Metaphone Algorithm appeared first on Simple Talk.




SQL Server Temporal Tables: How-To Recipes

Fri, 10 Feb 2017 18:51:29 +0000

Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 2016, make such tables behave like any other. How do you create one, or modify an existing table? How can you get an In-Memory Optimized OLTP table to be Temporal? Alan Grinberg shows how. …

The post SQL Server Temporal Tables: How-To Recipes appeared first on Simple Talk.




SQL Server Encryption: Always Encrypted

Fri, 10 Feb 2017 18:20:54 +0000

Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Robert Sheldon explains what it is, why you should try it out, and how to set about it.…

The post SQL Server Encryption: Always Encrypted appeared first on Simple Talk.




The Harsh Reality Behind Big Data Misuse

Fri, 10 Feb 2017 16:56:51 +0000

Big Data has its origin in science, but it is now being used commercially to increase the information that organizations have about people. This information can uniquely identify individuals and reveal their likes, habits, propensities and wealth. The power of this information is so great that legislation on its use is having to become more …

The post The Harsh Reality Behind Big Data Misuse appeared first on Simple Talk.




User Acceptance Testing and the Application Lifecycle

Fri, 03 Feb 2017 18:08:56 +0000

User Acceptance Testing (UAT) is an important part of the development process. If carried out as early as possible and as regularly as possible, it not only alerts the development team to aspects that don't yet meet the requirements of the users, but also gives governance a better idea of progress. If UAT is delayed, defects become expensive and troublesome to fix. Sophia Segal gives an experienced summary view of UAT…

The post User Acceptance Testing and the Application Lifecycle appeared first on Simple Talk.




Metaprogramming

Thu, 02 Feb 2017 19:23:42 +0000

Over the history of personal computing, it seems that the best software was written by a team of five or fewer programmers. CP/M, the first PC operating system was built by one guy, Gary Kildall, though he got parts from others such as Gordon Eubanks. MSDOS originated in QDOS, again written by one person, Tim …

The post Metaprogramming appeared first on Simple Talk.