| A community of more than 1,600,000 database professionals and growing |
| | Appreciating New Perspectives A few weeks ago I was in India for the Data Platform Summit 2017. It was an honor to be accepted to speak, and I had a great time. The conference went well, during a busy week for me with a pre-con and five other talks to give. I had some very interesting conversations and discussions with data professionals in India, all of them facing the same challenges that most developers and DBAs face in the US. What was fascinating for me was the culture of India. This was my first time traveling there, and so my family decided to come with me for a little vacation. We all went 9 days early and lived in Bangalore in a flat we'd rented. For a number of days, I experienced life as a local, walking around, eating at local places, being vegitarian, and experiencing life in a completely new way. Unlike other trips where I've lived in hotels or taken formal tours, here we wandered around and just experienced the culture. And we loved it. So many things were fascinating, and the city of Bangalore is unlike any I've ever lived in. It was definitely a culture shock, and many things were strange (as in foreign) to me, but I went with the flow and didn't complain. I tried not to judge, and accept that life on the other side of the world (literally as Bangalore of 12.5 hours ahead of Denver) is different. That new perspective was eye opening to me. It made me stop and re-examine life in the US, my views, expectations, prejudices, and more of the US culture. Neither one is better, and both have good and bad. The thing that I took from the experience was that I had the chance understand and appreciate a completely different world. While not as dramatic as the cultural differences between the US and India, I have found that often the perspective I might have at work can be completely different from someone in another group. We both might be right, or even examining an issue correctly, from our own perspective, never considering there is a completely different frame of reference. I also see this often from developers who expect clients to use software in the same way, forgetting that there are other perspectives. This trip was amazing, and it really changed my life. I am thankful for the opportunity and honored that Redgate and the Data Platform Geeks allowed me to go. As moved forward, I hope to keep a more open mind, and learn to welcome the differences in how each of us view the world as well as how others may approach their jobs. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | SQL Clone: Now supporting databases up to 64TB Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free |
| | The industry standard for comparing and deploying SQL Server database schemas Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial |
|
|
|
| | | Daniel Klionsky from SQLServerCentral.com Learn how you can execute multiple scripts in a restrictive database environment that doesn't allow any third-party tools. More » |
| Additional Articles from MSSQLTips.com Have you ever gotten connectivity errors from SQL Server? Jugal Shah explains the common causes for these errors, and advises on the steps you can take to resolve them. More » |
| To celebrate the launch of the new Redgate Hub, Data Platform MVP Steve Jones is hosting an educational livestream event alongside the team at Redgate HQ. They’ll introduce you to everything the Redgate Hub has to offer by highlighting some recent technical articles and how-to guides with in-depth live presentations. Register now. More » |
| Igor Micev from SQLServerCentral Blogs The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be... More » |
| David Postlethwaite from SQLServerCentral Blogs David has recorded and published a video of his presentation on SQL Server Graph Database. In his video which you... More » |
|
|
| | Today's Question (by Steve Jones): When a query is processed logically, which clause is handled first? |
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. |
|
|
| |
ADVERTISEMENT | 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 Steve Jones): I have this R code, setting an American football position list: football <- c("CB", "OLB", "LT", "WR", "SS", "DE", "LG", "HB", "CB", "MLB", "C", "QB", "FS", "DT", "RG", "FB" ,"CB", "SLB", "RT", " ", "CB", "DE", "TE", "WR") dim(football) <- c(4, 6) When I print this, I get these results: [,1] [,2] [,3] [,4] [,5] [,6] [1,] "CB" "SS" "CB" "FS" "CB" "CB" [2,] "OLB" "DE" "MLB" "DT" "SLB" "DE" [3,] "LT" "LG" "C" "RG" "RT" "TE" [4,] "WR" "HB" "QB" "FB" " " "WR" If I just want the offensive line (the LT, LG, C, RG, RT) row, what do I type? Answer: football[3,] Explanation: If I want to just show a row, I could use the variable with the [] syntax and use the row number and a comma. A column would be a comma and the column. In this case, football[3,] gets the row. Ref: Matrix tutorial - 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. Backward Compatibility of SQL Server Management Studio 17.2 - SQL Server Management Studio 17.2 cannot connect to SQL Server 2016 Integration Services. SQL Server Management Studio 16.5.3 connects fine... Strange transaction log activity - I'm suddenly seeing unusually large transaction log backups for a small database, and the application team swears that nothing has... Performance tuning, alternative to cursors for my situation? - Hi everyone, I'm trying to come up with something that is better performance-wise with a stored procedure I've built. I'm not... Solved - Can I join these tables with a query to obtain the final result? - Hi all, I'm wrapping my head around a problem that I'm not being able to solve. Perhaps one of you might... Removing Repeating Data From a Fuzzy Match Result - I'm in the process of cleaning up a lookup table we have that is used to match on a name... Finding Consecutive Values For a Record - I have a table that shows if a record has a value for each month. A zero is given for... Script to later multiple sql authenticated logins on a SQL instance - Hi Does anyone have any scripts or tips for altering multiple sql authenticated logins on a sql instance. T-SQL or... Replication (possible) issues - Hi all We have a 3rd-party software vendor who puts data into some SQL tables. We want to replicate the databases across... Determining causes for performance difference in queries - Hi, We have an integration query running at 5am - simple view on 3 tables (2 tables have 4-6m rows) - on some... Time increments - Hi, I want to have a calculated field "TimeIncrements' that will increment 20 minutes starting at 8:00 and ending at 5:00... PLE - Hi All, Appreciate if anybody can help understand why the physical memory is divided by 4 to determine ideal Page Life... Can I restore a single file .mdf to multiple files spread across disks - I am trying to create a 2nd copy of my database which is 200GB so that I can do Log... Azure Data Warehouse String Splitters? - Do these exist? Looks like Azure Data Warehouse has some pretty big limitations with not being able to use SELECTS.... Moving SQL on-premises DB to Azure SQL database. - Hi All, I have a questions regarding Azure. On my regular SQL Server user DB, we have a function which is... Script out permissions - Azure SQL database - Hi Folks, Any one has a script to script out user permissions from Azure SQL database? I was not able to... Dynamically read images from share path and display in report - Hi Will it be possible to display the images in SSRS from FTP path ? Two table invoice & image_info -- table invoice Invoice... Date Question - In the following code I was expecting the Minutes from the base date but it does from midnight - is it... How to find SSIS MetaData information ? - Hi Team I need to fetch SSIS MetaData information from sql server database . Please provide query which will give all... List all logins, databases, role mapping - Hi there, I'm looking for a query or script that can generate a list of all SQL Server login's on an... Cleaning up Replication Monitor - I have sucessfully removed an old publication and it subscriptions, but I am still seeing references to it in the... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|