SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

A New New World

Star Trek Discovery premiered this past week as a new entry in the Star Trek series that has been a part of my life since I was a kid. I was enamored with the idea of exploring the stars, meeting new civilizations while maintaining a strong ethical stance about not interfering with their development. The idea of beaming up to a ship instead of dealing with long shuttle flights seemed like something I'd like, especially as I sat on a long bus ride to and from school for most of my youth.

Since then I continue to dream about Star Trek technologies, which are still likely as far in the future as I thought as a kid. These days I wouldn't want to go to space without artificial gravity, and I feel that the HoloLens, which interesting, is still miles away from any sort of Holodeck. Even the advances in speech technology, across many devices and slowly becoming more and more ubiquitous, don't seem to be anywhere close to the fictional computers on board the starship Enterprise. I still can't see how a general purpose speech device in a crowded area would work. Unless we all have our own moment to speak our lines.

There are so many ideas about the future of technology and where we might go. I know that in some ways my imagination of the Jetsons, Dick Tracy, and Star Wars aren't anything like what we have today, well, maybe Dick Tracy has come true. We are barely in space, we haven't gotten anyone to another planet, much less explored other galaxies. We have computers that are way more reliable, but software that is maybe not quite as reliable, and certainly VR far behind what many science fiction writers imagined. Communications occur at a rate I've rarely seen in fiction, though with a darker overtone than I ever expected or like. 

There are still dreams out there, and plenty of thoughts and views of the future. Some sad ones, some scary ones, maybe some exciting ones. Most views are so far in the future, with plots that are too outlandish, but there are slices and glimpses of technology that could come true. Maybe instead of quick subspace orbital elevators we might get lots of hyperloop transport. Perhaps we won't have warp drive, but is it possible to get people onto Red Mars?

I don't have any great predictions about the future. I tend to see more the downsides and problems that technology can bring us, especially with more data being captured. However, maybe you have some ideas. Can you come up with something that you think our children might experience?

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.0MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

SQL Monitor

Don’t just fix SQL Server problems, prevent them from happening

SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial

SQL Prompt

Write, format, and refactor SQL effortlessly with SQL Prompt

Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial

Featured Contents


3 Things I Wish I Knew When I Started Using Entity Framework

Bert Wagner from SQLServerCentral.com

Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise. More »


Implementing SQL Server Failover Clustering in Azure

Additional Articles from Database Journal

Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-availability and disaster recovery capabilities in a manner that they can control. Trying to implement this approach in the cloud by following the procedures applicable in on-premises datacenters frequently presents challenges. This article focuses on these differences in the context of deployment of SQL Server Failover Clustering in Azure. More »


A whole new way to see differences in SQL Compare

In the latest release of SQL Compare, Redgate have added a brand new way to examine the differences between two objects in your database. Jamie Wallis provides the details. More »


From the SQLServerCentral Blogs - Test Database Compatability with dbatools

Steve Jones from SQLServerCentral Blogs

I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and... More »


From the SQLServerCentral Blogs - Adding a Replica back into a SQL Server Availability Group

Klaus Aschenbrenner from SQLServerCentral Blogs

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the... More »

Question of the Day

Today's Question (by Steve Jones):

When logically processing a query, which of these filtering operations takes place last?

Think you know the answer? Click here, and find out if you are right.

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: T-SQL.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.


Exam Ref 70-761 Querying Data with Transact-SQL

Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

Which two permissions are required by clients that want to select data from an Always Encrypted column? Assume the user has SELECT permission already on the table/column.




The two permissions needed for querying are the VIEW ANY COLUMN XX DEFINITION permissions for the Column Encryption Key (CEK) and Column Master Key (CMK). 

Ref: Always Encrypted - click here

» Discuss this question and answer on the forums

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2016 : SQL Server 2016 - Administration

SQL Server 2017 - Have SQL server 2017 officially released or not? From Microsoft site, I can see there is SQL server 2017, but not...

Dynamically create table with full structure - Hello All, I have a large table "LARGETable" and till now my developers created a job that run every 2 minutes...

Can't Shrink TEMPDB - Hi All, I am getting an odd error when trying to shrink tempdb a little bit DBCC SHRINKFILE: Page 7:2275824 could not...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

SSIS : Group by in Aggregated task - Dear all, I have created an aggregated task which is producing the below data: CIA_

An exercise in query optimisation..... - Hi all, I am starting to work in an environment where database DevOps plays a very important role and I am...

Get the year and Qtr - Ia am trying to get the year and Qtr from my date column which has values like- YYYY-MM (2017-02). I...

Query running slow across linked server - Hi all Firstly, apologies for the lengthy post, but I'm trying to get everything in I thought would be useful. I've got...

SQL Server 2014 : Development - SQL Server 2014

Hash index on memory-optimized table - I have a memory optimized table where I currently have a hash index on two columns.  Most of my queries...

Automate Table Field Names In Query - Not sure if this is possible.  I have one table where the field names may bemodified or new fields added...

Code-first vs database-first, any new developments? - I'm discussing this topic with a developer, and I'm also performing due diligence and looking for other opinions on the...

SQL Server 2012 : SQL 2012 - General

Adding second data file to quickly growing msdb - Our SQL Server sends out a lot of emails. The msdb.data file grew up to 46 GB and there is...

SQL Server 2012 : SQL Server 2012 - T-SQL

Database trigger to send email after column in table is updated. - Hello all, Thank you for any help given in advance, it is much appreciated. Scenario - What I require is a database trigger...

SQL Server 2008 : SQL Server 2008 - General

Column Length - Dear All, Question regarding the length of a column . As its understandable it has to be in accordance with the data...

Data Warehousing : Integration Services

Flat File Connection Manager - Hi, I have a file directory path were I get a csv file per day, with current date. I have set...

SSIS package shows successful but not working - I have an SSIS package that was executing successfully for some time but last week started erroring.  The error on...

Database Design : Design Ideas and Questions

Naming Conventions - Table and Column Names - I'm pretty old school and I've always created tables and columns following a specified naming conventions that doesn't include spaces...

SQL Server 2005 : Administering

Which is better and Why.? - Dear All, I have a question. Long back when I started learning SQL Server-2000, somewhere I had read that "SQL SERVER lies...

SQL Server 2005 : SQL Server 2005 Security

Create and Alter Table Permission only for specific schema - Hello experts, I need advice on how to grant create table, alter table and create procedure permissions on a specific schema...

SQL Server 7,2000 : Administration

Clean database - I moved data from one server to another server, this is the same db and they look identical,but db is...

This email has been sent to {user_email}. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com