Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate SQL Monitor
The Voice of the DBA
 

Data Challenges and Travel

I made a quick trip to Pensacola recently for SQL Saturday #884. I had a great time and consider myself honored to be picked to speak, as well as lucky that I can make the trip. I didn't have a smooth trip, as I wrote on my blog, but things worked out. These were really first world problems and minor hassles for me.

When I wrote my blog, I was thinking about all the data I received, and didn't receive on the trip. Across the last few years, United (my primary airline) has enhanced their apps and services to share more data with travelers. I get text reminders two hours before flights, which is usually my drop dead time to leave the house for the airport. A good reminder for me. I get an announcement when boarding starts. I'm usually there, but if I'm late, or busy in an airport trying to find food, coffee, or a restroom, this is a great reminder.

Maybe the best part for me as a frequent traveler is the information about what's happening with the plane before I get on it. There's a "where is this plane coming from?" and a "where is this plane currently" view that I've used to make decisions on how to handle delays or other issues. While this might not matter to most people, though kids will love it, this has helped me to decide to rebook, alter plans at times, or even just keep working a bit longer during delays. Timing can be everything for frequent travelers.

Perhaps one of the amazing things with the data from airlines is baggage. While I don't know how things work, I have been amazed at times that my bags get from plane A to plane B in a short time. My frequent travels from Denver to London have had me running between planes at times. This means that baggage handlers have to know there are a few bags (I'm often not the only one) that are in a particular bin or bucket on plane A need to be separated out from other bags and routed to a plane, not the collection point. Add in the fact that many other bags might need to go to different planes in a short time, and it's actually incredible that most bags get on the plane with their owners. Or maybe that's a major source of "unexplained delays". Who knows, but when you think about the challenges, it's incredible.

Certainly the data sharing isn't perfect, and I'm sure the companies are careful about what they share. At the same time, I appreciate that other companies are doing a better job of using data and technology. While on my trip, I got a picture from Amazon of a package that was delivered to my house. I know it was my house because the package was next to a planter on my porch. Useful in case one of the kids moves it and denies doing so.

Mistakes will continue to be made by companies all over the world, and certainly we should understand that. The more data they collect, and the more they share, the more we can better understand what went wrong and fix it in the future.

Steve Jones - SSC Editor

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

Redgate SQL Provision
 
  Featured Contents

Azure Elastic jobs

Evgeny Garaev from SQLServerCentral

Learn the basics of Elastic Jobs on the Azure platform.

Data privacy next steps: Compliant Database DevOps

Additional Articles from Redgate

Over the last year we’ve seen a shift in customer concerns around personal data, as well as new legislation. Now is the time to implement a robust process to safeguard your data and your business, without hindering your DevOps journey. Read this blog post to find out the next steps for data privacy.

From the SQL Server Central Blogs - SELECT Expression Execution Order

Bert Wagner from Bert Wagner

Watch this week’s episode on YouTube! Today I want to share with you an interesting observation I made about SELECT expression execution order. I was working on writing a...

From the SQL Server Central Blogs - sp_execute_external_script and SQL Injection

Grant Fritchey from The Scary DBA

In order to take advantage of R and Python (and Java in SQL Server 2019) directly from your SQL Server scripts, you’ll be using the function sp_execute_external_script. When you...

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Multi column histograms

In SQL Server 2017, if I create an index with 4 columns, the data from how many columns is used in the statistics histogram?

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

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Container Ports

When I run SQL Server in a container, I may have a parameter that looks like this:

-p 51433:41433

What port would I my SQL Server instance inside the container need to be listening on for a connection to work?

Answer: 41433

Explanation: The -p parameter takes the host:container mapping ordering. In this case, the host connection would specify 51433, but the container SQL Server instance would need to be listening on 41433. Ref: Configure SQL Server container images on Docker - https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-docker?view=sql-server-2017

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 2017 - Administration
which linux - I would like to try to install SQL server and PostgreSQl on a linux system. It is a test environment This is just for explore and learn linux and how to work with database. What linux system do you recommend, Redhat or ubuntu?   Thanks
SQL Server Training - Can anyone recommend the best place to get the SQL training when the company is willing to pay for it?
Store Procedure... - Hi Is there anyone who can help me explaining, in real job field, in what kind of scenario I would need to use output parameters in my store procedures. And also I would like to know how data gets into tables, do we manually entered it or its gets inserted via back end file? Thank […]
Is DBA responsible for ETL operations and cube creation in DW design project? - If a company wants to build a DW from sketch, is DBA responsible for schema design, ETL extraction and transformation process, loading physical data from different sources into a DW database? Or DBA is responsible only for physical design, and tools like SSIS or SSAS should be used by developers.   Thanks
SQL Server 2016 - Development and T-SQL
Change data capture - is it possible Updates getting applied out of sequence - I am using the CDC objects in SSIS to do replication between two servers I have a large table that does not have a Primary key so must be set to all. Occasionally when I do validation between the two, the record count is correct but values don't add up. I am doing a simple […]
Changing @ExecutionTime parameter value in SSRS subscription - Hi Everyone,   Can you please guide me how to change @ExecutionTime parameter value in SSRS standard subscription and version is 2012? Thanks Kanagarajan S
How to disable Upload options to end user in SQL SERVER REPORT Services 2016 v? - Hi Every one,   Could you please help me to achieve this requirement? I am having a requirement like need to disable the upload RDL or IMAGE option to end user also, restrict to view hidden data sources list in reporting manager.   Thanks Kanagarajan s.            
How to do Count of values on mutiple columns - I have the folllowing data in a table If OBJECT_ID(N'tempdb..#OutputTable', N'U') IS NOT NULL DROP TABLE #OutputTable CREATE TABLE [#OutputTable]( [MainHoldingID] [int] NULL, [OfferingElementID] [int] NULL ) ON [PRIMARY] GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT [#OutputTable] ([MainHoldingID], [OfferingElementID]) VALUES (1133535784, 58413) GO INSERT […]
Administration - SQL Server 2014
error upgrade ssis - Hello everyone I proceed to update my ssis package from SQL server 2008R2 to 2016 during the upgrade wizard phase I got this message   thank you for your help    
SQL Server 2012 - T-SQL
In a t-sql 2012, I can trying to make a case statement work in an update statem - In a t-sql 2012, I can trying to make a case statement work in an update statement and I am getting the error ' Msg 207, Level 16, State 1, Line 5 Invalid column name 'TOT_ABSENCES'. from the following sql: UPDATE Milestone set TOT_ABSENCES = case when (details.TOT_ABSENCES is not null) or isnumeric(details.TOT_ABSENCES) = 0 […]
SQL Server 2008 - General
identify stored proc calls with missing input parameters - I'm checking to see if anyone has already written a stored procedure that can be run to identify any and all stored procedure calls from within a trigger or other stored procedure that are missing some of their input parameters. For example, if I have a procedure named SP_MyProc and three input parameters whenever I […]
Free Webinar: SQL Server 2008 has gone out of extended support - Hi All I thought I would post, I'm not sure its the correct place, but thought I'd let you know that I'm putting on a free webinar on 31st July - midday UK time. With SQL Server 2008 and SQL Server 2008 R2 going out of extended support with Microsoft last week, the webinar will […]
Error: Database is already open and can only have one user at a time - Any idea how to resolve this error? seemingly a nightly process loads data into my joebloggs_DB database, its then copied from jobbloggs_DB database to LIVE DB. Issue is sometimes the process fails with the following error: Error: Database 'JoeBloggs' is already open and can only have one user at a time. It looks like the […]
Dynamic Pivot Query with three fields - Hi,   I am creating a dynamic pivot query to produce a simple monthly table showing clients on the left column, calendar dates across the top and simple text in the middle. Table are CREATE TABLE [dbo].[TblClientActivity]( [ID] [int] IDENTITY(1,1) NOT NULL, [ClientID] [int] NULL, [LocationID] [int] NULL, [ADate] [date] NULL, [Outcome] [nvarchar](10) NULL) Data […]
Integration Services
Upgrade file SSIS - Hello everyone I have two dtx file SSIS develloper EN SSDT 2008 AND I'm going to migrate it in SQL2014 If I import these files through SSDT 2013 the files are well imported then if I click on the button upgrade all package i have this message At least one package has to be selected […]
 

 

RSS FeedTwitter

This email has been sent to {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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -