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

Daily Coping Tip

Learn a new skill from a friend or share one of yours with them

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.

Cloud First Software

Watching the evolution of SQL Server and the Azure SQL Database (ASD) variant has been interesting across the last decade. For a long time, ASD felt crippled compared to the on-premises product. The last few years, however, it seems that ASD is getting features first, which then slip into a release that I can download and run locally. It's a cloud-first database now, even though there isn't parity with both products.

In my career, I've worked with a number of platforms in production environments. One of those is Db2, though that's often felt like a legacy platform. I've rarely seen users starting new projects on DB2, though they might add some new databases, especially on AS/400, mainframe, or Linux platforms. I never thought Db2 was less capable than other choices, but I just don't see it used very often.

There's an article that notes IBM is moving to a cloud-first version of Db2, where there will be a cloud version coming first, then "traditional" releases. I assume this means a model similar to ASD and SQL Server, which makes sense. It's much quicker to develop and deploy to the cloud, and test things behind feature flags with a limited audience. Those items that work well can then be bundled up for a versioned release on-premises.

I don't know that I think Db2 will gain a lot of market share beyond what it has with this announcement, but it does make me think this is the model that a lot of companies will adopt if they even sell software for download. Most companies seem to want to move to a SaaS (software as a service) model where they can "rent" you access to code rather than deal with the struggles of supporting an install on your machine with who-knows-what configuration.

I get why this is attractive to companies. I also get the struggles of consumers. For some things, sure, I'll rent access. Music makes sense. Some software makes sense, but others worry me. Already I can see that companies that control the data, and its format, might be poor choices for consumers. If I don't like your software, can I still get whatever data I have stored with you? Is there any way to port this to another system?

I don't want to see regulations deciding how data and software should be implemented, but I would like to see some contract requirements with consumers that ensure the ability to leave a platform. Companies ought to be required to provide a way to extract out data into a common format, allowing me to move my pictures, tax data, sales records, health data, etc. to a new provider if I choose.

This is often easy to do in databases, and many people know how to extract data. The harder problem becomes when higher-level vendors, those building applications, want to use proprietary formats. I don't mind that, but I do mind not being able to extract my data if I choose.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Basic Checks on a New AWS RDS SQL Server

Br. Kenneth Igiri from SQLServerCentral

When you first become responsible for a new RDS instance, what do you do? Kenneth Igiri gives you a few queries to get you started.

External Article

Oracle optimizer Or Expansion Transformations

Additional Articles from SimpleTalk

The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some ways to an inverse for “Or Expansion” and “Join Factorization”. In this instalment, it’s time to take a closer look at Or Expansion and we’ll move on to Join Factorization in the next instalment.

External Article

Webinar | Test Data Management

Additional Articles from Redgate

With the average data breach costing $4.35 million, Test Data Management (TDM) is crucial. In this session, we’ll demonstrate how TDM can reduce your risk by achieving scalable compliance without slowing down your database development process. Watch on demand now.

From the SQL Server Central Blogs - PASS Summit 2022 - Day 2 In Pictures

@DBA_ANDY from Nebraska SQL from @DBA_ANDY

Day 2 of Summit 2022 started earlier than usual with the "Breakfast with the Microsoft team: SQL Futures and Strategy" - the food was good and the conversations with...

Blog Post

From the SQL Server Central Blogs - In SQL Server 2022, set your transaction log file autogrowth rate to 64 MB

Will Assaf from SQL Tact

A late-breaking change that arrived in SQL Server 2022 is an important one that could be a new line item in your health checks.
The basics:
Starting with SQL Server 2022,...

 

 Question of the Day

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

 

Assigning a Server Role

I want to create a new Server Role for my SQL Server 2019 instance, but I want another server principal to own this role. What should I do?

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)

DML Trigger Limits

I am writing a trigger in SQL Server 2019 on a partitioned table. When certain data is inserted, I want the trigger to switch partitions on the table. Can I do this?

Answer: No

Explanation: An ALTER TABLE that switches partitions is not allowed in a DML trigger. Ref: CREATE TRIGGER - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-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 2016 - Development and T-SQL
Null value when checking unused indexes - I'm using this query to check if I have any unused indexes.. One of the tables it display's has lots of user_updates but the indexname field is NULL... There is a non-clustered index on the table No fill factor and page fullness about 50% and 98% fragmented. Min row size 42 and max 74 avg […]
Degraded performance with extended event session - We have noticed that our nightly jobs take 2-3 times longer when the following extended event session is running. There is a clear deterioration in server performance across two separate servers running the same XE, even though there is not much data being written to the target files by the sessions (only a few MB). […]
Administration - SQL Server 2014
Replacing Physical Server - Hi We are going to update our old SQL physical servers to brand new machines. In the planning in my head stage but need some advice. Thinking I can setup the new hardware with the exact same OS, SQL version, instance name but with a different server name. Then when the new server is setup […]
SQL Server 2012 - T-SQL
mdf space balance - I have a DB that is running out of space on a drive... If I add another data file will the drive that is running low run out of space, or will it use the new data file just created. How does it balance data consumption. Thx.
Using Case with DATEDIFF for Aging Report - I need help to create a Aging report, I am not retrieving the correct amounts. I am wondering if I need add debit and credit first and then the dateiff
SQL Server 2019 - Administration
Is it best practice to change the password for distributor_admin? - Hello, Our audit team has decreed that all logins should password policy turned on for all SQL Server logins. They also decreed that the login password needs to be 32 characters. I found the command to change the password:  sp_changedistributor_password The question that I have,  is this something that is going to break my replication? […]
SQL Server 2019 - Development
Multiply time by hourly rate - Hello all, I have this table with time for each row. It shows hh:mm. I have rows with all kind of time, 6:30, 5:10, 5:00, 6:42 etc, and I have to multiply it by the hourly rate. Could you please help me? I think I have to, first convert this time column into a number […]
Compare 2 tables and highlight where the column values has been updated - Hi All, I have a requirement to compare data from same table with different snapshot dates and highlight what column values changed from to TO Can any one help me with above requirement please?   Regards, R
Best primarykey and index - Hi all, i've to refactor a database with several tables with around 100.000.000 records each one. Each table has the following relevant columns: - ID (bigint) - Tenant (actually i have 10k tenants) - Year (all info has Always a filter search by year) - other 10/20 simple columns I was thinking to have: 1) […]
stored procedure not running - Created a stored procedure and logged in SSMS as Administrator and this user is exists in the Security > Logins I'm able to successfully execute the sp using T-SQL. e.g, declare @output_execution_id bigint exec dbo.int_Bill_Run @output_execution_id output Now, when I add it SQL server agent as a job I get errors - Executed as user: […]
Azure Data Factory
API Configuration help ADF - Hi I am trying to connect to a HR system to simply pull down some data and copy in ASDB I have managed to get it to work in excel using the following code below in the advanced editor but dont even know where to start in terms of where i put this information in […]
Reporting Services
Empty Field is causing entire Page to be blank - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […]
Empty Field is causing entire Page to be blank - I'm a little new to SSRS and am running into a strange issue. I have a Table tied to a data source. Essentially, it is just a letter with text and two fields from the dataset ([Salutation] and [FullName]). The [Fullname] is a field that defines the Associate for the record and it may be […]
Powershell
Retrieve Password from CyberArk using powershell - Hi, I am new to Powershell script and i have to create a power shell script to get password for SQL service account from CyberArk.. Could you please suggest how to do that ?
Integration Services
Retrieving Active Directory information - I have a requirement to process AD information through an SSIS package and have hit a problem with the "objectClass" attribute. The ADO.NET source is configured as: and the package has converted all of the output data types to NTEXT. This isn't an issue for most of them as I've converted them to DT_STR using […]
 

 

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

 

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