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

What Have You Done Lately Outside of Work?

I was chatting with someone recently that's younger than me. They've got a good job and had some success learning, but they felt like their career wasn't progressing fast enough. This person still wanted to grow their career and their income. That's the place many people find themselves.

This individual was asking my advice since they thought I'd had some success and were looking for me to share some of the things that worked for me. I asked them this question: What have you done lately outside of work for your career?

They hadn't done really anything, which is fine. This person has a partner, hobbies, and has found some balance in life. They were enjoying themselves, which is great. I love people having balance in life.

However.

If you want to move faster in your career than others, you have to do more. I don't mean work 90 hours a week or spend every night on a project. However, I grew my career with work outside of work. Brent Ozar did the same thing. Many of the speakers you see at conferences and Microsoft MVPs did the same thing. They put in extra hours to grow their skills and knowledge.

I know lots of you work a lot, and you have family/friend/spiritual commitments. I get that. However, I'm sure most of you aren't working the coal miner's schedule. If you have hobbies or fun time, that's great, but can you carve out some time from those to invest in your career? Brent has time management skills advice, and I've written about this as well. Doctors, lawyers, even auto mechanics work on their skills when they aren't getting paid by someone. They do this as an investment in the future.

As I move towards the end of my career, I do less (especially this year), but I still read some books that help grow my skills in areas Redgate cares about. I do some training for coaching to improve there. I do less for my career than I used to, but I still do something outside of work.

Answer my question today. What have you done lately outside of work for your career?

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

How Would You Design This: Tracking Travels

Steve Jones - SSC Editor from SQLServerCentral

A fun contest from Steve asks you to design a system that tracks travels for a fictitious business.

External Article

Data Transfer from Azure Blob Storage to Snowflake Using Pipelines

Additional Articles from MSSQLTips.com

One of the premises of a modern warehouse is to be able to interconnect cloud services and process and analyze data from any provider with ease. Two of the top cloud services right now are Azure Synapse and Snowflake. Whatever your organization is implementing or if you need to transfer data from/to those services, it is important to know how to interconnect them and be able to transfer data between services.

External Article

PostgreSQL 101: The ten PostgreSQL extensions you need to know about

Additional Articles from Redgate

Extensions are a unique and powerful capability in PostgreSQL, a feature that other relational databases do not provide. Taking advantage of the extension framework in PostgreSQL is a true advantage to using the platform.

In this webinar, find out how PostgreSQL extensions can help you find solutions to some of your common problems.

Register now and to join on August 22nd

Blog Post

From the SQL Server Central Blogs - Presenting at PASS Summit 2023 – Atomic Habits

Tracy Boggiano from Database Superhero’s Blog

I’m excited to be presenting at PASS Summit 2023, not only because it is PASS Summit but because of the topic.  I do a lot
The post Presenting at PASS...

Blog Post

From the SQL Server Central Blogs - Exploring limitations of Fabric Warehouse: 3 key observations

Joyful Craftsmen from Joyful Craftsmen Blog

Introduction
Fabric Warehouse is a new interesting tool used for data management and analysis. While it offers a wide range of features and functionalities, it is essential to be aware...

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):

 

Setting Windows System Variables

In Windows, how do I set the system variable, myvar, to the value "SQLSaturdayBoston"?

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)

Finding Encrypted Stored Procedures

How can I tell if the dbo.NewprocOne is encrypted?

Answer: Check ObjectProperty( xx, 'IsEncrypted') for a value of 1 where xx is the object id, Check if the text column in sys.syscomments is null

Explanation: There are two possible answers here. There is a text column in sys.syscomments, which contains text. There is not one in sys.procedures. You can also check the objectproperty() for the IsEncrypted parameter. Ref:

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
How to identify changed values from a history table? - We have several tables with system_versioning set to on. There is a requirement now to produce a solution (function / stored procedure) to return a list of changed columns of a given table within a range of days. Below is an example of one of the tables - customer_sites and a bit of data: /**** […]
Run Stored Procedure on the first Monday if each month of Tues if Mon Holiday - Hello, I need to setup a Stored Procedure to run on the first Monday of each month that is not a holiday.  If the first Monday of the month is a holiday, than I need the PROC to run on Tuesday.  Via Scheduled Jobs, how is this possible?  Can someone help with a query on […]
SQL Server 2019 - Administration
repeated login failures. - Do repeated login failures into SQL affect performance.  Surely some resources are used with each attempted ack & nack?  Certainly log writes.  I have careless app owners who repeatedly fall foul of my attempts to stop this happening as their apps try access every 10 seconds or so.  They failures fill my logs & I […]
SQL SERVER AUDIT LOG can scheduled job be placed and get file in .csv format - Hi Team, SQL SERVER AUDIT LOG can scheduled job be placed and get file in .csv format we can see the audit logs using view logs rather than is there any way we can set the audit to run in frequency for every one hour and schedule it in a job where we can get […]
Deadlock - implicit transaction - Hi, We are experiencing deadlocks. The process not being the victim is doing an update by stored procedure which has begin tran,  commit tran. However the transactionname in the deadlock graph is implicit_transactions. Could this be potentially causing the deadlock issue and from the application implicit_transaction is on?  
File does not close: VerifyShareWriteAccess.txt - Hi Folks. We have two  SQL Server 2019 Enterprise in an High Availability Group (always on).  The OS is Windows server 2019. For the witness of the failover cluster we use a file share.  The cluster itself runs perfect. But we have some troubles with the file VerifyShareWriteAccess.txt. The cluster service opens the file (read, […]
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the name provided.  see error below: I'm trying to login into a sql server on another domain (DEV).  I run a command to launch SSMS and then login to a DEV server as follows: %windir%\system32\RUNAS.exe /smartcard /user:ABC@dev.com /netonly "C:\Program Files (x86)\Microsoft […]
Why would user account authentication issues arise in Azure? - Through a series of events too long to go into here, last year I was involved in helping to move a test SQL Server 2019 database from on-premises, to a VM in Azure. However, after it was migrated, they no longer needed me and that was the last I heard of or knew about it, […]
SQL Server 2019 - Development
Using Dynamic SQL to execute Select from Openrowset with JSON - I have some code which will load in and process a JSON file using Select..from Openrowset as follows: Declare @JSON varchar(max) SELECT @JSON = BulkColumn FROM OPENROWSET (BULK 'C:\Users\User1\DR\staging\returns\RET02022203.JSON', SINGLE_CLOB) as j select @JSON i tried to turn this into Dynamic SQL  so that I can pass in the path to the JSON file as […]
xp_cmdshell problem - Hi, i'm trying to run this command from within the SQL but i get this error 'C:\Program' is not recognized as an internal or external command, operable program or batch file. here is my code DECLARE @CONVERT_HTML_TO_PDF VARCHAR(4000) SET @CONVERT_HTML_TO_PDF = '"C:\Program Files\Microsoft SQL Server\MSSQL15.PRI\MSSQL\monitor_binaries\wkhtmltopdf.exe" "c:\new folder\1.html" "c:\new folder\1.pdf"' EXEC xp_cmdshell @CONVERT_HTML_TO_PDF what is wrong […]
Best way to handle incremental duplicate data in SQL Server? - I am processing .csv files daily which has persons data. Every person has a unique ID. My table has FileID and PersonUniqueID columns; it is working fine and saved to parsed table, i.e. with duplicate rows. Now would like to copy the unique data to new tables which is used by other applications. I can […]
CosmosDB
To change the maximum throughput of an Azure Cosmos DB for NoSQL container - Hello,   I have a question, and please advise. When I wish to change the maximum throughput of an Azure Cosmos DB for NoSQL container from 4000 RU/s to 5000 RU/s, would that be sufficient if I use command: az cosmosdb sql container throughput update command --max-throughput ‘5000’ ???   Tanks in advanced  
Reporting Services
Custom Authentication SSRS 2019 - When trying to setup custom authentication on ssrs 2019 getting "ERR_CONNECTION_REFUSED " and this in the logs   ERROR: Error loading configuration file: The configuration file contains an element that is not valid. The #text element is not a configuration file element. library!DefaultDomain!13d0!08/02/2023-09:54:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: , Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration […]
SSRS Integration with Power BI - I am trying to integrate SSRS 2022 with Power BI.  One of the steps is to go into Report Server Configuration Manager and go to the Power BI integration tab;  however, I am not seeing a Power BI integration tab.  Is there something special I need to do or install to see that tab?   […]
Analysis Services
Date Difference of current record and its relative record using MDX - Dear All, I have a some rows where it points to another row in same table based on RelativeId column value. I need to find the difference of these two records date values using MDX. for ex.  sample table structure with some values ID - HasRelative - Date - RelativeId 1 - False - 2023-01-01 […]
 

 

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

 

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