SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

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.com

Join the debate, and respond to today's editorial on the forums

ADVERTISEMENT
SQL Provision

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

GDPR

How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

Featured Contents

 

Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes

Hugo Kornelis from SQLServerCentral.com

More »


 

Free eBook: Fundamentals of SQL Server 2012 Replication

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 »


 

Welcome to the new world of curating data, not owning it

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 »


 

From the SQLServerCentral Blogs - What is an Event-Less Extended Event Session?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the... More »


 

From the SQLServerCentral Blogs - Understanding Cosmos DB

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 »

Question of the Day

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

Yesterday's Question (by Steve Jones):

My SQL Server 2017 instance is a busy system with a high workload. I have 64GB of RAM on the host. What should I set SQL Server to use for min and max server memory? SQL Server is the only server application running on this host.

Answer: min = default, max = 57GB

Explanation:

The general rule is that you want to set max server memory below the actual amount in your host. The rule of thumb is to leave (for the OS):

  • 4GB for the first 16GB 
  • 1GB for each additional 16GB

This means for a 64GB server, we'd leave 7GB.

Ref: How much memory does my SQL Server actually need? - https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/

Server Memory Server Configuration Options - 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.

SQL Server 2016 : SQL Server 2016 - Administration

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...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

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...


SQL Server 2014 : Administration - SQL Server 2014

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...


SQL Server 2014 : Development - SQL Server 2014

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...


SQL Server 2012 : SQL 2012 - General

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...


SQL Server 2012 : SQL Server 2012 - T-SQL

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...


SQL Server 2008 : SQL Server 2008 - General

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...


SQL Server 2008 : T-SQL (SS2K8)

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...


Programming : Powershell

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...


Data Warehousing : Analysis Services

Measure Calculation - Here some background: I am using vs2010 multidimensional cube solution. My fact table, FactProductionClaims, consists of contract keys and the claims keys...


Database Design : Design Ideas and Questions

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...


SQLServerCentral.com : Articles Requested

TRY_PARSE - A look at this new T-SQL function, along wiht some examples of where this can help prevent errors in code


SQL Server 2005 : Backups

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...


SQL Server 2005 : T-SQL (SS2K5)

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