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

Action Over Knowledge

I saw a quote recently that resonated with me. It's not something I've often struggled with, but I have at times. Here's the quote:

"Life rewards action, not intelligence. Many brilliant people talk themselves out of getting started, and being smart doesn't help very much without the courage to act. You can't win if you're not in the game." - @JamesClear

Part of my goals in life are to help others and motivate them to engage in life and drive themselves forward. I have tried to motivate my children, I work with kids I coach to grow and change, and I (think) write about this often here. I want you to take charge of your career and life and drive it forward in the way that works for you.

However, you have to work at things. The quote above notes that it's not how smart you are, but having success in life comes from action. From doing something. From making efforts. The last part is the most important, if you don't engage and become part of your game, your life, you can't win or achieve your goals.

As Ferris Bueller said, life can move pretty and you can miss it if you're not paying attention. As I get older, that means more to me. Life slips by, days, weeks, months, even years seem to fly by. Especially after the pandemic, where I see someone and realize it hasn't been a year or two since I've seen them but four years.

You don't have to be extremely driven and type A. I think I might be a little too driven at times, living in chaos, but I met someone recently who spent more than 5 years trying to transform a company. This individual worked their job, spent nights and weekends trying to learn more about their business, and drove themselves and others well beyond what I'd consider a balance in life. They were working well over 60 hours a week for years, as were some employees. I don't think that's a great way to live, and whether it's work, hobbies, or something else, forgetting to balance the various parts of your life isn't good.

At the same time, inaction, not trying to grow, learn, practice, or even attempt something new in any part of your life isn't good either.

Work on your career and skills but balance that with the time you need away from work. Invest in your education to change careers if you like, but don't plan on working what is essentially two jobs to become a way of life. At least not for too many years. Enjoy your hobbies, but remember there is family at home that deserves and needs your time as well. Find ways to engage in life, but in a way that respects all the commitments to work, family, friends, faith, hobbies, and yourself. Especially don't forget about taking care of yourself.

Effort is often more important than the short-term results. Just being engaged and in the game gives you a chance of success, but more, it allows you to enjoy the ride. Just do so in a balanced way.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Metadata Driven Pipelines – Data Engineering with Fabric

John Miner from SQLServerCentral

This article explains metadata driven pipelines and shows an example in Microsoft Fabric.

External Article

Snake draft sorting in SQL Server, part 1

Additional Articles from SimpleTalk

I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum of the restore times

Blog Post

From the SQL Server Central Blogs - SQL Database Administration: Not For Everyone (But Maybe It’s for You)

Tracy McKibben from RealSQLGuy - Helping You To Become A SQL Hero

Let's get one thing straight: database administration isn't the most glamorous tech job out there. You won't be building flashy user interfaces or trendy AI models. But if you...

From the SQL Server Central Blogs - Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module

david.fowler 42596 from SQL Undercover

Full documentation on the Undercover Catalogue can be found HERE It’s been a while since the Undercover Catalogue last received an update but having had a few of those...

Practical Database Auditing for Microsoft SQL Server and Azure SQL

Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

Site Owners from SQLServerCentral

Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. ss

 

 Question of the Day

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

 

Post Restore Tasks for the Resource Database

I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?

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)

Reporting Services Editions

In which editions of SQL Server 2022 can you run Reporting Services?

Answer: In Enterprise, Standard, Web, and Express with Advanced Services only

Explanation: Reporting Services can run on Enterprise, Standard, Web, and Express with Advanced Services Ref: SSRS - https://learn.microsoft.com/en-us/sql/reporting-services/reporting-services-features-supported-by-the-editions-of-sql-server-2016?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
Principal owns a service? - This is one I haven't seen before. I'm trying to drop a database user and got the below message. The login doesn't own any roles or schemas or other objects and everything I google on the error comes up with "principal owns a schema" which is not what this error is. When I try googling […]
Degraded Performance in 2017 vs 2008 R2 with inserts - We're finally upgrading from SQL Server 2008 R2 Enterprise to SQL Server 2017 Standard and have moved our test database to the new server.  Both VMs are on similar hardware with 4 vCPUs. Of course, given the chasm of versions we expected much better performance.  Unfortunately, that's not the case. Our inserts on the 2008 […]
SQL Server 2016 - Administration
User permissions and showplan - All, I'm trying to find a way to let some of our users see at least some details of a query plan particularly whether an index is being used. I looked at the set statistics statements because the user only needs permissions to run the query but they only specify tables and not indexes? I […]
SQL Server 2016 - Development and T-SQL
Slow update on temp table - I have a job running each night starting at 4:30AM and usually finishing at around 6:30AM or shortly thereafter doing some number crunching. Occasionally, this job slows down taking much longer...today it ran until about 8:45AM. This statement, normally would take a second or two...the table is about 250,000 rows with 8 columns...today it took […]
SQL Server 2012 - T-SQL
Insert using table unput - I have a table that I need to run off a different server\db and looking for the most efficient way to call from an SP. I need to execute. the field(sqlToExec) as it's loaded with 1000's of Insert statements like below to update this same table on a different server and DB. If something error […]
SQL Server 2019 - Administration
Table Partitioning - remove null range - hi guys,   I have a partitioned table AM_ITM_INSTNC_MSS and I want to  get rid of MYDW_TPData2015 filegroup, how can I achieve that?
Backup of encrypted databases failing - I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName' detected an error on page (10:12345) in file 'D:\path\DBName_File.ndf' The databases were originally encrypted on a production server and restored to a DEV environment, which may be relevant. All the databases on the DEV server are encrypted, but only two were […]
SQL Server 2019 - Development
Create Copy of DB in same server. - Hi I want to create a copy of a DB on the same server. The account that creates the copy DB should NOT be able to read from the original DB but have full rights to the copy DB. Cannot use a  snapshot, Changes will be made to the copy and the copy will be […]
Find the problematic Sql Query Caused Application Crash - Hi, Is there anyway I can find out the sql script ran on a particular date and which might have causes application down? I mean my application was down on 12 April 2024 and based on investigation it was found some sql query running causing the application down. How I can find out what all […]
Does it make a sense to update statistics right after tables truncated? - Hi all, We have a lengthy process that uses 30 tables, some of them are large. In the beginning we truncate them, then ETL data into them, then massage, perform some calculations, and finally reporting. I am tasked to clean up this process. Right after initial truncation we update statistics on all these tables. Does […]
SQL Azure - Administration
zero downtime deployments - Hello, We have azure MI business critical. active read/write, secondary read /only. from what I see most of the HA is handled behind the scenes using Always ON. We have a 30 min downtime every month during product deloyments but one high profile customer wants 0 downtime. How to achieve that with Azure MI Business […]
Reporting Services
SSRS Expression IIF Zero then ... Got #Error - Hello, Need some help for SSRS. The column % expression is =iif(sum(Fields!ColumnA.Value) = 0 or sum(Fields!ColumnB.Value) = 0,0,sum(Fields!ColumnB.Value) / sum(Fields!ColumnA.Value)) But I am getting #Error if ColumnA is zerro and no error if ColumnA and B had no value. Please advise. Thank you.    
Analysis Services
Issues backing up Analysis Services databases - silent failures - I have a PowerShell script that I use to automate the backup of Analysis Services databases - allows for handling new/dropped databases, dynamic filenames, etc. However, on some occasions the backup fails but no output is reported stating why. I get a success message when it works but nothing when it fails. I've tried adding […]
Strategies and Ideas
Do I need a recursive query for this? bill of materials (sort of) - I am working on a data warehouse project for a bakery. For the most part, the basic structure is like this: Purchase--(M,1)--Ingredient--(1,M)--Recipe--(M,1)--Product with one exception the "Recipe" part works fine. (IngredientKey, ProductKey, Weight).  The part I'm having trouble with is that one ingredient (starter) consists of other ingredients (kinda like a subassembly, if you wanted […]
Do I need a recursive query for this? bill of materials (sort of) - I am working on a data warehouse project for a bakery. For the most part, the basic structure is like this: Purchase--(M,1)--Ingredient--(1,M)--Recipe--(M,1)--Product with one exception the "Recipe" part works fine. (IngredientKey, ProductKey, Weight).  The part I'm having trouble with is that one ingredient (starter) consists of other ingredients (kinda like a subassembly, if you wanted […]
 

 

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

 

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