| A community of more than 1,600,000 database professionals and growing |
| | Looking Back Someone sent me this post on 40 years of programming. It's a read that laments a few things and complains about many others. Most of the thoughts are opinions, and as such, you may or may not see validity in them. I suspect most of you, like me, see some things are mostly true and some as just false. Since I've been in this business for nearly 30 years, many of the comments bring back memories and thoughts about my career as well. One of the things I do lament is the declining quality of documentation. I've seen the volume and detail decline over the years. I wouldn't want to go back to paper, but I would like to see better examples and more complete examination of the ins and outs of the various functions and features. Far too often I find that there are examples, explanations, or behaviors that are missing. I see the same thing in blogs and articles, which often leap and skip steps in their race to publish. Focus and detail on a specific topic has been forgotten by too many. Even understanding the way your code works, or the ways the dependencies work has been lost. As more and more people move to using NuGet and pulling down packages, I find too often that many developers don't quite understand how their systems work. The divide between those that practice DevOps well and those that just release code faster continues to grow. Few learn from their efforts and produce smoother software development pipelines. Most release code faster, losing track of which versions and dependencies that are required. I still see projects from GitHub and other sources that lack explanations of how to actually compile and setup the project. It seems far too many developers half release software, expecting others to spend time learning what works and what doesn't. What versions were used, and might be needed again. Maybe in some places the software evolves so quickly, adopting new methodologies and technologies constantly, that developers never need to truly understand the system. They just get things working and then change them. Maybe that's why so many people want to rewrite and reproduce software rather than using some existing project and improving on it. The one thing I do wish was in all languages is a standard way of handling data types and comparing them. I constantly struggle with = and == when I move away from SQL. The comparisons in PoSh make no sense, and I regularly get errors from > until I change to -gt. It seems plenty of language designers want to make their own creation and cause divergence for no good reason. I do wish SQL had implemented == for comparisons, or that they would in the future. As I look back, some things in computer science haven't really changed at all. Speed and scales have grown, but many concepts remain the same. However, in other ways, I think we've come so far, building amazing systems that are interconnected in ways that we might never have imagined a decade ago, much less 30 years ago. 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.4MB) 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 do you manage sensitive data? Redgate's Foundry team are researching data discovery and classification. Fill out this short survey if you think you can help, and at the end you'll be entered into a prize draw. Fill out survey |
| | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial |
|
|
|
| | | Konstantin Taranov from SQLServerCentral.com Complete list of useful and must have add-ins for SQL Server Management Studio - 30 SSMS add-ins More » |
| Additional Articles from SimpleTalk User-Defined Functions (UDFs) are an essential part of the database developers' armoury. They are extraordinarily versatile, but just because you can even use scalar UDFs in WHERE clauses, computed columns and check constraints doesn't mean that you should. Multi-statement UDFs come at a cost and it is good to understand all the restrictions and potential drawbacks. Phil Factor gives an overview of User-defined functions: their virtues, vices and their syntax. More » |
| Grant Fritchey from SQLServerCentral Blogs If you keep your head up and look around you’ll see the choices people make all the time. I saw... More » |
| Andy Galbraith from SQLServerCentral Blogs It's T-SQL Tuesday time again, and this month the host is Raul Gonzalez (blog/@SQLDoubleG). His chosen topic is Lessons Learned... More » |
|
|
| | Today's Question (by Steve Jones): In Python, how do delimit a block of code? In other words, if I have an IF statement, how do I determine which lines of code are related to the THEN action of the IF statement? |
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. 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 | More than ever, the effective management of technology is critical for business competitiveness. For decades, technology leaders have struggled to balance agility, reliability, and security. The consequences of failure have never been greater?whether it's the healthcare.gov debacle, cardholder data breaches, or missing the boat with Big Data in the cloud. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): When making disaster recovery plans, which concept deals with the amount of data loss you are willing to tolerate? Answer: RPO Explanation: In DR planning, RPO and RTO are two concepts that help you determine what process or procedures to implement. RPO is the recover point objective and deals with determining which points in time you can recovery back to. This is essentially the amount of data loss you allow. RTO is the recovery time objective, or how long it takes to restore systems to use. Ref: RPO - click here RTO - 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. SQL2016 Servername\Replication - I am receiving an error when trying to configure replication on 2016 as a distribution database. There states that replication... SQL Server Inventory - With so many database servers (prod, test, dev ) it is hard to keep track of them all. What are some... User_update high but no user seek/scan. Is this an effective index? - Hello, Seeing the execution plan created one index for which I can see that the User_update is v high but no... UNION Question - I can't believe I'm having to ask this, but I am noticing some incredibly odd behavior with a UNION that... Reseed one table column - Hi, There is an user table which uses for eventlogging. The id column is Primary and Identity(1,1). The app team deletes... Successful jobs got failure notifications - I've got some very puzzling job failure notifications for scheduled jobs that actually ran successfully. These jobs have been running... Concatenate rows into string - Hi, my Cross-Apply returns multiple Values. How can i bring these Values to 1 String (V1,V2,V3....) into my MainSelect? SELECT distinct a. ... Pass dataset as parameter from application to stored procedure - How to pass a dataset as parameter to a stored procedure? Ascii Range 32 to 126 - How do I search if a column has characters out of this range - Ok , so this particular issue, i am clueless. Select top 10 ProviderFirstLineBusinessPracticeLocationAddress,LEN(ProviderFirstLineBusinessPracticeLocationAddress), ProviderFirstLineBusinessMailingAddress, LEN(ProviderFirstLineBusinessMailingAddress) FROM . I have to send data via SSI use exec(@sql) in if exists and get output parameters dynamic sql - I have result set from @runtimequery like below .I want to set 2 parameters according to the in it .Though... Get total user session with client IP address - Hi. The following script fetching number of user session. Is there way to get total user session along with client IP... update column based on max date for each employee - Kinl provide the update query for update column TeamId based on max date for each employee Scenario: An Employee can be part of... How to load data to table from SQL Audit File - I have enabled Auditing in SQL Server 2008R2 to monitor DML AND DDL oprations. Is there any way to load SQL... Distinct query with all columns - Hi Guys I am just looking at below the query which is hitting our database quite a lot. This is taking about... Year, Month and Days from date of birth table - Hello, I need Year, Months and Days from date of birth column from age table. Can you please help me to extract... searching for ending and deleting - Dear All , I am having question ,i have column that some time ends with mr / mrs or chd01 and some... Who inserted duplicated key value yesterday - Good Morning Experts, SOmeone tried to insert duplicate value in a table yesterday and we see this error Violation of PRIMARY KEY... I am having trouble running the following Nested iif statement in an SSRS expression.. any insight would really helps - ="Reporting Months:- " & join(iif(Parameters!Month.Value ,"1" ,"January" ,ii SSDT Execute SQL task is not resolving parameters - Summary: SSDT is not resolving parameters in a simple statement DROP TABLE . Details: Environment: Microsoft Visual Studio 2015 Shell (Integrated) Version 14.0.23107.0... SSAS CUBE Filter Data By Membership Users - Hi All, I am starting now work in the SSAS so I have very poor knowledge yet. |
|
| 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] |
|
|