 | A community of more than 1,600,000 database professionals and growing |
| | | Remember the Simple Things This is a hardware post, and not at all database related, but it reminds me of troubleshooting problems in my career, and of a lesson that I thought I'd learned well. Apparently that isn't the case. Over the last year I've been using a tablet to record my daughter's volleyball matches. We've saved off the video between matches, often uploading it or sending it to college coaches. After the season, the tablet wasn't used much, mostly for some movies on trips, but often it sat idle. Not too long ago a software update appeared for the Android operating system and I applied it, promptly forgetting about this. I recorded a couple matches earlier this year, but was too busy to download the video. As I was getting ready for a match last week, I realized that I needed to copy some of the video off the device to free up space. I connected it with a USB cable to my PC and ... Nothing. No device appeared, and I couldn't access video. I played with the settings in Android, even tried some software from Samsung. Nothing worked. I had read that modern versions of Android included some protection from random USB connections, so I ended up prying open the rubber case, removing the small SD card, cursing a few times as I tried to find a micro adapter to read it, watching the clock the entire time. Rushing to copy video and get out the door in time to make the match is not the least stressful part of my life. The next day I ran more searches, trying to find a way to connect remotely to the tablet from a Windows device. I kept seeing references that enabling the device visibility should work and Windows should detect the file system. It didn't work, and this was frustrating. I was ready to purchase some software to allow remote connections to the device. Finally, I saw a note that some cables don't allow data transfer. Apparently a micro USB cable is not a micro USB cable. I decided to try another one I had laying around, but no change. I did notice the message that the device was charging slowly, so I wandered through my desk to find the original cable that came with the tablet. I connected it and Voila. I had a file system to which I could copy video. I felt both relieved and rather ashamed of myself. I can't remember the number of printer problems I've solved in my career by changing cables. Or the number of times a motherboard wouldn't boot, but changing a power cable fixed the issue. Consider the simple things first when troubleshooting. They won't always solve your issue, but if they do, you'll be glad you tried them first. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 4.8MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT |  | | 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 |
|  | | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control.
Try it free |
|
|
|
| | |  | Murthy TS from SQLServerCentral.com Automating population of SQL Server data into Word and PDF document templates for contracts, invoices,letters etc. creation saves thousands of hours for businesses. This article explores various approaches and offers few suggestions on how to choose the best approach for your requirements. More » |
 | Additional Articles from SimpleTalk Power BI Desktop is typically used to create reports that will eventually be published to Power BI Services where dashboards can be built. Robert Sheldon demonstrates how to publish reports from Power BI Desktop to the Power BI Service. Once published, the visualizations can be filtered, drilled into, or pinned to a dashboard. More » |
 | Additional Articles from MSSQLTips.com In my T-SQL code I always use set based operations. I have been told these types of operations are what SQL Server is designed to process and it should be quicker than serial processing. I know cursors exist but I am not sure how to use them.. More » |
 | Matthew McGiffen from SQLServerCentral Blogs In this post we’ll look at how quick and easy it is to use the XEvent Profiler to create an... More » |
| | James Serra from SQLServerCentral Blogs As I first mentioned in my blog Microsoft database migration tools, the Azure Database Migration Service (DMS) is a PaaS solution that... More » |
|
|
| | | Today's Question (by Steve Jones): The QUOTENAME() function takes a string as an input. What is the size limit for the input string? |
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: QUOTENAME(). We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): If I have a SQL Server 2017 Linux instance installed, can I use Active Directory authentication for logins?
Answer: Yes with any AD domain controller Explanation: You can authenticate on Linux with any AD domain controller. Ref: Tutorial: Use Active Directory authentication with SQL Server on Linux - 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.
More than one check constraint per column? - In the documentation for CREATE TABLE (Transact-SQL), under check constraints, I see: A column can have any number of CHECK constraints,...
BCP column limit - Hi Gurus, I am trying to load data from file to mssql table using BCP command. In file contains 264 couumns.... Algorithm to combine 2 integer into one value and then disintegrate back into two - Hi, I may not be the first one to ask this, but I'm looking to find a way to combine two... BCP issues with export data files generated with queryout won't import in tables. - I have to Export data from ServerA and generate .csv files and then move files to other department for warehousing... Max size file in BCP process - Hi Experts, We are processing huge data file's on daily process form file to SQL server using BCP command. For Example : Daily...
How to flip tables in sql server 2014 - Hello, I have a requirement wherein there are 2 tables (Staging & Target) in the same database. Everytime data is first loaded in... Query Performance Improvement - Hi All, I'm very new to PI and sorry if this is a silly question, but was wondering if I can...
??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\ - ??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\ ????????:MV156?????????????WLD336 . C O M?????????????????????????????????24????? - ????? ??? ??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\ - ??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\ ??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\ - ??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\ ??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\ - ??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\??????(??MV57)\???????\?????????WLD336,COM????????\????\????\?? ???????\
Performance concernce - Just ran through a handful of test harnesses, not impressed, vNext is more like vLast :cool:
Sorting in order of my choice - In the below code I want to sort by 'M' first and then sort by 'S' and then by other... Find and replace third occurrence of the string - I want to find the third occurrence of the 'o' and replace with 'A' create table store ( productid int, productdescription...
SSRS Report Server - Good day experts, We have a report server at my work,we want to move the current production(SQL 2014) to a new...
Not getting any emails - I don't know what's happened, but somehow I'm no longer getting any emails from SQL Server Central. Probably I've accidentally...
How To Create dynamic column in Sql - Hi, I have got the situation to add column name dynamically with the data type of int. I have tried to...
WinHttp.WinHttpRequest - Hello, I have a stored proc that calls a web service via WinHttp.WinHttpRequest.5.1. For years, I had this code working without...
Using MSXML2.ServerXMLHTTP within Stored Procedure To Grab Source of HTML Page and save to table - I'm trying to use 'MSXML2.ServerXMLHTTP' though extended store procedures to retrieve the html source of parsed asp pages to be... |
|
| This email has been sent to newsletter@newslettercollector.com. 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
