Tag Archives: sql server

Data Overload

Data rich and information poor. I think that describes most of the companies I’ve worked for. It’s a theme in this piece from Forbes, noting that many companies use only a fraction of the data they have to make decisions. … Continue reading

Posted in Editorial | Tagged , | Leave a comment

T-SQL Tuesday #80–Chris Yates’ Birthday

It’s the 80th version of T-SQL Tuesday. You can see all the parties from the past on my page, but feel free to jump in here or elsewhere. This is a monthly event, where anyone can write on a topic. … Continue reading

Posted in Blog | Tagged , , | Leave a comment

SQL Server 2016 is Just Faster

I’ve enjoyed the series of posts from Microsoft on the ways in which SQL Server 2016 was improved and is faster. Some of these posts show improvement without any change in your code. Some showcase features that might require change, … Continue reading

Posted in Editorial | Tagged | 2 Comments

Stretch Pricing

I have to admit that I was really excited about the Stretch Database feature in SQL Server 2016. This will automatically archive older data away from your database, but let the query optimizer go get the data if needed. That’s … Continue reading

Posted in Editorial | Tagged , | 2 Comments

It’s 2016 RLS for T-SQL Tuesday #79

It’s T-SQL Tuesday time again. I missed last month, being busy with travel, though I should go ahead and write that post. Maybe that will be next week’s task. In this case, Michael J Swart is hosting this month’s blog … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

A New Sample Database

When I started working with SQL Server we had the pubs database. This was in SQL Server 2014, and I only used it because code samples from the Internet used it. It wasn’t a great database, but it was consistent … Continue reading

Posted in Editorial | Tagged | Leave a comment

Running Multiple Threads Quickly

Recently I was looking to generate a quick workload against an instance. I wanted to add to the amount of work my system was doing by executing a number of queries simultaneously. There are a variety of ways to do … Continue reading

Posted in Blog | Tagged , , | Leave a comment

More Overloads

I was attending the SQL Nexus and SQL Bits conferences recently in Europe. These were launch events for SQL Server 2016, and the keynotes given by Microsoft included the overload of yet another SQL Server term. This time ACID was … Continue reading

Posted in Editorial | Tagged

Half Baked Features

I gave a talk recently on some of the data protection features being added in SQL Server 2016, along with a few that have been available for some time. I think the talk went well, but I point out lots … Continue reading

Posted in Editorial | Tagged ,

Solving Tempdb Issues

While reading Remus Rusanu’s piece on SQL Server 2016 development, there was an item that struck me. There’s a part of the piece where he notes that an engineer at Microsoft realized that there was a tempdb issue with Azure … Continue reading

Posted in Editorial | Tagged ,