Thursday, December 29, 2016
The 15 most popular posts in 2016
Another year is almost over. As the last post of this year I decided to share with you the 15 most popular posts in 2016. I just used Google Analytics to grab this info, I excluded the home page from the top 15. Four of these posts were written in 2006 and one was written in 2005
Here they are in order of popularity
1 Some cool SQL Server announcements SQL Graph, Adaptive Query Plan, CTP1 of SQL vNext, SQL Injection detection
This is my recap of the chalkboard session with the SQL Server team at the SQL Server PASS summit in Seattle.
2 Five Ways To Return Values From Stored Procedures
A very old post that shows you five ways to return values from a stored proc
3 SQL Server 2016 SP1 released, SQL Server vNext available for download
Posted this while the connect event was going on
4 Installing SQL Server on Linux, connecting and running queries from Linux
A quick walk through on how to install SQL Server on Ubuntu, I also included a video in the post
5 Are your foreign keys indexed? If not, you might have problems
A post showing you that indexing foreign keys might be beneficial if you do deletes
6 Convert Millisecond To "hh:mm:ss" Format
A very old post showing you how to convert from milliseconds to "hh:mm:ss" format
7 What's new in SQL Server 2016: CREATE OR ALTER
A post showing how the new CREATE OR ALTER syntax works
8 Why you need additional privileges to truncate tables compared to delete statements
The reason why you need these privileges is shown
9 What's new in SQL Server 2016: Truncate partitions
This post shows how truncate partitions works
10 What we learned from the reddit SQL Server AMA thread on /r/sqlserver
A recap of the AMA SQL Server thread on reddit
11 Playing around with the new stuff in SQL Server vNext and SQL Server 2016 SP1
Just a post showing some of the new stuff released in SP 1 of SQL Server 2016 and vNext
12 ISO-11179 Naming Conventions
A very old post linking to the ISO-11179 Naming Conventions document
13 Query Analyzer Trick
A very old post explaining how you can drag the columns into the query window from object explorer. I think by now everyone knows this one right?
14 What was the first computer you bought, what were some of your favorite games?
Mine was the Commodore 128, what about you?
15 Chaos Isolation Level In SQL Server
This is linked from dba.stackexchange.com, it is kind of interesting because it was a silly post I made
That is all... see you in 2017...