Come to InsideSQL on June 14

Inside SQL is the Deep Dive conference for SQL Server professionals in London on June 14.

STRING_SPLIT() in SQL Server 2016 : Follow-Up #2

Aaron Bertrand rounds out his series on STRING_SPLIT() in SQL Server 2016 with additional tests comparing splitting techniques to TVPs.

Byte Me: Coins Only

Continuous Integration with Microsoft SQL Server

What about database development? In most projects, developers aren’t focused on database development and for proper CI, the database version should keep neck to neck with the application builds.

SQL Server AlwaysOn Endpoint Encryption Algorithm Compatibility Error

Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard.

Be the first to try Redgate SQL Compare 12

Hot on the heels of the SQL Server 2016 general release, the team at Redgate have just released beta builds for both SQL Compare and SQL Data Compare. As well as support for SQL Server 2016, these releases introduce a brand new user interface, and squash a whole host of bugs. In this blog post, Carly Meichen takes a closer look at what's new, and explains how you can give the development team your feedback and requests.

Looking at VIEWs, Close Up

Views in SQL can be difficult. It isn't easy to judge when to use them, It isn't always obvious how to determine if a view can be indexed or if it is updateable. Joe Celko takes a tricky topic and comes up with some helpful guidelines.

How to Query Comma Seperated Value Columns in SQL

Karthik provides a simple solution to querying a table that has comma separated values.

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!

The End of Big Data

What is next for big data? Some experts claim that data "volumes, velocity, variety and veracity" will only increase over time, requiring more data storage, faster machines and more sophisticated analysis tools. However, this is short-sighted, and does not take into account how data degrades over time. Analysis of historical data will always be with us, but generation of the most useful analyses will be done with data we already have. To adapt, most organizations must grow and mature their analytical environments. Lockwood Lyon shares the steps they must take to prepare for the transition.