A look back from the future. – TSQL Tuesday #100

3

March 13, 2018 by Kenneth Fisher

T-SQL Tuesday The date is July 14th, 2026 and it’s TSQL Tuesday #200. We are still using SQL Server, and in fact SQL v2026.July.10 has just been released and v2026.July.25 announced.

Many things haven’t changed much in the last 8 years. For example:

  • Profiler is still deprecated.
  • msdb and SQL Agent haven’t been upgraded.
  • Always On has gone between AlwaysOn and Always On 47 times and no one is really sure which is currently correct. (And most people still don’t know what an Availability Group is.)
  • Service Broker is still rather complicated and difficult to impliment.
  • Many people still think NOLOCK means that SQL will not be taking any locks.
  • Three different people have submitted sessions to PASS Summit titled “The death of the DBA”.

 

On the other hand, there have been many improvements.

  • Security analytics has matured and companies can now see in simple reports what they need to do to secure their data. They still aren’t doing any of it, however.
  • You can now run Powershell and Python scripts directly from SSMS query windows by turning on PoSH mode and Python mode.
  • A number of Extended Event & SQL Audit templates have been created to cover various legal requirements (HIPAA for example)
  • BizOps is the latest in a long string of methodologies meant to get people to actually talk to each other.
  • Moving data between the cloud and on-premises is completely seamless and automated (mostly). It still takes time to transfer the data, however.
  • Tech Outbound has announced its plans to do a SQL Server training trip to Mars.

3 thoughts on “A look back from the future. – TSQL Tuesday #100

  1. notarian says:

    Grant Fritchey’s head in a jar is still the President of PASS, having changed the by-laws to remove term limits, and having a body required for eligibility.

  2. […] Kenneth Fisher’s 2026 involves SQL Server releases once every two weeks. This is necessary, apparently, to keep up with the speed of business. Gone are DevOps—replaced, per Kenneth, by BizOps! What about our beloved Profiler? In 2026 it’s still right there when you need it. […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,180 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: