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

Do You Have the Gifts to Be a DBA?

This editorial was originally published on Jul 13, 2019. It is being re-run as Steve is out of town.

I recently had the pleasure of catching Paul McCartney in concert, and he was amazing. I have been a fan forever and have heard him tell the same stories he over and over with great delight. A familiar tale he tells is about when he wrote the song Yesterday. He woke up with the tune in his head, and put words to it: Scrambled Eggs, oh my baby how… Ok, so the words changed a little. But you can’t dispute he has an amazing gift for music, and he wasn’t trained as a musician and doesn’t even read music.

I know DBAs and programmers that have such gifts with computers. They have the innate ability to write the code to solve problems in their sleep, in any language, and seemingly were born knowing how to solve technical problems. Some of these people are ten years old and can just bang out code that I am not even able to understand (and I have had something of a solid career in programming myself.) If you were born with such gifts, be thankful, and use them to help the rest of us.

On the other side of the coin, is the aforementioned “rest of us,” ranging from slightly gifted to well, slightly south of clueless. I fit squarely in the last group when I first went to college. I was skill-less, other than being a super-fast burger flipper, but I desired a civil engineering degree. I wanted to build bridges like the Linn Cove Viaduct at Grandfather Mountain in NC. Then I failed out of engineering classes. Then on to math, where I accumulated the minimum GPA to get a degree, which I realized probably wasn’t going to get me employed in the math factory. Finally, I found computer science which I was slightly better at than I was at math, but only maybe in the middle of my class, if that.

My life changed when, back in the early 1990s, I became one of the first accidental DBAs. At the time, I was a LAN admin on Novell, and I was again clueless. I knew just a bit more than how to reboot the server to fix problems, but only just a bit more. This still pretty much describes my current networking skills with Wi-Fi. Then I received the gift that would change my life. Our IT group went to a conference named COMDEX and learned about this new product: SQL Server. The other member of the team started working on a mainframe replacement. A person I worked with quit, leaving a database programmer shaped hole in our company, and I did double duty for a while. I never looked back.

When I first got started, I was terrible. We didn’t have user groups or small conferences, but I had a manager who forced me to do a good job at building parts of our database, teaching me normalization in a way that made sense well enough but wasn’t quite enough for me. It made me dig deeper and deeper into the materials that were available at the time. Probably the most significant gift I received when my next manager said the only way you will ever get to go to conferences at the nonprofit I worked at, was speaking at the conference. I was the only person on the team that took him up on it. I spoke at a Computer Associates conference on Erwin that year. After I left there (temporarily), I ended up at the second PASS conference, where I met a publisher and asked if anyone wrote a good book on database design. He said, “Why don’t you?”

The gifts keep coming and only increase in the great conferences that I attend every year, the blogs I read, and even the great tweets from the community. You would be amazed at how so many people have contributed to getting me where I am today, some purposefully to help me, some just putting stuff out there, some pointing out when I have been wrong (often very wrong) over the years. Sometimes gifts hurt.

If you aren’t a natural, the fact that you found this blog means you have some idea where to start. A lot of gifts aren’t addressed to you specifically. Most are just thrown out into the ether to share with everyone. Count the gifts you have received from the community, coworkers, family, parents, whoever got you where you are today. And these gifts are not for hoarding. Regift as often as you can. Share with a user group. Write a blog. Contribute to Twitter’s #sqlhelp, volunteer for a local non-computer organization, or whatever you can do. I can barely count the number of people that I have seen join the community and thrive (often leaving me in the dust!) It will be worth it for you, for the community and possibly me.

 

Louis Davidson (@drsql)

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

 
 Featured Contents
SQLServerCentral Article

A New and Improved Data Warehouse: Data Engineering with Fabric

John Miner from SQLServerCentral

In this next installment, John performs the research you might do if your management asked you to examine Fabric.

External Article

Auditing SQL Server – Part 3 – SQL Server Configuration Audit

Additional Articles from SimpleTalk

This section gets into detailed SQL Server configuration details. This is less relevant in a cloud environment, but there are still items to confirm.

Blog Post

From the SQL Server Central Blogs - Grouping by Object Type in SQL Compare

Steve Jones - SSC Editor from The Voice of the DBA

A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...

Blog Post

From the SQL Server Central Blogs - Don’t run CHKDSK while SQL Server is running

Randolph West from Born SQL with Randolph West

On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is...

SQL Server 2022 Administration Inside Out

Site Owners from SQLServerCentral

Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance.

 

 Question of the Day

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

 

Concatenating Strings

If I use the CONCAT() function instead of a plus (+) to combine strings, is there a limit to how many strings I can concatenate together?

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)

Trigger Ordering I

I have multiple triggers on a table in SQL Server 2022. If I want to use sp_settriggerorder, what are my options for the @order parameter?

Answer: "First", "Last", or "None'

Explanation: You can set a trigger order to be first, last, or none. Ref: sp_settriggerorder - https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-settriggerorder-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
Can you pass an undeclared variable to a Stored Procedure - If I have a SP that calls another/different SP can I pass to that second SP a variable that has not been declared within the 1st SP and which was not passed to the 1st SP like the below?  I am walking through some code in a SP and found that it had a variable […]
SQL Server 2019 - Administration
64KB and 32KB cluster size for log drives and tempdb - Hi, I was told that sometimes log and tempdb drives benefit from 32KB cluster size as opposed the traditional 64KB.  How can I check this theory for a specific system?  I guess different database servers have different write patterns. How do I find out what write sizes a particular server uses the most and if […]
Timeout while trying to add database to availability group - Hello experts, I'm trying to learn what network access is being blocked when I get the timeout error below. It happens after I click Connect in the Add Database to Availability Group wizard. I have sometimes gotten around this by using T-SQL to add the db, but I want to finally understand how to fix […]
Using the Database Migration Assistant - Getting questionable results. - Hello, Firstly, apologies if I have posted in the wrong spot, I could not find a 'Migration' forum here. Happy to move it elsewhere if need be. I am using the Database Migration Assistant to recommend an Azure SQL Managed Instance SKU for an on-premises SQL Server 2017 instance. I ran the assessment over 3-4 […]
Windows 11 & sudden SSMS sorting nuisance - When I was still in Windows 10, I'd open up SSMS (version 18) and go to Object Explorer Details, where I would see the folders System Databases and Database Snapshots up at top and all the individual database names listed in alphabetically order (unless I sorted otherwise). Now that I've upgraded to Windows 11, something […]
SQL Server 2019 - Development
How to calculate potential IO benefits of changes - I work on a multi terabyte warehouse database application which typically ingests between 130 and 180 million rows of data per day and processes into a data mart for them for consumption into a Tableau report. This is an on prem database using a virtual machine with 18 cores and 300 GB allocated to SQL […]
Lag function on an update not working - I have a table with odds from sportsbook, and I need to populate a gamedate value that is null . The gamedate in question coincides with the even numbered rotation rows of the data, below are samples of what i'm working with Create [dbo].gameresults ( gamedate date null, team varchar(50) null, rotation int null, odds […]
Reporting Services
What do I do about OBJ files, when I try to commit to a Git repository? - Today I was trying to store an SSRS project into a Git repository. (The SSRS project was written by a vendor.) I wanted to put it into Git so that if I needed to revert to an older version, I could do that more easily. I was going to use GitHub to store the repo […]
Powershell
Checking flag sometimes false\positive result - I have this script checking a SQL table looking for a result of True in a table. 99% of the times it works as designed, but on certain occasions it does not. I check this with a scheduler every 5 minutes. It sometimes produces a result of true in which hasn't been set to that […]
extract data from all servers and dump it into a table - I have 5 servers in the servers table . The code is not looping through all servers. Its only going to the ABC server 5 times and capturing data from ABC server 5 times. $Servers = Invoke-Sqlcmd -Query "SELECT ServerName FROM dbo.Servers" -ServerInstance "ABC" -Database "DB" foreach ($Server in $Servers) { $ServerName = $Server.ServerName If […]
Testing
Test1 - test
SSDT
SSIS MSOLEDBSQL: ConnectRetryCount, ConnectRetryInterval - Using SSISDB on server A, we have a parent package that loops through a configuration table and executes several hundred stored procedures on server B. Occasionally one of the processes fails with Failed to acquire connection "". Connection may not be configured correctly, or you may not have the right permissions on this connection. This […]
Analysis Services
How to create a Visual Studio project from an SSAS Multidimentional cube? - I was hoping there would be some sort of "import" feature but can't find it...
Job Postings
Hiring 15 skilled SQL devs for part-time freelance work. Jobs start @ $40 / hour - Are you a skilled SQL developer? Are you looking to supplement your income with high-paying, fully-remote freelance work? Are you interested in learning more about AI and its impact on the future? Join our talented community of SQL experts supporting the world's leading AI companies, and be competitively compensated for your hard-earned skills and insights. […]
SQL Server 2022 - Development
Index Update Reports - Scans/Seeks - SELECT DB_Name() As CurrentDatabase, objects.name AS Table_name, indexes.name AS Index_name, SUM(dm_db_index_usage_stats.user_seeks) as UserSeeks, SUM(dm_db_index_usage_stats.user_scans) as UserScans, SUM(dm_db_index_usage_stats.user_updates) as UserUpdates, GETDATE() as Createdttm FROM sys.dm_db_index_usage_stats INNER JOIN sys.objects ON dm_db_index_usage_stats.OBJECT_ID = objects.OBJECT_ID INNER JOIN sys.indexes ON indexes.index_id = dm_db_index_usage_stats.index_id AND dm_db_index_usage_stats.OBJECT_ID = indexes.OBJECT_ID WHERE dm_db_index_usage_stats.user_lookups = 0 ANDdm_db_index_usage_stats.user_seeks < 1 ANDdm_db_index_usage_stats.user_scans < 1 AND indexes.name IS […]
 

 

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

 

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