SQLServerCentral.com Community Update for June 21, 2023

Problems displaying this newsletter? View online.

Featured Contents

Question of the Day

Managed Instance Managed Log Backups

The Voice of the DBA

Who's Responsible?

This editorial is being republished as Steve is out of town. It was originally published on Aug 29, 2017.

In college and for a short time afterwards, I worked at restaurants in various capacities. I've held most of the jobs available and enjoyed my experiences. I had good and bad bosses and sometimes had to endure questionable practices from management. Often I needed money, so I couldn't take a moral stand and was at the mercy of some manager. I think a bad restaurant manager at a part-time bartending position eventually caused me to choose to leave that industry. With a fulltime day job in technology, I could forgo the extra weekend money to avoid additional stress.

Bad managers and practices still exist, and I was reminded of this in an article recently. The practice of forcing employees to pay for mistakes is blatantly illegal, and I hope someone gets a few days in jail as a result of the case. However, I started to wonder if this trend might ever make it to our industry. Especially with the changes in services as more systems move to cloud environments.

I've worked in companies that debated my expense reports, and refused payment for some charges. Some of your might have had the same experiences, which often cause you to be very cautious about future expenditures. That could be good or bad for business, but it certainly is a problem for the employee.

These days I find plenty of employees that will setup or provision some cloud service using their own credit card, expecting to be reimbursed at the end of the month. What happens if the company doesn't want to pay? A manager decides the service wasn't necessary. What would you do? What if you provision the wrong service, or forget to terminate something. These are common mistakes in business, but would you pay for the mistake? What if you didn't pay for the service, but the company wants to deduct the charges made by mistakes from your paycheck. Do you fight this? Bring a lawsuit? Plenty of possible actions might ensure you aren't financially penalized but could cost you your job.

I'd like to think that this wouldn't be an issue for salaried, technology workers, but I wonder. Is there any reason to worry? Let me know what you think.

Steve Jones - SSC Editor

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

Featured Contents

How to Avoid N+1 Queries: Comprehensive Guide and Python Code Examples

rohin daswani from SQLServerCentral

This article describes the N+1 problem that we often find when developers use row by row solutions for querying related data in a database.

First speakers announced for Summit 2023

Additional Articles from Redgate

Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year.

The SELECT Statement in Oracle

Additional Articles from SimpleTalk

The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of criteria. In this article, I will introduce the basic SELECT statement fetching data from just one table.

From the SQL Server Central Blogs - What is Always Encrypted and how does it work?

Matthew McGiffen from Matthew McGiffen DBA

Always Encrypted was a new encryption feature added to SQL Server with the 2016 version of the product. Initially it was just available in enterprise edition, but from SQL...

From the SQL Server Central Blogs - Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS

Meagan Longoria from Data Savvy

One of the nice things about the Microsoft Connector for Oracle is that it doesn’t require installation of an Oracle client. But because of this, you may not have...

Question of the Day

Today's question (by Steve Jones - SSC Editor):
	Managed Instance Managed Log Backups
I have an Azure SQL Managed Instance in May 2023 with one database. Microsoft is managing my log backups as part of this PaaS service. How often are they backing up logs?
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)

The JSON Table

Which JSON related function returns a table?

Answer: JSON_OBJECT(), OPENJSON()

Explanation: OPENJSON() returns a table. The others return a JSON object or array. Ref: OPENJSON() - https://learn.microsoft.com/en-us/sql/t-sql/functions/openjson-transact-sql?view=sql-server-ver16

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

Availability Group database went into 'Restoring' state - Dear Friends, Please advise why would one of my Availability Group databases go into 'Restoring' state. Thanks in advance.

Administration - SQL Server 2014

Display columns from multiple rows in single - Hello, Im looking for assistance. I have this query and need to display the results in a single row. select System, CONVERT(varchar(12), DATEADD(minute, DATEDIFF(minute, [Run Start Time], [Run end Time]), 0), 114) As 'Total hours' FROM [dbo].[Prod_ShiftSummary] where office = 'Dallas' and [Run end Time] >= DATEADD(day, -7, GETDATE()) and oven = 6 group by […]

SQL Server 2019 - Administration

Reset launchpad service to use default account - I have an issue with SQL Server Launchpad service. Initially it wouldn't start (configured to use "NT Service\MSSQLLaunchpad$") but on changing it to the domain account which runs the SQL Server service it starts without issue. I'd like to change it back to the default to see if it still works after doing so but […]

Can't Restore DB - hi everyone I need to get a copy of a stored proc from backup b/c the one I am using in my current instance of the db isn't correct. I am not able to restore the db. What am I doing wrong? The name of the db is OptionsDB and I want to keep the […]

partitioning a huge table - Hi folks I would like to get your views about partitioning a huge table in sql server .Around on size of 100 gb.Beofre i present this idea to upper mnmgt i would like to have your inputs .I am of view that since there is only 1 dedicated disk for data files (mdf/ndf) there is […]

SQL Server 2019 - Development

How Can I Speed This Query Up? - Hi everyone My SQL query is close to 1000 lines with 17 separate calcs (ie sub-queries). The entire query takes almost 3 minutes to run. This is way too long. I figured out the problem area. It turns out that 70% of the time is spent on 2 subqueries. Each is the same except that […]

puzzeled with "exec sp_cursor 180150007,40,1" - I've noticed in one of our applications a cursor uses operation 40 and that operation is very slow. This handles a table with 62 rows with images ( most < 500KB , but some (5) > 2MB ) MS Docs sp_cursor describe optype, but I cannot actually get my interpretation around as to why this […]

Not wanting to use a Cursor, but... - Ok, need someone to talk me off the cursor ledge on this one. I have some train stop data that I need to accumulate the number of riders for, over a time when the train is heading in one direction, on a specific day. The data is all stored on a yearly basis, so I […]

SQL Server 2008 - General

how to determine if we can delete the index can be removed - In SQL Server database, there is a table InventDim with two indexes: Idx1 with index columns (DataAreaID, BatchID) and Idx2 with index columns (DataAreaID, BatchID, InventSizeID). Is it possible to drop Idx1 if Idx2 already exists and covers all the columns in Idx1? thanks a lot!

how to determine if we can delete the index can be removed - The table InventDim has some indexes, we create one index idx1 which has index column f1 and f2, and creating index idx2 which has index column f1、f2 and f3, index column sequence of idx1 is same with idx2, means the index columns of idx1 totally are included in idx2 and the sequence of index column […]

SQL Azure - Administration

Azure Datawarehouse or SQL Pools and profiler equivalent... - I added the Profiler module to AZure Data Studio in our ("Microsoft Azure SQL Data Warehouse ) env to monitor performance memory / disk, etc just as I've done with SSMS profiler for years.. I know I 've used it before on another Azure product, but for this I get: "An exception occurred while executing […]

Reporting Services

Changing a datasource using T-SQL Script - I've been looking for a way to change multiple data sources for reports to a different data source. Is their a T-SQL Script that can accomplish this?

Integration Services

You have an error in your SQL syntax; check the manual that corresponds - I am having great trouble creating a data pipeline using MariaDB connector 3 with SSIS/Mysql connector 8. I can view the tables, but it gives me this error: "TITLE: Microsoft Visual Studio ------------------------------ ERROR [42000] [ma-3.1.18][10.4.24-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the […]

SQL Server 2022 - Development

SQL Website Development: A Comprehensive Guide to Building Dynamic Web Applicati - Introduction to SQL Website Development What is SQL? Importance of SQL in web development Understanding Dynamic Web Applications Definition and examples Benefits of dynamic web applications SQL Database Management Systems Introduction to DBMS Popular SQL DBMS options Setting Up the Environment Choosing a programming language Installing a web server and database Creating the Database Structure […]

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.