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

Daily Coping Tip

Eat healthy food and drink lots of water today

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.

DevOps in Space

Some of the early science fiction books I read were by Robert Heinlein, often including rocket ships and space travel. These days I'm uninterested in actually going to space, but I am excited by the prospect of the efforts being made to send others. It's an exciting time to be interested in travel off of this planet.

One of the headline makers is SpaceX, which has had quite a bit of success launching reusable rockets carrying all sorts of cargo. My son was very interested in their work as an 18 year old, and I still remember taking him to Cape Canaveral and watching the first first rocket launch and land at the facility. An exciting time for us.

SpaceX has adopted a DevOps attitude towards their physical rockets, adapting and iterating quickly to improve their designs. The pace of progress is quite interesting, analogous to how some companies have changed their software development lifecycle practices, becoming quite adept at building and improving applications in a rapid fashion. Alex Yates draws some parallels, and includes lots of fascinating rocket information, in this post on the Octopus Deploy blog.

One of the big challenges I find with changing software development is that we struggle to let go of old practices. Even as we look to iterate, often we are unable to accept risk, and we often want to stick with the "always done it this way" for some things. While we might accept some changes, we don't accept others, and may even cancel out the benefits of automation improvements with a lack of willingness to adapt our culture.

I do hope that other companies challenge SpaceX, and learn from them. Ultimately we do better with a competitor that forces them to continue to improve and not rest on past success. The same is necessary for software development teams to continually improve. If your organization is stuck in a rut with software development, request (or push) for a team to try something new. To adopt and grow with DevOps. Make them prove they can build, deploy, and operate software in a better way. Then challenge other teams to try and adopt their ideas, and then improve upon them over time.

Steve Jones - SSC Editor

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

 
  Featured Contents

Understanding the Internals of a Data Page

Mohsin_A_Khan from SQLServerCentral

In Part 1 of this series, we examine the structure of data pages and how your tables are stored on these pages.

Have your say about PASS Summit 2021

Additional Articles from Redgate

Redgate has committed to organizing a free virtual Summit for the PASS Community this fall. To help guide the format and provide you and the data platform community with the best virtual event experience possible, we'd appreciate your input. As a thank you for your feedback you could win a Peloton Bike or $3,000 (the equivalent in your local currency) to donate to your chosen charity.

Export SQL Server Data to Excel and Add New Columns with C#

Additional Articles from MSSQLTips.com

Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.

From the SQL Server Central Blogs - Become a Contributor to Microsoft Docs

Will Assaf from SQL Tact

Starting this month, I'm leading a talk series with my teammates from the SQL Docs team at Microsoft. In this presentation we lay out just how easy it is,...

From the SQL Server Central Blogs - Help Build an Amazing Summit in 2021

Steve Jones - SSC Editor from The Voice of the DBA

For a good portion of my career, I’ve been going to the annual Summit in the fall with lots of my fellow SQL Server/Data Platform professionals. I have been...

 

  Question of the Day

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

 

Preventing Trigger Execution

In SQL Server 2019, I need to alter some data in a table. However, there is a trigger that I do not want to fire for this data modification but I need it to fire for future changes. What is the easiest way to accomplish this?

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)

Password Policy

How is password policy, as enforced when this is set for a login in SQL Server, changed?

Answer: By changing the policy locally or in the domain that is checked by the NetValidatePasswordPolicy API

Explanation: When this is checked, passwords are checked against the NetValidatePasswordPolicy API. Ref: Password Policy - https://docs.microsoft.com/en-us/sql/relational-databases/security/password-policy?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 2017 - Administration
SQL Express Backups ? - Without a 3rd party tool, what's the best way to backup SQL Express, not having SQL Agent ? A Windows Task Scheduled to run a backup script, and delete old backups ?
Admin Permissions...Or Not - A vendor installed SQL 2017 Express on a new server. I am in the Windows Administrator group, but do not have access to anything useful in SQL, when I RDP onto the Server.. Computer_Management -> Groups -> Administrators -> DomainName\MyName What are some reasons I would not have access ?
SQL Server 2017 - Development
Sort Query by Data from another table - Hello: What is the best way to sort a query based on defined priorities in another table. I have my main 'Schedule' table here... And I want to sort the WorkCenterID column by the values in this table, 'Operations'. I am playing around a little with Joins, but I'm not even sure I'm on the […]
SQL Server 2016 - Administration
NT AUTHORITY\SYSTEM Schedule Backups - SQL 2016 EXPRESS - Hi I'm trying configure best backups pratices in Windows server 2019 using sqlcmd in Windows Schedule Tasks with NT AUTHORITY\SYSTEM account, but it's not working... It only works if a setup this account with sysadmin role, if I setup only with public role I get this error: Msg 229, Level 14, State 5, Server […]
Moving database files to another drive - Hi all   For background, we ave two servers (DEV and PROD) and they are set up slightly differently. On DEV, the mdf files are stored on the E: drive, on PROD the mdf files are stored on the D: drive.   What I'd like to do is change the drive on the DEV server […]
Huge size of Reporting tables - Hi All We have a DB for reporting which has tables which are more than 5 TB in size. As the business grew, we reached at these sizes. These tables have 1 month worth of data and we need this much data to generate many of our reports. So we can archive or purge these […]
sql backup for big database in 4 steps - Hello,   Can someone help me with code for sql backup for big database in 4 steps so it will not take a long time to do a back up. Thank you
SQL Server 2016 - Development and T-SQL
COUNT(ID COLUMN) not using Clustered Index - Hello SSC, Ok, so I have a table that has a 1 Clustered and 1 Non-Clustered Index. PK Clustered Index is simple, just CustomerID, unique, straight forward. Non-Clustered is a combination of 3 columns that do not include CustomerID. When I run... SELECT COUNT(CustomerID), the execution plan shows that it is hitting the Non Clustered […]
SQL 2012 - General
Msg 537, Level 16, State 3, Procedure Recover_Truncated_Data_Proc, Line 113 Inva - I work on sql server 2012 i call procedure name as below EXEC Recover_Truncated_Data_Proc 'Nahdy','dbo.Student' I get error Msg 537, Level 16, State 3, Procedure Recover_Truncated_Data_Proc, Line 113 Invalid length parameter passed to the LEFT or SUBSTRING function. so How to solve this issue please this table dbo.Student USE [Nahdy] GO /****** Object: Table [dbo].[Student] […]
SQL Server 2019 - Administration
Execute a script on the Azure Database - I am trying to execute the script below on an Azure database, I am doing because the scripts file is big i scripts schema and data from another Azure database. I I have the script above, I need to run on my Azure Database but is is giving error that you must specify an elastic […]
How to create a SQL clusters in oracle? - Hello Iam a Newbie, can you guys help me out that how to create SQL Clusters in oracle? Help appreciated Thank you
MS Server Management Studio 2018 - I donwload the above with the Azure Data studio and it does not contain a connection console to the database. Please assist? I got it from here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
SQL Server 2019 - Development
Need help on my SQL - Hi there, I need help to use SQL to pull data from SQL Server and feed it to Tableau as data source, but I am stuck and not sure what to do.  Here is the requirements for the report. Assume I run the report on Tableau dashboard today (04/08/2021) (Note: user can select the report […]
Entry point in sysdatabases - Newbie to this .. will learn .. am motivated. When I do a script for creating a new database I get this error: Could not locate entry in sysdatabases for database (the name of the one I wish to create.) I do not understand why I must have a name for my new database in […]
SQL Server 2008 - General
Top 5 by user query - Hi All, I want the earliest 5 distinct dates for each user. I know I can row_number() over partition by user order by date, but there are a lot more than 3 users and a lot more than 12 dates. I'm having a moment here, and I'm pretty there's a much simpler solution. This will […]
 

 

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

 

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