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.
2016-06-07
7,307 reads
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.
2016-06-07
6,986 reads
Karthik provides a simple solution to querying a table that has comma separated values.
2016-06-06
8,568 reads
When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!
2016-06-03 (first published: 2015-04-14)
26,426 reads
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.
2016-06-03
10,764 reads
Natively consume JSON data from API sources with SQL 2016 and CLR
2016-06-02
8,889 reads
In order to keep the demands of the job under control, any DBA needs to automate as many as possible of the suitable tasks that their role demands. What makes a task suitable? How do you judge whether it is worthwhile? Can we take a 'managed', consistent, decision? Joshua Feierman explains the practicalities with a real example.
2016-06-02
6,359 reads
Please re-apply CU#6 for SQL Server 2014 SP1 as it has been updated.
2016-06-01
6,727 reads
In this article, Fikrat Azizov describes the different approaches to maintaining statistics and shows how you can use the data from your servers for intelligent statistics updates.
2016-06-01
3,273 reads
Power BI is as extensible as it is powerful In this article you will see how to impress your users with added visuals
2016-05-31
11,067 reads
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers