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

Daily Coping Tip

Remember that you are not alone, we all struggle at times

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

Real World DevOps

One of the more interesting aspects of my job is talking about building software with customers. As I do more of this over time, the discussion have changed from "what is DevOps?" to "how do we get started in DevOps" to "how do we improve our DevOps process?" These days so many customers have bought into some aspects of DevOps that the last one is quite common. There are still a number of companies trying to get started with DevOps in some way, but very few people I speak with have no idea of what DevOps is or how why it can improve your company.

Of course, I'm not sure there's a great standard definition of DevOps. I often lean towards Gene Kim's Three Ways or Microsoft's broad view of the principles. Ultimately, most of the practical things that I find myself discussing are how to smooth the process of integrating code from developers and getting it transferred to production. Everyone wants this to go smoother, with mistakes caught earlier, and with compliance with whatever internal rules, regulatory mandates, and customer demands exist.

Grant had an interesting conversation with a few customers recently and wrote a blog about the conversation. There are a few items that resonate with me, and things that I like to emphasize to customers. The experiences from Stuart and Chris are common in any journey to improve your software process.

People need to test and measure. While testing has gained traction in the application development world, it's still fairly new to database people. However, as people try to reduce mistakes and problems, often from simple issues, they adopt more testing. They also start to realize that having instrumentation to help measure the impact of changes is important to learn what to test and watch out for.

Starting small is important as well. While there are many, many commonalities in all my customers, the way they solve these with their teammates, and the order in which they solve them, varies. Even if you were to end up with the same VCS, build process and deployment script as someone else, the journey will be different. The challenges from internal people and processes, the evolution of habits in your team with vary. You need to find your own path.

So start small, with a few people, let them learn and then teach others. Let them build up knowledge, habits, and skills that others can adopt. That's how most things work in the world. A few people discover something and then many follow their footsteps. If you want to build a better software process, find someone to start doing it. When they find something that works, the rest of the organization can stand on their shoulders.

Steve Jones - SSC Editor

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

 
 Featured Contents

Calling a Stored Procedure from PowerShell

FrankDolan77 from SQLServerCentral

This article will explain how to use PowerShell to call a stored procedure and export results to the screen or a file.

New release: Redgate Change Control now integrates with Git

Additional Articles from Redgate

In Redgate Change Control v3.0, you can now commit your database changes to your local Git repository and collaborate with your team by pushing and pulling changes from the remote Git repository. If you’re using branches, you can also create and switch Git branches from within Redgate Change Control.

SQL Server Management Studio Connection to Integration Services Error Class Not Registered

Additional Articles from MSSQLTips.com

In this article we look at some reasons why you cannot connect to SSIS using SQL Server Management Studio and how to solve the problem.

From the SQL Server Central Blogs - Probing Columnstore Indexes

Brahmanand Shukla from SQL Server Carpenter

This article was first published on: 2020-03-14.

This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics.

We'll cover examples...

From the SQL Server Central Blogs - Color Coding a Database on All Servers with SQL Prompt

Steve Jones - SSC Editor from The Voice of the DBA

SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this,...

 

 Question of the Day

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

 

Resetting Filegrowth

I am using the ALTER DATABASE command to change  the filegrowth settings for some files in my SQL Server 2019 database. What options do I have to specify the scale of my filegrowth?

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

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Offline Files

I have multiple files in a filegroup in my database.  There are two filegroup: Primary and Archive. The FGARchive file is located in the Archive filegroup. I decide to run this code:

ALTER DATABASE FGTest MODIFY FILE (NAME = N'FGArchive1', OFFLINE)
GO

What happens?

Answer: The file is taken offline

Explanation: The file is taken offline, but not the database or filegroup. You can see this status in sys.database_files. Ref: ALTER DATABASE - https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-file-and-filegroup-options?redirectedfrom=MSDN&view=sql-server-ver15  

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 - Administration
Logshipping - I have  a requirement  to configure logshipping on  a database , where mirroring is configured . i need to setup the logshipping to the primary database   which is in mirroring . But multiple secondaries on the same secondary instance with diferent names  of the primary database . as the sql is ql 2008 vesrion. how […]
ExecuteScalar: CommandText property has not been initialized - One ASP.NET project keeps on receiving a message below from "Try...Catch...End try" block. System.InvalidOperationException: ExecuteScalar: CommandText property has not been initialized I searched Google but can't get help. Is this SQL script mistake? Please help. --------------------------------------------------------- It points at a function from app below dim iCount as Int32 = 0 dim SQL as string = […]
How to stop database restore that survived reboot showing progress in error log - SQL Server 2016 SP CU7 on Windows Server 2012 R2 Standard.  Backstory: Agent job runs daily that performs restore of database in about 30 minutes (360G MDF).  All of a sudden one day restore still running hours later.  Waited it out.  Ran in 18 hours then several hours later early morning restore ran as normal.  […]
using Powershell scripts to do SQL backups - Hello, hopefully this can be a straight forward question, but at the same time, looking to get some advice and if possible experience from someone that tried this... but as the title says, My company has large databases, about 1.5 tb, and dont want to invest in software, but of course we do have good […]
SQL Server 2016 - Development and T-SQL
CONCATE_WS Not Recognizable - I am trying to use the CONCATE_WS function in SQL Server 2016 but receive the following error.  Here is my code and the error.  Why is this not working and is there a fix?  I need to be able to separate the concatenated columns.  Intellisense will pick CONCATE_WS up as a selectable option as I […]
Query plan for scalar UDF not displaying in my execution plan - Hello, I am running SQL Server 2016 SP2 with 130 compatibility mode. SSMS version 18.5 My understanding is if I run a query that calls a scalar udf, my execution plan  will have a double-pane, with the top pane having my exec plan with the Compute Scalar operation.  And there will be a bottom pane […]
Need Help to write a query - I have a table like this I need to write a query to get the following output Columns Tenor, 0, 0.5, 1, 1.5, 2, 2.5, 3, ....... , 10 (0 to 10) Sum of Count of  Col A and Col B where Col values are >= the abs values of the columns   For 0 […]
Nested FOR XML Problem - I have the following data and I want to generate XML where the transactions are nested under the position for the relevant asset. CREATE TABLE #temptable ( [bp_sym] varchar(50), [person_key] varchar(100), [bargain_date] date, [disp_acqu_text] varchar(9), [quantity] decimal(12,2), [cumulative_qty] decimal(12,2), [book_cost_change] decimal(12,2), [cumulative_book_cost] decimal(12,2), [swim_refs] varchar(6), [security_code] char(7), [asset_name] nvarchar(4000) ) INSERT INTO #temptable ([bp_sym], [person_key], […]
SQL 2012 - General
Configure logshipping - We have a requirement to configure logshipping  on a mirrored databasé on sql 2008 server ,also to configure the  lògshipping for multiple databases  on the same secoñdary server.how can we coñfiguré.  
Run same query on multiple servers with sqlcmd and save the output - Hello, I have this 3 lines: sqlcmd -S "Server1" -d -U -P -i query.sql -o result.txt sqlcmd -S "Server2" -d -U -P -i query.sql >> result.txt sqlcmd -S "Server3" -d -U -P -i query.sql >> result.txt If I copy and paste this code to a cmd […]
SQL Server 2012 - T-SQL
Merging date based on start and end date - I have tried to group/merge dates (Min/Max) but due to same data at line 1,2 and 4 , its not working as expected. Thank for looking into it. create table #Temp ( ID INT, Status_ID INT, StartDate DATE, EndDate DATE ) INSERT INTO #TEMP SELECT 101,1,'01/01/2020','01/28/2020' UNION ALL SELECT 101,1,'01/29/2020','01/31/2020' UNION ALL SELECT 101,5,'02/01/2020','02/29/2020' UNION […]
SQL Server 2019 - Development
create view out of dynamic query from INFORMATION_SCHEMA.COLUMNS - Hi, Is there a way to create a view out if this query below? DECLARE @query nvarchar(max) SELECT @query = STUFF( ( SELECT ' UNION ALL SELECT ''' + TABLE_SCHEMA + ''' AS SCHEMANAME, ' + '''' + TABLE_NAME + ''' AS TABLENAME, ' + 'LEFT(''' + TABLE_NAME + ''', 3) AS SYSTEM, ' + […]
Reporting Services 2005 Development
Average in a Matrix - Hello I'm using the Matrix Wizard and everything is working right except one total that I modified.  See image: The detail columns total at the bottom and along the row without any problem. But in my last column 'Avg FTE' I'm trying to get an average. The average works across the row, but not at […]
SSDT
SSIS Expression help - Hi Guys,/ Is anyone can help me convert this SQL to SSIS Expression? SELECT DATEADD(DAY,DATEDIFF(DAY,0,CONVERT(DATE,DATEADD(WK,DATEDIFF(WK,0,GETDATE()),0) - 8)), '00:00:00') Thanks in Advance.  
Design Ideas and Questions
Columnstore Index and Nonclustered Index on Table - We have a table definition below with a columnstore index and nonclustered row indices. The data in this table increases 10K per day and in a year can have 400K ColNumber with each having 1 to many ColProperty. This table will be used mostly for reads/reference and hardly have updates. Would it be beneficial to […]
 

 

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

 

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