SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Final Thoughts

I am a fan of Walt Mossberg. I have read his work and seen him interview many famous people in technology across the years. He has been quite an influential reviewer and commenter. If you haven't ever read anything from him, I might recommend his view on Internet regulation or his thoughts on the Steve Jobs biopic , or even check out his gadget museum. You might even take a few minutes and read about The Taco Bell interview. It's a pretty neat story.

Mr. Mossberg recently wrote his last column. He's retiring this year, and penned a look at some of the technology he's experienced in his lifetime. Reading over the piece brought back some nostalgic moments for me as I think about how the world has changed. He also notes that early in his career he wrote this sentence: "Personal computers are just too hard to use, and it isn’t your fault ".  Now he says "Personal technology is usually pretty easy to use, and, if it’s not, it’s not your fault."

I agree with that, and one of the complaints I have with our industry. We haven't done a great job of actually considering users and building software that's not only intuitive and easy to use, but also gets easier over time. While I learned to appreciate the adaptation of some Office software that keeps the often used menu items displayed and remembers previous options I've used for features, I find this is the exception, not the rule. Our software is often in the face of the user, and I constantly bemoan the state of poorly written applications.

As we've moved to larger displays, and smaller displays, using touch, speech, and other methods of interacting with computing devices, building newer devices that look nothing like the computer of the past or even the computers of recent years gone by, we haven't necessarily made the computer fade into the background. The smartphone (and related car displays, tablets, etc.) have perhaps done one of the best jobs of integrating into our analog world, but the interfaces, displays, and certainly rendering of content overall has a long way to go. Plenty of that is our fault, we, the people who build applications.

I wonder if we'll reach Mr. Mossberg's vision of having most of our computing infrastructure fading into the background. Certainly reducing the need for cords and remembering to charge things will help. I look forward to the day when I have multiple pads built into my desk, my kitchen, my car, and more to just charge my devices when I set them down, so I don't need to think about power. I want connectivity to be just available, and I certainly want to be able to enlarge text easily, without zooming in and scrolling side to side as my eyes age.

The world may get better applications and infrastructure, and hopefully much better security. I certainly think it's possible, though not likely to be ubiquitous among all parts of the Internet. I doubt that for most of us choosing to work with technology as a career that we'll see computing fade away. We're too involved in the details, and hopefully excited by systems, to abstract ourselves too far away.

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.6MB) 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 Source Control

How to track every change to your SQL Server database

See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more

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

Featured Contents


Challenge Your Code Design

Gary Strange from SQLServerCentral.com

How to structure your T-SQL objects and incorporate design principles. More »


What Mail Items Have Been Sent With Database Mail

Additional Articles from Database Journal

Have you ever wondered how much database mail you have sent in the past day or week? What about those database mail items that were not successfully sent. In this tip, Greg Larsen shows you how to review the database mail items that have been processed by SQL Server. More »


From the SQLServerCentral Blogs - Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI

Dear All, Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses... More »


From the SQLServerCentral Blogs - Create an empty table from a SELECT statement but without the IDENTITY.

Kenneth Fisher from SQLServerCentral Blogs

A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like... More »

Question of the Day

Today's Question (by Alan Burstein):

How many times will the following T-SQL query print the text: hi ?

      @x INT,
      @y INT = NULL;
  IF @x = @y
      PRINT 'hi';
  IF @x = NULL
     OR @y = NULL
      PRINT 'hi';
      PRINT 'hi';
      PRINT 'hi';

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 2 points in this category: NULL.

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


T-SQL Querying (Developer Reference)

Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Henrico Bekker):

When querying a CostmosDB through the DocumentDB API, to return only properties where the property exists and indicating if the property has been assigned a value, which syntax must preceed the property test/check in the WHERE clause?

Answer: select property from table WHERE IS_DEFINED(property)


The correct syntax to evaluate non-empty results must be checked with the function IS_DEFINED. IS_DEFINED can be used to return a boolean value as result for a specific test value eg, TRUE or FALSE.

Ref: IS_DEFINED - https://docs.microsoft.com/en-us/azure/cosmos-db/documentdb-sql-query-reference#bk_is_defined

» 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

msdb data file shrinkfile - Large Database - Hi , The msdb data file on a prod db server  is 6 GB, Though I truncated the large tables  when...

Can you encrypt a replicated database if the source DB is not encrypted - Starting a project that requires data in the cloud and the boss wants the replicated DB to be encrypted but...

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

SSIS Packages: SQL 2012 to SQL 2016 - We are testing our SQL 2012 applications against SQL 2016 to determine what (if any) changes are needed. Things have...

difficult (for me) query to count available items - I have a difficult sql calculation to make, and I dont't find the answer. Can someone help me? I have a...

SQL Server 2014 : Administration - SQL Server 2014

Server Side SSL SQL Network Encryption - selfsign cert - why is it working ? - Hi all, In BO, it is emphasize that using self-sign cert promotes MITM attacks and we should use CA/Internal CA signed...

SQL Server 2012 : SQL 2012 - General

SQL Server 2012 Web Edition - SSIS services installation - Dear all, I am trying to install SSIS service in a computer that has a SQL Server 2012 web edition. To...

Hardening windows AD account running sqlserver service and sql agent / and or changing the password - Hi  I am looking into changing the AD account passwords running SQL services for all SQL server installations in our sqlserver...

To automatically change the value of a column if a particular date time is reached - Hi, I am using SQL Server 2012 Express Edition. I need to automatically change the value of status field to "2"  if...

SQL Server 2012 : SQL Server 2012 - T-SQL

Help with query to calculate inventory ageing - FIFO - I'm trying to write a query to calculate my inventory ageing but am struggling to get it to work. Appreciate any...

SQL Server 2008 : T-SQL (SS2K8)

EXCEPT in a trigger - Hi I have an Update trigger using binary_checksum to determine differences in many fields.  It's a SQL 2005 DB, which I don't...

Reporting Services : SSRS 2016

MDS and Data Quality Service - Hi I am in the process of configuring BI stack include following components on Primary site. layer 1: Web application front...

Data Warehousing : Analysis Services

A duplicate attribute key has been found - I am trying to process Customer dimension form AdventureWorksDW2012 database and getting following error. Errors in the OLAP storage engine: A...

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