| A community of more than 1,600,000 database professionals and growing |
| | Release Wednesday This editorial was originally published on Apr 8, 2015. It is being republished as Steve is traveling. I'm glad that someone else is adopting Release Wednesdays. I was surprised to see the post from Red Gate, though I shouldn't have been. I knew we were releasing regularly and some groups were aiming for weekly releases. There was easily a 1 in 7 chance of them choosing Wednesdays, which has a special meaning for me. I worked at a startup company where we released every Wednesday. We worked in one week increments and developed an application across a couple years that evolved and morphed to meet differing business needs in the education market. We went from working with digital sales, to including physical products, to subscriptions. Our customers went from individuals to corporations, to departments in corporations, and all along the way we managed front end and database changes in one (or sometimes two) week increments. We didn't practice Agile or Scrum or anything formal. We worked as closely as 10 people could, coordinating and communicating to get features implemented every week. We started releasing on Wednesday nights with the lead developer and myself staying late at the office Wednesday nights (usually with another developer or two for company) for an hour. That was reduced to phone calls where we deployed from home (and fixed problems) in real time. Eventually we built such a well engineered process, with thorough testing, that our deployments were completed in minutes with a few chat messages to verify we'd both finished our tasks. We did that for over 18 months with only one or two rollbacks, and without the all night frantic coding sessions to fix issues that I'd experienced elsewhere. It wasn't simple, but it wasn't hard. It required preparation, planning, a strong culture of professionalism, and support from our CTO. I see the same types of culture at Red Gate, and I'm not surprised by the rapid releases, nor the success we're having in evolving, updating, and patching our products over time. I'm excited to see how much quicker we can move and how we will continue to build better software, faster. One Wednesday at a time. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT | | NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial |
| |
|
|
| | | Press Release from Redgate Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege. More » |
| Faced with the new challenges of data protection – and increased levels of oversight – many of us working with SQL Server have come to the same conclusion. Quite simply, the column names and free text descriptions available to us to describe the data in our care (or data-containing artefacts like columns, tables and databases) are no longer sufficient. More » |
| (Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the... More » |
| James Serra from SQLServerCentral Blogs Cosmos DB is an awesome product that is mainly used for large-scale OLTP solutions. Any web, mobile, gaming, and IoT application that... More » |
|
|
| | Today's Question (by Steve Jones): Which of these are true about lists, tuples, and dictionaries? (choose 3) |
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 | Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| |
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums. how to change Default Code Colors in sql SSMS 2016? - Hi Gurus, I downloaded SQLSSMS 2016, everything looks fine except light green color font for "System table, view, or table-valued function.... Always On Availability Groups Failover Question - Hi, I'm curious if anyone knows the answer to this off the top of their head since I'm not able to... Converting MTVF to In-Line TVF. - I am trying to convert a MTVF into an In-Line TVF. I already went through and changed a whole lot... Linked servers on an instance all pointing to the local instance. - We have around 4 linked servers on an instance, each one of them pointing to a remote instance. These were... Excessive Paging Continues... - We've been experiencing "excessive paging" for a while (per perfmon review). Application is sluggish. Added memory to the server (virtual machine), there's... How to fix this query? - This query has been driving me nuts and need some help please. I have a working example below but, to... SARGability of query - We have inherited the following (obfuscated) code, and are looking to improve performance. MyAudit has over 35 million rows, and... Joining a large table to itself....better ideas? - Hello all, I'm creating a view to use for future queries to make things easier. Essentially this view needs to join... Logging options while running stored procedure - Hi I am tasked with building a stored procedure which performs inserts, merges, etc. What i have now is as follows. create... Looking for SQL Server Inventory Tool - Looking for recommendations on a SQL Server "Inventory tool" that will identify all SQL Servers in our environment. We have over... carving out bussiness hours. - so i'm newish to SQL and SSRS but i'm working on a report that allows me to calculate average times... Query working differently on different servers - Hi - I've got a development server where my T-SQL code is working fine, but when I port it to my... AX On SQL Server 2008 - Evening All, Just inherited an AX 2009 sql server, that has intermittent performance problems. I've seen some people suggesting that setting maxdop... Clustered PK perf - - Hi Experts, I have a doubt reg. the creation of a clustered PK for one of our DWH tables. Background - There's a... Programmatically trigger an event on a WinForms object in Powershell - Hi all, Let's say I've got a label ($ObjLabel) and a checkbox ($ObjCheckBox), that is created not checked, and added to... Measure Calculation - Here some background: I am using vs2010 multidimensional cube solution. My fact table, FactProductionClaims, consists of contract keys and the claims keys... Computed columns best practices. - Hi all. I'm having a helluva time deciding whether or not to use a bunch of computed columns. I seem... TRY_PARSE - A look at this new T-SQL function, along wiht some examples of where this can help prevent errors in code Taking backup with option "Disk = nul" - hi , can anybody tell me what exactly below backup query does ? and where it keep the backup file after taking... Calculate XIRR in SQL Server - Hello All, Is there any way to calculate XIRR in SQL server using T-SQL. Kindly suggest. Thankx |
|
| 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 |
|
|