| A community of more than 1,600,000 database professionals and growing |
| | The Downside of Tool Autonomy I am a big believer in letting teams of people work in a way that allows them some autonomy to solve a problem. I think this is especially important in the software world, where developers need to experiment and learn from the new ideas that they investigate. They need to be able to try new techniques, technologies, and platforms. Yes, that includes NoSQL data stores. At the same time, this can lead to developers becoming captivated by new tools and techniques, all of which are good for advancing skills and code maturity, but can also lead to a very disparate environment where there are no best of breed solutions, or no standards for writing features. As the number of developers grow, this also raises the bar for each individual to know and understand more languages or technologies. While I do think it's easy to pick up logic and syntax, when writing production code, we want to ensure we're optimizing the way we work. The way in which we might write some code when we start with a new API, SDK, language, etc. is often not the way we'd write that code after a year or experience. At least, I hope it's not the same way. There are nuances, tips, and tricks in how to better structure code that we learn as our experience grows. When I was at the Redgate Software office last year, I noticed that there was a short article posted on our internal blog. This noted that there is a set list of tools and technologies to use when building our products. This isn't intended to be a long term immutable list, and the post noted that other choices are possible, but we want to avoid an unending growing list of tools when we have identified there is a good tool in a space. There is an approval process to propose and new tool and explain why it really is needed. At Redgate, we're pretty flexible and open, so I'm sure this isn't a tough process. However it does prevent every developer from implementing their special little code into a project. We've had people use various different data stores, different types of web technologies, and it becomes a maintenance issue over time. Even the VB.NET component we used for years at SQLServerCentral caused headaches as there wasn't any experience in the company in this language. I think it's worth having some light overview that ensures an organization isn't adding technology just for the sake of making one or two developers happy. There is a finite amount of time to spend learning and growing, and while it's important that technology workers do this, we also want to developer more experience and expertise in a few areas. Limiting tools and technologies helps preserve a balance that allows for growth, but ensures the expansion isn't unchecked. 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.6MB) 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 | | NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. Download your free trial |
| | Redgate University Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers. Start Learning |
|
|
|
| | | Konstantin Taranov from SQLServerCentral.com Complete list of useful and must have add-ins for SQL Server Management Studio - 34 SSMS add-ins More » |
| Additional Articles from SimpleTalk Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts. More » |
| Storing your data for development work as JSON confers several advantages. You can exchange data with any application or service that can consume JSON data, you can edit the data easily in a JSON editor, use lightning fast data masking that doesn’t leave a trace in the database, and you can very easily validate the data before you insert it. More » |
| Steve Jones from SQLServerCentral Blogs Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More » |
|
|
| | Today's Question (by Steve Jones): I have this table in SQL Server 2017, which I create and add a few rows for testing. CREATE TABLE dbo.SalesOrderHeader ( OrderKey TINYINT IDENTITY(1, 1) , CustomerName VARCHAR(30) ) GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve') GO Things look good, so I now run this: TRUNCATE TABLE dbo.SalesOrderHeader GO DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0) GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Alice') GO What is the value for OrderKey for the row with "Alice"? |
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: IDENTITY Property. 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 | Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have loaded a dataframe into memory like this: nfl2018.qb = read.csv("nfl2018qb.csv", header = TRUE) This gives me this data: > head(nfl2018.qb) Rk Player Tm Age Pos G GS QBrec Cmpâ.. Att CompPrcnt Yds TD 1 1 Ben Roethlisberger\\RoetBe00 PIT 36 QB 16 16 9-6-1 452 675 67.0 5129 34 2 2 Andrew Luck\\LuckAn00 IND 29 QB 16 16 10-6-0 430 639 67.3 4593 39 3 3 Kirk Cousins\\CousKi00 MIN 30 QB 16 16 8-7-1 425 606 70.1 4298 30 4 4 Matt Ryan\\RyanMa00 ATL 33 QB 16 16 7-9-0 422 608 69.4 4924 35 5 5 Patrick Mahomes*\\MahoPa00 KAN 23 QB 16 16 12-4-0 383 580 66.0 5097 50 6 6 Derek Carr\\CarrDe02 OAK 27 QB 16 16 4-12-0 381 553 68.9 4049 19 TD. Int Int. Lng Y.A AY.A Y.C Y.G Rate QBR Sk Yds.1 NY.A ANY.A Sk. X4QC GWD 1 5.0 16 2.4 97 7.6 7.5 11.3 320.6 96.5 73.0 24 166 7.10 7.04 3.4 2 3 2 6.1 15 2.3 68 7.2 7.4 10.7 287.1 98.7 71.5 18 134 6.79 6.95 2.7 3 3 3 5.0 10 1.7 75 7.1 7.3 10.1 268.6 99.7 60.6 40 262 6.25 6.48 6.2 1 0 4 5.8 7 1.2 75 8.1 8.7 11.7 307.8 108.1 70.6 42 296 7.12 7.71 6.5 1 1 5 8.6 12 2.1 89 8.8 9.6 13.3 318.6 113.8 82.0 26 171 8.13 8.89 4.3 2 2 6 3.4 10 1.8 66 7.3 7.2 10.6 253.1 93.9 49.3 51 299 6.21 6.09 8.4 3 3 I want to rename some columns to make them easier to use. If I want to rename "Cmp." to "CompPrcnt", how would I do this? Answer: colnames(nfl2018.qb)[colnames(nfl2018.qb)=="Cmp."] <- "CompPrcnt" Explanation: I would use the colnames() function to assign a new name. To limit this to a specific column, I pass in the colnames() function as a parameter iwth a filtering condition. This gives me: colnames(nfl2018.qb)[colnames(nfl2018.qb)=="Cmp."] Ref: How to rename columns in R - click here colnames() - 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. ssrs report subscription - We have created some subscription for some ssrs reports. But recently we found the subscription has disappeared when checking in... SSRS DB restore - Hi, I restored all databases from my old server to a new server.This includes reportserverdb and reportservertempdb. After restoring reports are not... Cause of arithmetic overflow error? - What is causing this error in the following code: Msg 8115, Level 16, State 8, Procedure sp_calcArea, Line 10 [Batch Start... Purpose of SELECT before a calcuating the value of a function's return variable - In the code below what is the purpose of the SELECT statement before @SalesTaxDue = (@TaxRate * .01) * @Total? I would think... Why doesn't a stored procedure prompt a user to enter parameters when parameters have been defined in the stored procedure? - This stored procedure accepts parameters: CREATE Can stored procedures return/output a value like a function can? - Sample code: CREATE SQL server 2012 to 2016 upgrade on same cluster - Hello all, We are in the process of upgrading a 2012 instance ( with alwaysOn ) over to 2016. We now have 4... TDE and absolutely ridiculous amounts of corruption? - I've searched around quite a bit and can't find anyone else with this problem, but ever since we implemented TDE... Sort already comma separated list - Hi I have values like this in a column which basically is the exact same thing if sorted . ORM; SQL security question: Extract limited dataset without granting access to all tables needed for the extract - I apologize for the confusing title, but I think its accurate. I have the following basic scenario. I need to... How to retrieve rows that as been deleted from the result of a DM view - Hi can someone tell me how to retrieve the result of select * FROM sys.dm_exec_sessions From a previous backup if someone has... very slow select - Team, I have this query that runs quite a long time, actually the result is not been displayed at all. Find double byte character data - I have a table which contains double byte character and single byte character records in the FORMAT column. I want... storing Image in Database (SQL Server ) vs File System - Dear All In My scenario we are handled more then 1 TB size images.Last couple of years we are storing all... How to insert multiple records from fields in select record - I am trying to take results from multiple fields from single rows that are not null and put them in... replacement for data alerts? - I work for a small school district, and we currently have SSRS 2012 running in SharePoint-integrated mode. The SharePoint is... Upgraded Visual Studio 2015 Community to Visual Studio 2017 Pro, Can’t Open Existing SSIS Packages - Hello, I am on Windows Server 2012 R2 SE, and SQL Server 2016 SP1, and I have developed several packages... Trying out a trick. - Bending strings - Based on this, which is an interesting problem: http://www.sqlservercentral.com/Forums/Topic1625170-2799-1.aspx Show how to move rows to a delimited string and then summarize. Equivalent of 'DECODE' in sql - Hi all, :) Can anyone provide me with correct syntax for' 'DECODE' function equivalent in sql. Thanks, kiran. |
|
| 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 |
|
|