Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate Database Devops
The Voice of the DBA
 

Product Platform Teams

Is infrastructure a product? Should an Ops team start to feel like they are a team involved in building things rather than maintaining them? It's an interesting idea that is put forth in this blog from Forrester. The piece postulates that the Ops group should be thinking like a product team, just like developers working on an application.

When a development group moves to a DevOps style of building things, and starts to take some responsibility for the support of their work, what does the Ops group do? If we push infrastructure as code into our VCS, is there much for the Ops group to do?

I'd argue there still is. From the DBA side, operational staff can help determine what infrastructure is needed, or what changes need to be made. It's easy to say that devs should add RAM or CPUs, or even another replica, but do they really know when to add them? Or do they just scale everything up? The latter might be easy on people used to writing code, but it's not necessarily a good idea for the organizational budget.

Ops staff can still tune systems, add indexes and rewrite code, and give feedback and knowledge to developers to help them understand how to write better code, or infra-as-code code, the first time. There's also the need to practice and be ready for various DR situations, including the "whoops, I deleted some data". There are skills that help handle these situations, which are far different from developer skills.

This is in addition to designing new systems and setting templates for that infrastructure as code that the developers keep in their VCS. There's also the need to build self-service tools, which might be where Ops becomes a product team. I think that will be necessary, and might even include reporting needs that developers don't have time to build. Ultimately, though, there is still a need for some Ops work, albeit work that ought to be closely aligned, and shared, with developers.

Steve Jones - SSC Editor

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

Redgate SQL Provision
 
 Featured Contents

SQL Server Name Convention and T-SQL Programming Style

kast218 from SQLServerCentral

There are only two hard things in Computer Science: cache invalidation and naming things -- Phil Karlton The recommendations in this article are not the ultimate truth. Please consider this article as a rule template that you can adapt to your needs. A naming convention is a set of rules for choosing the character sequence to […]

Deploying Data and Schema Together with SQL Compare or SQL Change Automation

Additional Articles from Redgate

You want to use SQL Compare or SQL Change Automation (SCA) to create or update a database, and at the same time ensure that its data is as you expect. You want to avoid running any additional PowerShell scripting every time you do it, and you want to keep everything in source control, including the data. You just want to keep everything simple. Phil Factor demonstrates how it's done, by generating MERGE scripts from a stored procedure.

SSRS is Still Around

Additional Articles from SimpleTalk

The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI is the premier MS reporting and dashboarding tool. It seems like more organizations are finding fewer reasons to use SSRS due to the ease of use and features of Power BI. Despite all the news about the general availability of SQL Server 2019, I had not heard any recent news about SSRS, so I could only say that I didn’t know.

From the SQL Server Central Blogs - How Serverless is Working in Azure SQL Database

Steve Jones - SSC Editor from The Voice of the DBA

When Azure SQL Database introduced the serverless option, I decided to try it. I moved one of my databases to the tier, though I had to move to a...

From the SQL Server Central Blogs - Install ALL Things SQL Server… What?

SQLEspresso from SQLEspresso

Does your server look like this? Many of us have inherited a SQL Server instance that has all SQL Services installed. Someone, maybe even you, went through the SQL...

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

What's a page split?

What is a page split in SQL Server?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by sergey.gigoyan)

Rebuild vs Reorganize

Which statements are correct about the rebuilding and reorganizing indexes in MS SQL Server?

Answer: In case of rebuilding an index, it is possible to set the fill factor setting of the index, As compared to the rebuild index operation, reorganize index is less resource-consuming operation, Reorganizing an index is an online operation

Explanation: When an index is reorganized, this does not affect fragmentation. When a clustered index is rebuilt, this does not rebuild non clustered indexes. This used to happen, but no longer does. Reorganizing an index is online, and it is less resource intensive than rebuilding. Ref:

   

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 2017 - Administration
Lincensing qn - All, Somewhat new to SQL server licensing. Do we have to license the sql server database used in landing area of a production data warehouse; the warehouse is one step downstream - landing area feeds to the warehouse while landing area gets its feeds from multiple sources. Can we use Developer edition for this landing […]
SQL Server 2017 - Development
sp_send_dbmail passing parameter to @query - I am trying to pass a parameter into the @query argument of sp_send_dbmail for my first time.  Here is some code as a simple example: --drop table mydb.dbo.tmptable create table mydb.dbo.tmptable (idno int, namefld varchar(20), color varchar(20)) insert into mydb.dbo.tmptable select 1, 'elephant', 'gray' union all select 2, 'bear', 'black' union all select 3, 'cat', […]
Stored Procedure Documentation - I have developed several stored procedures that will be utilized by developers on a project (surprise right?). My question is that I need to provide them with documentation about how the stored procedure works (including parameters and results). Does anyone have a "simple" template for creating this documentation? I do not want to make it […]
SQL Server 2016 - Administration
Temp db behavior....very simple question - When originally setting up Temp db..... I give it a size container of 8MB, with autogrowth of 2 MB, unlimited...total size of drive is 20 MB Actual size of tempdb at first is 3 MB My question: When the temp db is triggered to grow by 2 MB...does the original container of 8MB goto 10 […]
Actively running Resource Hogs - I recently had an experience where I identified that there was a significant hole in my SQL Server troubleshooting toolset. I had a server that was consuming ~60% more CPU than it typically does.  I have developed some fairly nice processes that capture completed queries with all the CPU/IO metrics.  This has been extremely helpful […]
SQL Server 2016 - Development and T-SQL
Parse String Dilema - Hello, Try and try as I may, I'm struggling with this one.  As the topic suggests, I have a name field which varies greatly.  Basically, it's in the LastName, [space] FirstName format.  However, many have middle initials, hyphenated last names, some are Juniors, some are III's you name it. Examples.... Doe, Jane   Doe, Jane E  […]
Developing SSIS packages in VS 2019 and running them on SQL Server 2014 and 2016 - If I develop ssis packages in VS2019 will they be able to run on SQL Server 2014 and 2016?
Developing SSIS packages in VS 2019 and running them on SQL Server 2014 and 2016 - If I develop ssis packages in VS2019 will the be able to run on SQL Server 2014 and 2016?
Snapshot Isolation and DMVs - I recently noticed that DMVs, or at least sys.dm_db_partition_stats, does not respect snapshot isolation.  I couldn't find anything describing this behavior in books online, so I was wondering if this is expected/desired behavior?  Here are steps to follow if you'd like to repeat the behavior: Create a dummy table but don't add any values to […]
Administration - SQL Server 2014
services not list in sql config mgr - Hi All, On one of the sql server machine, when I open the sql server configuration manager, I am not able to see sql server services. But if I open start->run->services.msc, I can see the services there. Why It is not showing up in SQL Server Configuration Manager, Anyone faced it ?     Thanks, […]
SQL 2012 - General
Query Slow Result - hi , i getting result of query 65954 rows its take 20 seconds how i can i make query fast.  
Convert nchar to time and addition functionality - I have a scenario: I have a nchar field which is tagged as start time whos value is goes like this: 2300, 2330,0900,0300,1400 so on Other nchar field which is duration field & the values goes like 0300, 0600, 0400. My scenario is to add the starttime field and duration field to check if the […]
Reporting Services
SSRS - Formatting report to print as USPS postcards, example. - Hello all, I have to create an SSRS Report that will print as a USPS postcard, on both sides of a sheet of paper The rectangular postcard must follow the dimensions below: 4-1/4 inches high x 5-1/2 inches long The dimensions of the paper they will print on are: 8-1/2 inches high x 11 inches […]
Powershell
Using the values from a CSV file - Hi, I want to load a log so that I can see which bat file failed, and restart from that point.  I'm struggling a bit with this, can anyone point me in the right direction? So far I have got: $csv = Import-Csv E:\Backup\Schdule_log.csv $csv $Failed  = $csv.Batfile | Where-Object {$csv.Result -eq 'Failed'} But $Failed […]
Analysis Services
SSAS Remote Access - Hi all, I've been using Power Pivot and Power BI for some time and I have recently started rebuilding my data model in SSAS. I hadn't used SSAS before but I read about it a lot and saw some serious advantages. All those advantages are as good as I hoped: Partitions, Detail Rows expressions, etc. […]
 

 

RSS FeedTwitter

This email has been sent to {email}. 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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -