SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

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.

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Comments

Leave a comment on the original post [sqlstudies.com, opens in a new window]

Loading comments...