Fantasy SQL Server

This past week was the 118th T-SQL Tuesday (hosted by Kevin Chant) and it was a great one. Lots of people participated, with some really interesting entries. Kevin asked people to post their fantast T-SQL (or SQL Server) feature that they wish Microsoft would build. From better defaults and hints to a performance rating to CCI improvements to better partitioning, there are lots of creative solutions. Look for the recap this coming week.

I didn't write mine, mostly because I was out of the country and busy with SQL in the City Streamed and then some customer visits, as well as a mini-vacation in London with my wife. As a result, this slipped my mind, but my feature would be two phase authentication for a batch. I'd like a user to be able to submit a batch, have that held in a queue inside SQL Server until another user approved this feature somehow. The implementation doesn't matter, but requiring two admins (or users) to run something would be fantastic for limiting rogue admins.

What's more, I'd use it to schedule something for the future that needed to be done, but I wasn't sure when, like cleanup of some deployment. I'd write the trigger delete or other cleanup, leave it in queue and then have a job that reminds me of work that's out there. When I'm ready, another account approves something.

There were some good features submitted. I like Brent Ozar's, restoring a single table, which is based on this suggestion with lots of votes. Not likely to happen because the backup process doesn't know what's on the pages, it just restores them. However, I'd think this could be added somehow with a scan of system tables inside the backup. Another simple one is better logging of job results. We've needed that for a long time, and that seems doable.

If you didn't participate, you can still write something, and even submit a suggestion to Microsoft. Doing a T-SQL Tuesday post is a great way to think and exercise your mind a bit. You might even have a great idea that someone notices and Microsoft picks up. You can still write your post and leave a comment on the invitation post.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

Redgate invite you to look around their newly refurbished University. If you are new to their tools there are simple, easy to follow courses to get you up and running, and if you are a long-time customer you can check out the recently added courses which take you through some more technical tips, tricks and troubleshooting.

Whether you are a long time Redgate customer or have recently made a purchase you can find helpful and easy to follow video courses on Redgate University. With the brand-new look and the recently added courses you will soon be getting the most from your Redgate tools.

The Development component of SQL Change Automation now integrates directly into SQL Server Management Studio as well as Visual Studio. This allows teams to collaborate seamlessly during development, regardless of their preferred IDE. Other new features include new data compare options for PowerShell and static code analysis.

We want to hear from you on the approaches you take and the challenges you face when delivering test data to development and testing environments. Take part now for an advance copy of the research and a chance to win a $250 Amazon voucher.

In this blog post Rebecca Woof walks us through the new features of SQL Monitor 9.1. With PowerShell API alerting and a new permissions table the latest release addresses challenges that come with a growing SQL Server Estate.

You probably have a favored Redgate tool but if you’ve been using it for a while, you may not be making the most of the features. Learn how to fully utilize your products starting with our Redgate University ‘Getting Started’ courses, then move on to the newly added ‘Advance your skills’ section.

This is a keynote from the O’Reilly Artificial I...

This is a keynote from the O’Reilly Artificial I...

This is a keynote highlight from the O’Reilly Ar...

This is a keynote highlight from the O’Reilly Ar...

This is a keynote highlight from the O’Reilly Ar...

Stefan Franczuk explains the different categories ...

Artificial intelligence (AI) will have a huge impa...

The biggest issue facing machine learning (ML) isn...

I recently found this DMV and couldn’t wait to s...

This post is really a reminder to me, since I don?...

You should never stop learning, especially within ...

This months marks one year of working for myself, ...

My new course “Managing Kubernetes Controllers ...

Recently I have become more vocal on Twitter and o...

Using a Shared Access Signature (SAS) is usually t...

As businesses have been moving along the path towa...

Join Hamish Watson and Rob Sewell to learn practical solutions on how to bring DevOps to your database. This will be a fun-filled fast paced hour and you will learn some new skills which will bring immediate benefit to your organization.

Join Jez Humble, a founding member of DORA well known for his groundbreaking research on IT performance and Microsoft MVP Steve Jones to learn the latest insights from the 2019 DORA Accelerate State of DevOps Report – and what they mean for your organization and career.

It’s two weeks to our next SQL in the City Summi...

I’m In Your Area If you’re in the New York are...

In its 19th Annual Global CEO Survey, PwC found th...

Pre-conference Workshop at SQLSaturday Denver I?...

You may notice our file sizes are pretty and human...

Employer analytics firm can keep scraping public L...

Click to learn more about author Harikrishna Kunda...

I've been at the EARL Conference in London this we...

Robert Sheldon continues his DevOps series with a ...

Every company is a software company – Satya Nade...

Given the wide range of data types, query models, ...

SQL Server Integration Services is equipped with t...

In the world of cloud database services, few things are more important to customers than having uninterrupted access to their data. In industries like online gaming and financial services that experience high transaction rates, even the smallest interruptions can potentially impact the end-user’s experience. Azure SQL Database is evergreen, meaning that it always has the latest version of the SQL engine, but maintaining this evergreen state requires periodic updates to the service that can take the database offline for a second. For this reason, our engineering team is continuously working on innovative technology improvements that reduce workload interruption.

eWEEK DATA POINTS RESOURCE PAGE: Disaster strikes:...

Patriot’s Viper Gaming division this week offici...

MSI entered the display market just a couple of ye...

(Glenn’s Tech Insights… used to be part of our...

Lenovo promised 18 hours of battery life, and it d...

Corsair on Thursday released its fastest memory ki...

As operators of cloud datacenters need more storag...

The extra 25-50MHz boost speed probably means less...

Microsoft's newest Windows 10 20H1 feature update ...

I’ve always felt responsible for making such a b...

The Query Store feature previewed in Azure SQL Dat...

First Time, Long Time I’ve written about all of ...

We hear a lot about all the data that Query Store ...

Today’s PolyBase post is all about what happens ...

In this article I am going to share with you a con...

You might have wondered that there is no DAX Quart...

Adam breaks down v-core pooling with Power BI Prem...

Patrick shows you how you can clear the Power BI D...

Originally posted on: http://blogs.vroegop.org/dar...

Originally posted on: http://blogs.vroegop.org/dar...

If you have been watching Power BI news recently, ...

Now that we can apply custom format strings to fie...

Patrick looks at native query and why you should b...

Security in Snowflake is quite different to what's...

Phil Factor shows how to integrate use of SQL Chan...

Earlier Red Gate launched the industry’s first-e...

This post will explain how to change the connectio...

In this article, we’ll show how you can still us...

Are you interested in guest posting? Publish at Da...

This post is a response to this month’s T-SQL Tu...

This post is a response to this month’s T-SQL T...

For this month’s T-SQL Tuesday, Kevin Chant aske...

Happy Little Operators This month’s T-SQL Tuesda...

T-SQL Tuesday is a monthly blog party for the SQL ...

This month the T-SQL Tuesday is hosted by Kevin Ch...

Words: 865 Time to read: ~ 5 minutes T-SQL Tuesday...

This post is a response to this month’s T-SQL Tu...

This month for T-SQL Tuesday Kevin Chant asks us w...

This post is a response to this month’s T-SQL Tu...

You can use SQL Audit to record changes to securit...

This seems to be an identity theft first: Criminal...

The Carnegie Endowment for International Peace and...

Toby Mao, Sri Sri Perangur, Colin McFarland Anothe...

Itzik Ben-Gan adds another post to his series on T...

This article describes how to compute previous yea...

Question: How to Use Multiple Hints Together for a...

While it might be obvious that it's important to f...

In the previous post on this we saw what is a basi...

During the recent Comprehensive Database Performan...

Every now and again, I need to store IP address va...

With SQL Server 2019 on the way, it’s time to be...

Musk: three-motor powertrain will come to Model S,...

The year is 1999, somewhere in Cambridge, UK. Kath...

We are all techies and we love to use a dark theme...

When the queries end, we know how long the query r...

It is widely known that I am a horrible speller an...

Get a basic understanding of Kubernetes and then g...