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

The Changing Landscape of Community

We have a guest editorial today as Steve is on vacation.

Recently, I participated in a survey by Brent Ozar on attending in-person conferences, which led me to reflect on the concept of community and its current meaning. Over the past 21 years, my attendance at the PASS Summit has proven immensely valuable. It expanded my network, exposed me to exceptional teachers, and provided opportunities to visit fascinating places. As a user group leader, I have always encouraged others to seek similar benefits and advance their careers. However, the events of 2020 have brought about significant changes, prompting me to question the necessity of attending conferences and to ponder the evolving nature of community.

The term "community" encompasses various definitions. Personally, I find the perspective of psychiatrist M. Scott Peck appealing. He says “Community [is] a group of individuals who have learned how to communicate honestly with each other, whose relationships go deeper than their masks of composure, and who have developed some significant commitment to "rejoice together, mourn together," and to "delight in each other, make others' conditions our own.”

Communities, by their nature, are not stagnant entities; they evolve over time. Within the SQL Server community, the sense of joy in supporting one another and empathizing with each other's situations played a crucial role. We assisted like-minded individuals in finding employment opportunities, connecting with inspiring role models, and supported each other on striving to reach our goals. In the past, this was easier as we primarily worked on SQL Server and frequently met in person at events. However, I have noticed that many of my acquaintances have since ventured beyond those boundaries. Although we remain friends, networking has become increasingly challenging. Companies do not support conferences like they used to. Many people still have health challenges with travel. Finding the right event to go to, given the range of technologies we deal with now can be hard.

Personally, as someone who has some of these challenges – I have found ways to adapt. I attend virtual events whenever I can. I do virtual hangouts with a number of friends, old and new. It no longer feels odd, it has become a habit. PASS Summit has options to volunteer online, and am finding that a rewarding experience – I have made new friends in that process too.

While it is universally acknowledged that in-person human interaction has no substitute, there are alternative avenues that can help bridge the gap. We can still cultivate friendships, share moments of joy and sorrow, but it requires a greater level of dedication. Despite the obstacles, we can compensate for the absence of face-to-face interactions by leveraging the available resources. The key lies in our willingness to make the extra effort.

The shifting sands of community demand our resilience and adaptability. As we navigate this new landscape, we must embrace the opportunities that arise, explore innovative ways to connect, and continue to nurture the bonds that make a community thrive.

Diligentdba 46159

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

 
 Featured Contents
SQLServerCentral Article

Bard, Google’s ChatGPT Competitor

Daniel Calbimonte from SQLServerCentral

See how the Google AI, Bard, works and answers questions about data topics.

External Article

SQL Server Database Backup and Restore Failure Notifications

Additional Articles from MSSQLTips.com

My SQL Server backups and restores fail infrequently, but when I find out it is too late. How can I find out sooner?

External Article

Six Things to Monitor with PostgreSQL

Site Owners from Redgate

To get the most out of your PostgreSQL database, find out the six performance metrics that ought to be central to your PostgreSQL monitoring strategy.

Blog Post

From the SQL Server Central Blogs - Connecting to Azure SQL DB with an Azure Active Directory Account in Azure Data Studio

hellosqlkitty from SQLKitty

This all started because I wanted to follow Tracy’s directions on setting up Ola for index maintenance in Runbooks. I couldn’t set up the automation account permissions unless I...

Blog Post

From the SQL Server Central Blogs - What Happens in the Background when Executing Queries with Always Encrypted

Matthew McGiffen from Matthew McGiffen DBA

In previous posts we've looked at a number of aspects of Always Encrypted and how it works. I think it's very useful to understand how it actually works in...

Azure SQL Revealed

Azure SQL Revealed: A Guide to the Cloud for SQL Server

Site Owners from SQLServerCentral

Access detailed content and examples on Azure SQL, a set of cloud services that allows for SQL Server to be deployed in the cloud. This book teaches the fundamentals of deployment, configuration, security, performance, and availability of Azure SQL from the perspective of these same tasks and capabilities in SQL Server. This distinct approach makes this book an ideal learning platform for readers familiar with SQL Server on-premises who want to migrate their skills toward providing cloud solutions to an enterprise market that is increasingly cloud-focused.

 

 Question of the Day

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

 

Data Engineering in Fabric

One of the parts of Microsoft Fabric is the data engineering section. What does this consist of?

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)

Missing Chinese Surnames

I have some code I used for testing some non-Latin data:

CREATE TABLE dbo.CustomerFromChina
( customerid INT NOT NULL CONSTRAINT CustomerFromChinaPK PRIMARY KEY ,
  customersurname nvarchar(100)
)
GO
INSERT dbo.CustomerFromChina
   (customerid, customersurname)
VALUES
   (1, '陈'),
   (2, '杨'),
   (3, '赵'),
   (4, '黄')
GO

When I query this in SSMS and get text results, I see these results:

customerid customersurname
1   ?
2   ?
3   ?
4   ?

What's wrong?

Answer: The INSERT statement is incorrect

Explanation: In this case, the insert statement is broken. The structure is inserting character with an implicit conversion, not nchar data. There needs to be an N in front of each string with a Unicode character. Ref: No great reference for this, but here is the implicit conversions part, which is what is happening: https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16#implicit-conversions

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 2012 - General
Can I install SQL failover on a single node WSFC cluster? - For depressing reasons, I'm installing 2012. Don't ask.  For some other reasons I've had to create a single node WSFC cluster (& will add a node later).  I want to install SQL FCI (not standalone) but I'm struggling.  It could be lots of things, group policy, permissions ...  but ... Q 1  - is it […]
SQL Server 2019 - Administration
List SPN for NT Service\MSSQLServer account - Does anyone know how to list the SPN for the NT Service\MSSQLServer account ? I've created the following combinations and nothing is working setspn -L MSSQLSERVER setspn -L NT Service\MSSQLSERVER setspn -L "NT Service\MSSQLSERVER" setspn -L 'NT Service\MSSQLSERVER' When the VM was created via terraform the NT Service\MSSQLSERVER account was used to run the service […]
File extensions errors - Processed: Jun 27 2023 3:02AM, LogDate: Jun 27 2023 3:01AM, Server: [WARNING] === At least 4 extensions for file {XXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXX} (sql\ntdbms\hekaton\engine\hadr\mtlog.cpp : 6063) What do the above warnings mean? Do they need to be investigated - if yes-how do we troubleshoot them or can they be ignored. Thanks      
SQL Server 2019 - Development
Arithmetic overflow error when using POWER function - Hello, Any help appreciated. This code should perform a internal rate of return (IRR) calculation. It generates correct data based on what was provided to me using Excel's IRR function. It looks like as GETDATE() gets close to my hard coded date the error is generated. Any suggestion to prevent the error would be appreciated. […]
Preventing Arithmetic overflow error when using POWER function - Hello, Any help appreciated. This code should perform a internal rate of return (IRR) calculation. It generates correct data based on what was provided to me using Excel's IRR function. It looks like as GETDATE() gets close to my hard coded date the error is generated. Any suggestion to prevent the error would be appreciated. […]
Update view from dynamic sql - I'm using the code below to change the name of the columns in a view but it doesn't actually update the view. What do I need to do so that the view is updated? Thanks.   DECLARE @code4 VARCHAR(9); SET @code4 = CONVERT(VARCHAR(2),month(DATEADD(MONTH,DATEDIFF(MONTH, 0, GETDATE()) - 4, 0))) + ' - ' +CONVERT(VARCHAR(4),year(DATEADD(MONTH,DATEDIFF(MONTH, 0, GETDATE()) […]
DELETE with SELECT and join in SQL SERVER - I have a select statement below which gives the expected results of duplicate data. I want to convert this statement to a DELETE Statement to delete items leaving a single item but getting error. Below is my query. Sample data SampleOne 2016-10-14 12:44:39.460 SampleOne 2016-10-14 12:44:39.460 SampleTwo 2016-10-14 12:44:39.460 SampleTwo 2016-10-14 12:44:39.460 SELECT t.* FROM […]
Out of 3 same/ similar rows, remove two and keep one - Hello everyone, I would like to ask someone for an advice. I am not even a 100% sure it is doable, but it might be. I have a table that returns the same or almost the same rows of information often times 3 times. Basically there are 3 types of Transactions: 1. GL Posted - […]
SQL Azure - Administration
How to read file metadata from an Azure Blob location? - Anyone recommend the best way to accomplish this? Powershell? Or can you do this via external data sources?   All I need to do is read file metadata from folders in azure blob storage so I can get the filename and date file created for audit purposes.   Thanks in advance!
Reporting Services
SSRS reports URL in database - We would like to include userID in the reportURL, so that later we can see the report execution data for specific users. I know we can query the database using ExecutionLog3, but I don't see a URL field included. Any where store that information, what is the best way to get report execution counts for […]
Integration Services
How to skip Deleted Servers - I have a SQL table with some servers and a package which runs of those servers. 1.Execute task to list the servers from the table. 2.For each loopcontainer inside which I have data flow task which in turn has oledbsource and oledbdestination. The package runs fine when all servers are present.If a server is deleted […]
T-SQL
Use BCP and a format file to export data to a text file - I would like to use BCP and a format file to export data to a text file in a fixed length format. Fields export. The length and starting and ending position. Last Name Length 20 Position 1-20 First Name Length 15 Position 21-36 Social Security Number Length 9 Position 37 46 AddressLine1 Length 30 Position […]
SQL Server 2022 - Administration
SQL Server running on Linux, instance starts almost 2 mins after the service - SQL Server (2022) running on Linux (SuSE 15.4), instance starts almost 2 mins after the service. When the system starts, systemctl status mssql-server.service reports, something like Active: active (running) since Wed 2023-06-28 15:47:57 UTC; 2min 43s ago However, sql server is not available immidately, has to wait almost 2 mins before can be queried. When […]
SQL Server 2022 - Development
how to identify sql scripts not in stored procs w/o using trace - I'm storing off various stats about procs on a daily basis. On e of them stores each sql statement in each proc w/ runtimes and other information.   My issue is there are power bi reports and sql job step that are not using procs but have embedded the sql scripts directly in them . […]
issue with text column in dbo.syscomments - I wrote a process to store off all sql objects daily. There is one that stores off all stored procedures contents daily. The text column in the dbo.syscomments table is being stored locally in another table whose column is a varchar(max). It stores each proc in 4000 char chunks. So there will be one record […]
 

 

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

 

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