 | A community of more than 1,600,000 database professionals and growing |
| | | Guilty of Over-Customising Today we have a guest editorial as Steve is out of the office. I recently met an old colleague with whom I used to work 12 years back in a big FMCG group based in Dubai. He is now the IT Manager of the group and whilst chatting, humbly reminded me of a project, where I had re-designed some of the Application Modules to make the group’s tailor-made software package (originally designed for wholesale businesses) able to cope with retail business requirements of one business unit. It was one of those challenging projects which I am really proud of. However, his take on that was different to mine. He mentioned that most of the changes that I had suggested and implemented (approved by IT Manager then) were over-customised for that one business unit; and that those changes were still causing the company some overhead, especially when it comes to global releases for all business units. In a nutshell, our team then was accused of over-customising the software for just one business unit, which we shouldn’t have done. There is a long history to it, and though I have my own arguments to support what we did then, I do accept the charge of overheads caused by our changes. Now let’s assume we had not implemented the software changes then. The group's software would have been installed in the retail unit, with many workarounds for daily standard processes. The users would have been frustrated; and would have started hating the system. But the IT DevOps of the group would have been happy, as it would have not caused them any overhead. So in either case, someone would have been unhappy. Back then, my colleagues and I chose to make those people happy who would use the system day in, day out. We may have missed the bigger picture; but considering how much was missing in our system then for retail operations, we did as much as we could to fill in the gap. After three months of hard work, we delivered software which was happily accepted by the users. All this for just one belief - that systems should be made to help the people; and not the other way round. What would you have done in a similar situation? Do you think we could have made everyone happy using a different approach? On a general note, have you ever been in a situation, where your suggestions to help users have been challenged or discarded for similar reasons? Or do you work with users, who are too demanding? Do you struggle in managing expectations? Nitin Bhojwani from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | 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 |
|  | | Library of articles for DevOps, DLM, & Continuous Delivery Discover best practices and processes for more agile methods of database delivery. Find out how automating the build, test and deployment of database changes reduces risk and speeds up the delivery cycle. Read more on Simple Talk |
|
|
|
| | |  | Hakim Ali from SQLServerCentral.com Both options have their advantages and disadvantages. Neither is universally right for all situations. Understand the differences before picking the model that works for your situation. More » |
 | Additional Articles from SimpleTalk Scala and Apache Spark might seem an unlikely medium for implementing an ETL process, but there are reasons for considering it as an alternative. After all, many Big Data solutions are ideally suited to the preparation of data for input into a relational database, and Scala is a well thought-out and expressive language. Krzysztof Stanaszek describes some of the advantages and disadvantages of a scala-based approach to implementing and testing an ETL solution. More » |
| | Additional Articles from Microsoft MSDN A new whitepaper published today gives Microsoft SQL customers technical guidance for how to approach GDPR compliance with Microsoft SQL technologies. More » |
 | Redgate are doing some early stage research around PostgreSQL, and would really like to hear about your experiences. If you think you can help, check out their short survey. More » |
 | SQLRUs from SQLServerCentral Blogs I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to... More » |
| | dustinryan from SQLServerCentral Blogs A question that I answer what seems like all the time is how to run cross-database queries against Azure SQL... More » |
|
|
| | | Today's Question (by Stanley Kapfunde): What does the following command do? USE [YourDatabaseName]; DBCC LOGINFO; |
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: DBCC. 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 | | Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, 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): What are the options for the first parameter in WAITFOR? The second parameter is the one that include the datetime value. Choose 2.
Answer: Explanation: The two options are DELAY and TIME. Ref: WAITFOR - 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.
Database in recovery pending state - In our live environment we had Alwayson configured but for some reason it was causing instability to database and we...
Page Split - Hi Experts, We are observing heavy page split on one table which have frequent Insert and Update. Tables stores vehicle information... Stopping Service in Cluster - Stopped SQL service from Configuration manager in a cluster, is the failover supposed to happen? Will stopping SQL Server resource or...
SSIS - dynamically populate remotepath in FTP task - I am working with SSIS 2014 and need to set up a foreach loop that will download all files that... Prevent Delete - How can I prevent users from Deleting data from all tables in a DB? Negative Consequences of Too Many Indexes - Are there any negative consequences of adding too many indexes, such as in performance. What is considered too many? Stored Procedure Performance After Creation - I understand that stored procedures are compiled on the first run, possibly making the runtime longer. If I create a... Benefit of updating statistics after creating new index - Is there any performance benefit of updating statistics after creating a new index? I am in the process of creating...
Parse Data in SQL - I have data into field (SS)(DD)(GG) i want parse that field into 3 different column. Is Substring work or there... Convert varchar to datetime uk english format - I have a column that is varchar(8) which holds a date as 20170609. I need to convert it to datetime...
Things to consider while creating new table for an application - Hi All, I am going to design a new table for one functionality which we are going to add in our... Identity insert without reseed - Hi! Can I insert a table without identity reseed? Exapmle: CREATE TABLE #table (id int IDENTITY (1,1), col1 int) INSERT INTO #table DEFAULT VALUES --...
Data Integrity Check job failure - Hello -- We are using Ola Hallengren's MaintenanceSolution scripts on our server. The Database Integrity Check for the user databases has...
Incremental Load with INSERT, UPDATE and DELETE on Fact Table with 100+ million rows - Hi, I have to design an incremental load on a SQL Server 2016 fact table with 100+ million rows. In most...
SQL Days until Christmas - I was asked to calculate the days until christmas Select DateDiff(dd,getdate(),'12-25-' + convert(nvarchar(4),DateName(yyyy,getdate()))) I feel cheesey today :-D |
|
| 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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|