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

Your Value from a Conference

The PASS Data Community Summit 2025 was held in Seattle last month, and it was an interesting event for me. I wrote a wrap-up on my blog, but a few things stood out. The event was a little smaller, with over 50% first-time attendees, but seemed to be a bit more vibrant. Perhaps people coming for the first time added something that I hadn't expected. I was a bit over-committed, so I didn't spend a lot of time in the public spaces, but things felt a little different the few times I was in the expo hall or the hallway track.

I ran across a Reddit thread on the value of conferences, and it got me thinking. What is the value that you get from attending a conference (or an event). If your employer pays you might feel that you should bring some value back to them when you return. That's the premise of the thread, and I know there are plenty of people that feel that way. However.

Should you value your time and effort any less?

What if you attend a SQL Saturday or other local event for free? Shouldn't there be some ROI for you? With that in mind, I'm asking the question of you: what value do you get from attending a conference? For any type, size, shape, topic, etc. conference, let us know what you do go, or would go, or maybe would choose to skip the opportunity.

I've attended lots of different events in my career. My perspective varies depending on the event. I've attended customer conferences for a vendor, where I want to learn what might be changing, how others use the products, ask if there are solutions to our challenges, or even get the chance to influence the product development people. For local events, it's networking and the chance to see a session on something I am interested in learning more about or a topic that might be of use in my job. For large industry events, there's a larger scale, and more choices of topics, so I might get the chance to explore something I know little about or see some great speakers inspire me.

However, I get out what I put into it. If I am passive and just sitting there hoping I learn something from a talk, I'm can be disappointed. That's an expensive way to learn something. The real value comes when I ask questions of the speaker afterward (or listen to others' questions). I learn more by discussing the talk with other attendees, or having random conversations about the things others are doing/learning/trying/etc. in the hallways. Engaging others gives me ideas and inspiration I don't get from a lecture.

The other thing that comes from a conference is a break from work. I try hard not to schedule work things or respond to messages while in sessions. I want to unwind, let my brain change gears, and hopefully get recharged in a different atmosphere. There's also the chance to visit another city and perhaps see a sight or two. I love Las Vegas for this reason, taking my wife and seeing a show after networking and learning all day. It's a great break from work.

I think there are good reasons to send people to conferences: learning, getting inspired, recharging, or even as a perk for employees who are working hard the rest of the year.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

T-SQL in SQL Server 2025: The || Operator

Steve Jones - SSC Editor from SQLServerCentral

I have been working in various computer languages for a long time. When I saw that the || operator was coming, I was a bit confused as to why we needed this, and how it would work. After all, this is a part of other languages. I decided to dig in a bit. This is […]

External Article

SQL Server 2025 Product() Function Examples

Additional Articles from MSSQLTips.com

SQL Server 2025 includes new features and enhancements. In the previous SQL Server 2025 tips, we have explored many new features. Have you explored the new Product() function? If not, this will walk you through the Product() function with several examples.

Blog Post

From the SQL Server Central Blogs - Prepping for Certification, Part 4 of 4

K. Brian Kelley from Databases – Infrastructure – Security

In Parts 1-3, I covered how I prepare for a certification exam. In this last part, I'll talk about how I go about taking the exam.

From the SQL Server Central Blogs - SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)

peter.skoglund from SQL Development Wizard

 SQL Server – What To Do When Disaster Strikes (5-Point Survival Guide)Chill, coffee first.When your SQL Server goes down, alarms are blaring, and managers are hovering, that sentence might...

SQL Server 2022 Query Performance Tuning

Grant Fritchey from SQLServerCentral

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server.

 

 Question of the Day

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

 

UNISTR Basics

What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A:   B:  

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)

Deprecated Feature Tracking

From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?

Answer: Yes, with a query to sys.dm_os_performance_counters

Explanation: The sys.dm_os_performance_counters DMV has a counter called "deprecated features". If you query this, you see each type of feature and the count of usage. This query is useful to see the deprecated features in use:

SELECT  object_name,
        instance_name AS DeprecatedFeature,
        cntr_value    AS UseCount
FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Deprecated Features%'
ORDER BY cntr_value DESC;

Ref: sys.dm_os_performance_counters - https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-performance-counters-transact-sql?view=sql-server-ver17

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 - Development
Pivot but preserve all rows on Aggregate column - Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a column and creates only row, my goal is to preserve all rows. We need to pivot on DSTRCT_CODE which will have only two values {BBBB/CCCC}  on value of column PREF_PART_IND. so for below sample data : with q_data as ( select […]
SQL Server 2019 - Administration
MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn. - hi,   i have checked reducing it increasing it but could not get any thing, pls explain what exactly it means. DROP EVENT SESSION [CaptureSlowQueries] ON SERVER go CREATE EVENT SESSION [CaptureSlowQueries] ON SERVER ADD EVENT sqlserver.sp_statement_completed( ACTION(sqlserver.database_id,sqlserver.sql_text) WHERE ([duration]>(15000000))), ADD EVENT sqlserver.sql_statement_completed(SET collect_statement=(1) ACTION(sqlserver.client_app_name,sqlserver.database_id,sqlserver.sql_text) WHERE ([duration]>(15000000) )) ADD TARGET package0.event_file(SET filename=N'SlowQueries',max_file_size=(5),max_rollover_files=(2)) WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 […]
SQL Server 2019 - Development
is there a no code way to limit an ssis extract from excel to the 1st 21 rows? - is there a no code way to limit an ssis extract from excel to the 1st 21 rows of the sheet?   for now anything past that is just noise in what im doing.
any reason to avoid asking ssis to extract files from ftp - hi we have to replace talend which generally was used to move files. talend's replacement except for a handful of sql sourced etl's is an OO code based "pipeline" architecture.  the sql stuff has been converted to ssis. we have to begin extracting about 6 files daily from an ftp server and throwing them out […]
CAST datetimeoffset(7) as a datetime in UK format - I have a view where I am casting a datetimeoffset(7) field to smalldatetime or datetime as my reporting application won't accept the datetimeoffset(7) format.  Problem is I am trying to get this field to show up in UK format.   I am using CAST to get my results.  I can get the format I need by […]
what are the downsides of TDE not running vs running? - hi for the 2 years i've been here I believe we've had "encryption" turned off in what i only know as the way we tell ssms to communicate with our sql servers ...and i've always thought meant also the server itself relaxing how it communicates back to whatever client is asking for data. recently an […]
Reporting Services
Catalog max connection pool size: 100 - Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise: a) Why this is being reported so frequently? b) Does it indicate the limit is being hit? c) If b is true, how can I increase it? I've had a look through the configuration files and can't find anything specifying "100" […]
Editorials
Investing for AI - Comments posted to this topic are about the item Investing for AI, which is is not currently available on the site.
Article Discussions by Author
What is the PRODUCT - Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform - Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform - Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server - Comments posted to this topic are about the item Unlocking Data Transformation: My journey with dbt (Data Build Tool) on SQL Server
SQL Server 2022 - Administration
Help! MEMORY_ALLOCATION_EXT wait stalls - Hi I have an overnight process that moves allot of claims records Been working fine for many years. Now it hits this part of the code (across a linked server) and gets the (1596567ms)MEMORY_ALLOCATION_EXT wait type and will sit there forever and never move any records - no delta movements at all. Used to complete […]
SQL Server 2022 - Development
cant process ssas db on vm - error says source is encrypted and other things - hi i get the error you see below when trying to process my AR cube full.  it is sourced by a sql db on the same server that theoretically is being connected to by my admin acct.  my query on which sql engine db's might be  encrypted comes up false on each.   i made sure […]
This doesn't make sense to me - making me crazy - er - Hi So I have the below select query that won't return results if I have it this way:   --DOES NOT RETURN-- AND EXISTS (SELECT 1 FROM edi.dbo.PEC_RGT_EDI_834_Inbound_Exception xx WHERE (xx.SubscriberNumber = x.subscribernumber OR x.MBI = xx.mbi) AND xx.LastDateProcessed>'05/31/2022') But will return results with this very small change: --DOES RETURN-- REPLACE ABOVE WITH BELOW AND […]
 

 

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

 

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