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

Part Time DBAs

Some of you reading this are database administrators (DBAs) who manage systems as their full-time job. Others of you might be developers, analytics people, or someone else who has another job, but you get stuck with managing the database somehow. We may call you the accidental DBAs, though that doesn't imply you are good or bad at managing databases. I got into this line of work as an accidental DBA who was also a developer.

No matter what your job title, my guess is that you aren't over-staffed at your organization. Likely you wish you had one (or more) more person to help keep up with the work. It seems that we never have enough time to get everything done in a week.

And that's with a full staff. What do you do when someone is sick or goes on vacation? If you're like me, you get further behind and feel extra stress while your coworker is out of the office.

There is another way, and I thought this piece had a great title: Having a Part-time Database Administrator Can Help Improve your Bottom Line. It's from DCAC, a consulting company that provides remote DBA services. There are other companies like this, such as Procure SQL, Straight Path Solutions, Dallas DBAs, and more. All of these companies are available to help augment or relieve pressure on your staff.

The piece makes a good argument that often your staff is busy and might not have some of the specialized training or advanced skills that might help solve complex performance issues, architect HA solutions, perform cloud migrations, and more. For many companies, it can be hard to acquire these types of skills, and even if you have a plan, it can be expensive. What if your expert is out of town, or what if you train them and they leave? I believe in training people, but I also know that you have to be able to augment your staff at times.

Using trusted partners to help you improve parts of your business is something companies do in many ways. We might employ a handyman, but would still hire an outside plumber for some work, especially if it is a large job. Why not do the same thing with your technical staff?

These companies might seem expensive when you look at their rates, but using them part-time, in strategic places, can often help your bottom line.

Steve Jones - SSC Editor

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

 
  Featured Contents
Technical Article

Level 5 of the Stairway to Synapse Analytics: create and use Delta Lake - Part 2

Sucharita Das from SQLServerCentral

This next article in the Stairway to Synapse looks at Delta tables and processing streaming data.

External Article

Killing a SPID and Checking Rollback progress in SQL Server

Additional Articles from MSSQLTips.com

From time to time, I encounter blocking situations where I end up issuing a SQL KILL command against the blocking SPID. When I run sp_who2, I can see the killed SPID is in a ROLLBACK state. Is there any way I can get an idea of how long the rollback for the SPID will take?

Blog Post

From the SQL Server Central Blogs - Call a Fabric REST API from Azure Data Factory

Koen Verbeeck from Koen Verbeeck

Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data Factory (or Synapse Pipelines). This can be done using a Web Activity, and most...

Blog Post

From the SQL Server Central Blogs - CHOOSE’ing a Beer: #SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use...

Admin Azure SQL Solutions

Exam Ref DP-300 Administering Microsoft Azure SQL Solutions

Site Owners from SQLServerCentral

Directfrom Microsoft, this Exam Ref is the official study guide for the new MicrosoftDP-300 Administering Microsoft Azure SQL Solutions certification exam.

 

  Question of the Day

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

 

The Long String

I have a table (dbo.beer) with this data:
BeerID BeerName brewer beerdescription
----------- -------------------- -------------------- -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 Becks Interbrew Beck's is a German-style pilsner beer known for its golden color, full-bodied taste, and a crisp, clean finish with floral and fruity hop aromas, brewed according to the German purity law
2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. The malt and hops are perfectly balanced.
3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste, followed by a well rounded malty middle, finishing with a nicely organic hop flavor. Locally sourced two row grain and a blend of specialty malts give our amber its rich taste.
4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer, meaning it's fermented slowly and at colder temperatures, resulting in a well-balanced, richly malty, and long-lasting flavor profile with a clean, pleasing aftertaste.
8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beer, which means it is fermented at low temperatures and offers a light and refreshing texture with a smooth and balanced flavor.
Here is the DDL For the table:
CREATE TABLE [dbo].[Beer] ( [BeerID] [int] NOT NULL IDENTITY(1, 1), [BeerName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [brewer] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [beerdescription] [varchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO 
I run this code:
SET TEXTSIZE 20; SELECT b2.BeerName , b2.beerdescription FROM dbo.Beer AS b2; GO
What is returned?  

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 User Login

When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?

Answer: a Windows AD account, a Windows AD Group, a SQL Auth login, or a Microsoft Entra login (email) only

Explanation: In the master database, these types of logins are supported as the basis for creating a user.

  • User based on a login based on a Windows Active Directory account. CREATE USER [Contoso\Fritz];
  • User based on a login based on a Windows group. CREATE USER [Contoso\Sales];
  • User based on a login using SQL Server authentication. CREATE USER Mary;
  • User based on a Microsoft Entra login. CREATE USER [bob@contoso.com] FROM LOGIN [bob@contoso.com

A user based on a certificate can't log in but can be granted permissions and can sign modules. Ref: CREATE USER - https://learn.microsoft.com/en-us/sql/t-sql/statements/create-user-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 - Administration
Changing Machine Type - Hi, presently my azure server running under Standard_D64ds_v4 .i am planning to upgrade the server . can you please help me what is next configuration .
SQL Server 2016 - Development and T-SQL
How to get result from deleted row - Hi Guys I have a store proc that delete a row from a and I would like to get the result of the deleted row whether be =1 or True in order to execute another store proc. Could this be possible? ---- I am aware this code won't work I am trying to explain what […]
Joining against min date only - This is one of those things very hard (for me)to explain in words. See image below, the requirement is assign all of the sales with Reqdate prior to the "Best Before Date"  but ONLY the earliest "Best Before Date." I am trying to do this only with T-SQL.  My full scenario is of course more […]
Union where it matches against only one shared column - Hi folks I have two tables, both with a NAME, START and END fields I'd like to list all of the rows from Table A, and then only the rows from Table B where only the START does not exist in Table A.  The NAMES in Table B will ALWAYS be different from those in […]
Administration - SQL Server 2014
sqlagent issue - could not find the procedure msdb.dbo.sp_get_sqlagent_properties agent not visible  
sql agent issue - getting this error. could not find the procedure msdb.dbo.sp_get_sqlagent_properties and also this error cannot find column msdb or user defined function or aggregate msdb.dbo.fn_syspolicy_is_automation_enabled  or name is ambiguous. how to fix this    
SQL Server 2019 - Development
what etl tool are folks moving toward? - Hi as we replace on prem machines , sometimes not with vm's, what should we be thinking about for etl? from my little corner of the world where we use both talend and ssis, and where talend is getting costly, and where ssis is slowly being squeezed into a call from data factory to an […]
How to update using data from three tables? - I am in the process of migrating from MySQL to SQL Server. I have tables like this: create table OldTable ( id int primary key, tagpath varchar(255), retired bigint ) create table DataTable ( tagid int not null, tagValue float ) create table NewTable( id int primary key, tagpath varchar(255), retired bigint ) The DataTable.tagid […]
temp table columns not showing up in CTE - I'm new to the development side of the house and stuck on a CTE issue. In the CTE data is pulled from a temp table. There was a request for more columns, so I added them. Everything works, but the columns don't show up in my CTE results? What am I overlooking here? Thank you […]
General
Count of Distinct Values - Hi If value is 21000030 it should return 4 not 5 . In first record 21000030 exists 2 times 21000032 then it should return 3 not 4. USE [Live] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OCRD]( [CardCode] [nvarchar](15) NOT NULL, [Emp_1] [nvarchar](10) NULL, [Emp_2] [nvarchar](10) NULL, […]
Analysis Services
SSAS Cube Migration to Azure cloud - Dear All, I am currently working on a Proof of Concept (POC) where I have developed an SSAS cube with an Oracle (On-prem) source and deployed it to the SSAS server. The SQL DBA team is now planning to migrate the SQL server to the Azure cloud. I would appreciate your suggestions and best practices […]
SQL Server 2022 - Administration
Sever Migration - Hi, one of my server configured with Standard_D64ds_v4 what is next level of version is it Standard_D98ds_v4 or Standard_D128ds_v4
How to check if credential password for TDE matches the secret key of Key Vault - Hi all, In my company we have many databases encrypted with TDE and there is some automatic process or pipeline that is not working correctly and updates the secret key in the Key Vault without applying the change also in the credential password in the SQL server. I need some help while we found this […]
SQL Server 2022 - Development
Select Returning Blank Rows - I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as S Where s.refnum = '123456' This brings back records for me. But when I use the field name instead like in #2, I get zero rows --#2 Select supplier, s.refnum, desc from supplier as S where s.refnum in (select refnum from […]
How to update a history table with changes. - Good morning to all.  I am a novice when it comes to SQL so my question is TSQL related on how to update a history table with changes to thousands of records without a cursor. Currently here is my code with cursor. I know I can update the price for all the parts in one […]
 

 

RSS FeedTwitter

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

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