| A community of more than 1,600,000 database professionals and growing |
| | A Software Warranty This editorial was originally released on Oct 21, 2012. It is being re-published as Steve is traveling. Years ago I worked in a large company on the operations team. We were responsible for all production issues for the 6,000 people and the assorted machines, devices, and applications that come with a large workforce. There was a department that was aligned with our group that focused on engineering and various development groups that built different applications. The engineering group was good at working closely with the production team to ensure smooth deployments, but they weren't on call and would at times respond slowly to develop solutions when problems occurred. They were, however, better than the development groups who often sent code to be deployed, and accepted bug reports back, but provided little support or assistance for problems with their code. I ran across this link from a DevOps person called You Write It, You Support It in the Brent Ozar, PLF newsletter. The piece makes a case for the problems that occur with some deployments, like a lack of, or surplus, of logging, switches to turn features on/off, error handling, and more. It's a pretty good description of typical problems I've often seen, and it calls for developers to support the features that they write, even in production systems. I like this idea, though I don't think that it should be a continuous expectation with developers required to support their code forever. I would like to see developers giving their code a "warranty" of sorts, perhaps a couple months of priority support when code is deployed into live environments with developers taking responsibility and responding to calls, even after hours. There are arguments to be made that developers' time is better spent enhancing applications and applying their creativity to new ideas, but this leads to a human frailty. Too often we view a job finished as a job completed, and that's not always the case. Doing a job well means more than completion. It implies a level of craftsmanship and pride in the finished product, both from the developer and the client. Developers should write code that works. If it doesn't, then it's not really finished and should be fixed. With that contract in place, we usually find that the developer spends a bit more time ensuring the product is built in a quality way that reduces the need for much support. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | Free whitepaper: Solving the database deployment problem with Database Lifecycle Management Learn how to use your source control, CI, and release management tools to make your database development process efficient, safe, and Agile. Start today with this free whitepaper. |
| | How to fix SQL Server disk I/O bottlenecks (without a hammer) In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes of disk I/O bottlenecks, including gathering data, avoiding knee-jerk fixes, and how monitoring tools can help. Read now. |
| | How can you help your team write better, shareable SQL faster? Find out by discovering 15 Super SQL Tips from Microsoft MVPs and other SQL Server experts. Using SQL Prompt to write, refactor, and share SQL, they show how it strips away the repetition of coding and standardizes it everywhere. View the tips and download a free trial. |
|
|
|
| | | J. Drew Allen from SQLServerCentral.com One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue. More » |
| Additional Articles from SimpleTalk Sometimes a request from a user who doesn't appreciate the limitations of the technology can jolt you into discovering that an application feature that was, until recently, difficult to achieve is suddenly relatively easy. Dino was asked to allow the user to take photographs and associate them with an item of work. After he'd recovered from the shock, he decided that it was achievable, and now describes how he went on and did it. More » |
| Watch the recording of our latest DLM Demo webinar and learn how to improve your database change management process. See how Redgate DLM plugs into TFS, TFS Build & Octopus Deploy so that you can automate your database changes alongside your application code. More » |
| Grant Fritchey from SQLServerCentral Blogs Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what... More » |
| WaterOx from SQLServerCentral Blogs No pressure. None whatsoever. There is just an Auditor standing behind you waiting for you to pull a list of... More » |
|
|
| | Today's Question (by Steve Jones): I have a SQL Server 2016 instance and I'd like to add some In-Memory OLTP tables to my system. Where do I store these in a SQL Server database? |
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: In-Memory OLTP Tables. 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 | Power Query for Power BI and Excel Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| |
| | S M from SQLServerCentral.com Copy the Cursor script and run it. This will enable email notification for the jobs for the operator passed into the script. More » |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. Setting Log FIle growth to unlimited - Hello Everyone, I have an Existing DB. I am trying to change the Log FIle growth to unlimited. I am changing... Multiple row data need to be convert as Coloumn - HI All, I need to convert the Rows data into column for multiple rows in table. actual data in my table seems... Recommendation for better perfromance - HI I need recommendations for better performance of sql .we have 32bit SQL servers and want to make sure we... Log Data Being Read/Queried - Morning All, I want to analyse the datetime on a particular table as I want to identify an date range of... Deadlock error MERGE - I have a step that produces the xml and the MERGE table 1 insert and update, if you run it... Transaction logs arent being truncated after backups - Dear DBAs I am running the following TSQL to backup my transaction logs once a day Yes i know you... SQL Server license requirements - My query is whether SQL server license is required for the WEB server & for the application server ? Or is it... Monthly total of active data - For a report I'm trying to write I ideally need a recordset that shows me how many people were on... t-sql 2012 trigger - Would you show me how to setup a trigger from the items I listed below for a t-sql 2012 database? 1.I... How to get the previous weeks data based on week ending - I need to get a weekly count of records with Friday being the end of the week. So, the report... High lob logical reads on a query with just 2 simple tables - [code="sql"] /* Table1: NotificationType (NotificationTypeID INT PK Clustered, NotificationCriteria xml, TypeName Varchar(200), Deleted char(1)) Table1 has 25 rows Table2: Subscription (SubscriptionID INT PK Clustered,... How to imbed an image into an email sent by dbmail - Hello all and thank you in advance for your time and expertise. I am sending out customer statements in email using... Calculate time difference between two related visitors without using cursor - I have a table (see attached) listing visitors IDs, listed more than once, and Arrival DateTime. I need to find... Index guidance needed - Hi everyone. I recently came across a dev database in our organization that had no clustered indexes and circa 100 million... Finally got my SQL Server database into Azure! - I finally got my SQL Server database uploaded into Azure SQL! I posted a blog post about it. Rather than... Setting Up Reporting Services - Hello, I have a potentially dumb question ...but there are no dumb questions right?!? I have only ever used reporting services... Generate Create Script for a table - include indexes, keys, statistics - I spent yesterday trying various approaches to this found on google. Couldn't get any to work. What I'm looking for is... How to force column explicitly to string type before we export to excel - I have a package which laods data to excel ,but my manger wants to force column explicitly to string type... very high CX packet waits - i have noticed very high CXPacket waits on one of our dataware house server. All these queries are just select... How does a C# CLR trigger know the table it was called for? - I'm researching to create a C# CLR trigger that implements the auditing for any table in a database. One generic... |
|
| 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 ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|