 | A community of more than 1,600,000 database professionals and growing |
| | | Software Engineering in Practice This editorial was originally published on Mar 20, 2015. It is being republished as Steve is on vacation. I ran across a review of a developer's first year at a company. The company is endjin and the poster describes their first year as a "software engineer apprentice," which is an interesting way to look at one's early career. While it's not for everyone, I suspect that many developers in this business could actually use a bit of apprentice time to solidify their foundation of knowledge. The post talks more about the way in which the work is done than the actual tools involved. A few are mentioned, but this is really a look back at the philosophical way in which the company solves problems. More importantly, it's the view of an apprentice learning a trade. I wonder if this apprenticeship mentality might make a good approach for DBAs. It seems so many people working with databases lack fundamental SQL skills and even thoughtful approaches to solving problems. There are people that grow to be experts by diligently working through complex problems on their own, but it seems most people don't get solid grounding in relational principles, or even learn good engineering practices, like measuring systems before and after changes are made. Many companies rush to get work done. They want code written quickly, which I completely understand. However if your staff isn't well grounded in building solid code, then I'm not sure that poorly written applications are getting work done quickly. I suspect they're just getting something done, which then has to be fixed, enhanced, and refactored before it allows work to move faster (if at all). All of that takes place in the time that it might take someone with more skill to do it well the first time. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT |  | | 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 |
|  | | 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 |
|
|
|
| | |  | Andy Leonard from SQLServerCentral.com Azure Data Factory is a new way of moving data around, and this first level gives you a good overview of what the service can do. More » |
 | Press Release from SQLServerCentral.com This free eBook from Redgate Software will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way. More » |
 | Everyone has their own ideas for what makes for an ideal monitoring solution for their SQL Server estates. Here Rodney Landrum outlines some of his ideas for how a monitoring tool can help monitor, analyze and predict resource usage, across a growing and diversifying estate, and to help the organization to connect server resource usage and error conditions directly to their impact on business processes. More » |
 | Additional Articles from SQLServerCentral.com On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE. More » |
 | Kenneth Fisher from SQLServerCentral Blogs Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you... More » |
| | Steve Jones from SQLServerCentral Blogs Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the... More » |
|
|
| | | Today's Question (by Steve Jones): It's Halloween, and the founders of SQLServerCentral are dressing up for a party, but they chose some unusual colors. Their names, costumes, and costume colors are listed in this tuple. Costumes = (("Steve", "Batman", ("Black", "Green")), ("Andy", "Superman", ("Blue", "Orange")), ("Brian", "Flash", ("Red", "Brown"))) I want to get the unusual color of Andy's costume, so I can find him. The unusual color is the second color listed. How can I get Andy's color if I query the tuple in Python? |
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: Python. 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 | | Pro Power BI Desktop This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Sergey Gigoyan): What will be the value of TRANCOUNT after the first execution of the following query in a new query window? 
Answer: 2 Explanation: Rolling back to a savepoint does not change the value of @@TRANCOUNT. Ref: Understanding Transaction Savepoints - 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.
Login issue -Password did not match - Hi All, Need help...and logs does not help Error : ‘Login failed for user ‘sa’. Reason: Password did not match that for the login... Best way to mirror SQL database of customers to our SQL database - We have installed a SQL 2017 database on a Windows 2016 server at our customers (about 20) worldwide. We Installed a...
SP with dynamic sql parameters - Hello, I have one SP CREATE PROCEDURE . @year char(4), @criteria varchar(50) = NULL, @Flag char(1) = NULL, @searchstring varchar(100) = NULL AS DECLARE...
Full Backup Files - Fastest Way to Copy Over WAN - Hi, I am trying to Robocopy large .bak files over the WAN and it's going terribly slow. The full backup files... Where is the Performance Bottleneck? - Evening Guys, I am back with another performance enigma (at least for me!). I have a couple of queries (altering the collation... How To Truncate Log with Transaction Replication - I am running a transactional replication and seeing the transaction log growing in the publisher database; it is a little... Tables using ANSI_NULLS - Hi, I have a database that's comprised of over 10,000 tables. Approximately 250 tables were created with ansi_nulls set to "on"... SQL job step to copy backup file not working - Hello All, I'm trying to copy a recent backup file from one server to another using the syntax below as part of... SQL 2016 alwayOn AG failover failure when primary site went down - Hi, I have an issue that happened during a disaster testing. The setup is the following. 2 sites geographically separated with AD on...
T SQL Question sd.name ? - The purpose of the code is to; Model an additional script to setthe Database Recovery Mode to ‘FULL’. Your script shall... Changing 1 or + in a telephone number to the correct format - Hi everyone I have various records in a database that contain US telephone numbers in different formats. Some are correctly formatted... Memory Optimized Tables - Cross DB access - Hello, Is there a workaround to accessing a memory optimized table from another db? For a select only? DB1 -> The location... seperate data in 1 row - Hello HOw can I separate this data I have buch of emails in a row, I need to keep just one and...
Refining login permissions to SQL views - Hello, We are attempting to give permissions to a vendor via a SQL login to be able to see and select...
Column data type - Msg 207 Invalid column name - Hello , Can someone point me in the right direction here. I'm having a hard time figuring this out. I have a... Stored Procedure - Issue - Hi Please help with the following stored procedure, what am I doing wrong? USE msdb GO CREATE PROCEDURE dbo.sp_getbackuphistory @DATABASE VARCHAR(50), @TimeDiff INT OUTPUT AS BEGIN SELECT...
SSIS Warning - Global Shared Memory - Hi I'm busy rewriting DTS packages as SSIS packages. As and when I finish a package I run it in debug...
Restoring Server Certificate to new instance - I have two instances, InstanceA running under accountA, and InstanceB running under accountB. Both instances are on the same machine. I have...
How to get patient information, page header, to appear on second page of report - I have a report that works great except when it runs to a second page. I need to get the...
SSIS 2008R2 to 2014 upgrade - the requested OLE DB provider Microsoft.ACE.OLEDB.15.0 is not registered ... - We were using 2008R2 and developed multiple packages in BIDS - all of them taking data from Excel into SQL. When... |
|
| 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 |
|
|