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

Daily Coping Tip

Create a list of favorite memories you feel grateful for

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.

No Excuse to Ignore the Database

I've been writing, talking, and practicing DevOps for nearly 20 years. It wasn't called DevOps back then, but in the early part of this millennium, I worked in a software team that embodied many of the three ways of DevOps.  We made small changes, we worked rapidly in short cycles, we adapted to our business needs, and we released often.

And we included the database.

At the time, this was a small team of about 15, and I had good control of the database processes, able to influence, debate, and demand our developers improve their skills regularly. We didn't think about the database as anything more than one more challenge to overcome in order to build and release our software rapidly. Others feel that way as well and the ACM notes that a SQL database is no excuse to avoid DevOps.

This articles covers many of the things I've been preaching for some time. We use automation, we adopt good techniques, we instill discipline in our work, and we continuously improve. The article provides a few techniques for using deploying database changes. I do think some of these are good ideas, but as with many things, the devil is in the details. This is a high level look at what you want to accomplish, but the actual mechanism for making changes will vary, depending on your environment.

My employer is constantly searching for ways to improve database development, and we follow many of these techniques in principle. We recognize that testing and deploying changes needs to be easier and more reliable. As we build solutions, I think we've helped customers in many ways, however, my fellow advocates and I continue to preach a few things not in the article.

First, we need to continue to improve our code skills, which include data modeling. Moving faster doesn't mean we get to shortcut good design principles. Second, everyone working on software touching the database needs to work closely together. The data is the most important part of this process, and we can't afford to let anything happen to it.

I implore you to become better code writers, better software developers, and better team players. I also encourage you to look at DevOps as a set of principles, not as something you buy or install. Like much of life, adopting DevOps is a journey, just like your work with SQL. I'm sure that journey isn't complete.

Steve Jones - SSC Editor

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

 
 Featured Contents

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

Cláudio Silva from SQLServerCentral

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

Understanding Views in SQL

Additional Articles from Database Journal

Learn about the concept of views in SQL, and how they work. Read on to see clear examples of how to implement views.

SQL Server Licensing and SQL Monitor

Additional Articles from Redgate

How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use SQL Monitor to find out.

From the SQL Server Central Blogs - Power BI Monthly Digest – June 2020

Devin Knight from Devin Knight

In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.

From the SQL Server Central Blogs - End an ALTER DATABASE immediately if anyone is in the database.

Kenneth.Fisher from SQLStudies

The development team has told me they’ve shut down the application, there are no more connections and I can go ... Continue reading

 

 Question of the Day

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

 

The A in ACID

What does the A in ACID stand for when related to relational databases?

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)

Azure Serverless Compute Cost

If my Azure Serverless database is paused from no activity, do I incur a compute cost?

Answer: No

Explanation: There is no compute cost when the database is paused. Ref: Azure SQL Database serverless - https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

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
Query XML for Dummies - I am trying to learn Extended Events & XML. I created and E.E. that captured my running SP_WHO2. But how do I query the E.E. file to find it ? I ran this, just to find my record, but what's the "Correct" way to query my file to search for Stored Procedure calls, or table […]
SQL Server 2016 - Administration
error while installing ssrs2016 - I'm trying to install ssrs2016. while instantiating i get the error RPC service not available . I can see that the RPC services are running. on some sites it mentions  that this more of firewall or network error No changes can be made to them Has anyone faced such an error Regards Atulyan Padmanabhan   […]
How to sync Always on AG in primary site with Always on AG in DR ? - The primary site has 2 database servers connected to a SAN. both nodes running on SQL server 2016. Both the servers are configured to function as an always on availability group as opposed to a Fail over Cluster. The DR has an identical setup; 2 nodes, a SAN. both nodes configured as an always on […]
SQL Server 2016 - Development and T-SQL
Temporal Table Reporting - Hi All, I have inherited a database which has a number of system versioned (temporal tables). One of the things I have been tasked with is to create a report which basically shows what has changed across the entire database (i.e. Audit), not just a single table. Is there an efficient way to generate a […]
SQL bulk insert unique rows from a parent table to multiple child tables - I have a table Locations whose schema is below. I want to select all unique rows from the Home table and **bulk** insert into locations and individual table **Home Table** - Id (identity) - LocationGroupId (can be null) - IndividualGroupId (can be null) - Address - City - State - Zip - FirstName - LastName […]
Get current and previous week sales - Hi, I have a FactBooking (BookingDateKey, Amount, Qnt) and a dimension DimDate(DateKey,Year,Month,WeekNumberOfYear) tables. Can you please let me know the sql to get the current and next week bookings? Thanks Subbu
Performance Impact of Multiple or many triggers on a Table - Hi All, I have one table in that 10 triggers are there, due to this, it takes more time while insert and updates record in the table. 1. For Insert triggers - 4 2. For update triggers -6 (On different columns). Can anyone know how to sort this issue? Can I merge triggers in one […]
Slow running proc on SQL 2016 with execution plan - The stored proc is running very slow on 2016 as compared to 2019. Its doing some common validation from a temp table and inserting data in primary tables and mapping tables. The mapping tables have clustered indexes on primary keys {Table1Id, Table2Id, Table3Id}. The proc needs to process around 4mill records. It finishes execution in […]
SQL Server 2012 - T-SQL
Better way to write this without the nested joins? - A BA recently ran this query and it got flagged by a capturing event for having > 130,000,000 logical reads.  Is there a better way to handle query can join back onto themselves?  What would make something like this more efficient?   SELECT 'Term Reversals' AS 'TERM REVERSAL', ev.employee_id, ev.ssn, e2.import_run_id, e2.string_value, e2.effective_date, e.import_run_id, e.string_value, […]
SQL Server 2019 - Administration
unable to connect to SSRS reporting dashboard from remote pc - Hi , i have an SqlServer 2019 server instance on which i have installed Ssrs services. I'm unable to connect via a remote pc and so i cannot see reports dashboard on my browser,obiovusly i can reach that locally. I have read a tons of forums in which i have found several possible solutions but […]
SQL Server 2019 - Development
Reliable practice tests and exam dumps for exam 70-761 (T-SQL Queries) - I have seen quite a few sites with exam dumps and practice exams.  Some websites even claim that the problems have been on actual exams.  When I read the "discussions" about the answers, apparently many of these are not providing the correct answer.  I don't want to end up accidentally learning something that is not […]
SQL Date filter/expression - Hi I have a report that uses a stored procedure but it wasn't built by me. It basically lists completed cases from our customer management system but I want to tweak the report to only show open/live cases. I have two fields: 'CaseOpen' and 'Case Completed' and I somehow need to use an expression/ filter […]
Recommend tools to trigger Stored Procedures - Hi,   I have three stored procedures, as below SP_Extract_Data SP_Load_Data_Into_Temp   SP_Load_Data_Into_Real_Table   I know there is available tools can use to call the stored procedures:- It can be applications such as C# Net It can be SQL Server Itself SSIS Or it can be create agent job to call   But beside of […]
Amazon AWS and other cloud vendors
Error creating AWS RDS Linked Server to Oracle - Hi, I am trying to create a linked server in AWS RDS to an Oracle Database. I created using the t-sql scripts as I could not find the list of Providers under the Linked Server in SSMS. And when I try to access it, I get EXECUTE permission was denied on the object sys.xp_prop_oledb_provider error. […]
Integration Services
Better Performance Using Stored Proc with OLE DB Source vs SQL Command Query? - I have numerous SSIS pkgs that I’ve written that run every 15 min to compare records in SQL Server tables with records in equivalently named tables in Oracle to keep both tables 100% identical in content. I have currently been using just standard “Select...” statements as the sources in the SQL Server and Oracle OLE […]
 

 

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

 

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