In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post to learn more.
The post PASS Data Community Summit registrations are open! appeared first on SQLServerCentral.

Over the past 25 years, I have answered a lot of programming questions in online forums, from co-workers, and from friends. It has been a while since I had been around forums, but I recently decided it was time to get back to what started me in the SQL community: answering questions. Not only is it complementary to my current job as Simple-Talk editor, it is really a great joy to be able to help other people with their problems. It is also educational to see the kinds of things other people are going through before you also go through them.
The post How to ask for programming help appeared first on SQLServerCentral.

This is a survey from us at dataplatformwit.com to understand why /how you, as a woman technologist are engaging with community. We ask that women in the data community please fill this out.
The post WIT Engagement Survey For Female Speakers appeared first on SQLServerCentral.

SQL Server Integration Services (SSIS) has been the de facto ETL tool for over 15 years for DBAs, Developers and Business Intelligence Professionals to extract, transform and load data (i.e. ETL tasks) for specific business processes, data-centric applications, data warehousing, reporting and data exchange between organizations. SSIS is a great product with high adoption across the globe, but has some limitations related to modern data sources, performance and streamlining tedious tasks. How can we overcome these limitations and have SSIS provide greater value?
The post Enhancing SSIS ETL Tools with SolarWinds Task Factory appeared first on SQLServerCentral.

Learn how you can connect ChatGPT to VS Code and use it to help you fix your code.
The post How to work with ChatGPT in Visual Studio Code appeared first on SQLServerCentral.

As we continue into the era of supporting more and more database platforms in our data estates, self-monitoring goes from being a very difficult task to a truly daunting task. I am personally advanced at diagnosing Microsoft SQL Server performance issues, but when that PostgreSQL server gets added, I just have to hope nothing goes wrong for a few years while I learn.
The post Why a monitoring tool is an essential tool for growing server estates appeared first on SQLServerCentral.

Many organizations struggle with democratizing access to data and analytics in the cloud, particularly for self-service purposes. As a result, data and analytics projects often require significant IT involvement, leading to delays, bottlenecks, and inefficiencies. Additionally, data analytics, ELT, and BI tools often require specialized technical expertise, making them inaccessible to a broader range of users. To address these challenges, organizations can adopt cloud-based data and analytics platforms that provide self-service capabilities and support modern cloud data management approaches.
The post Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches appeared first on SQLServerCentral.

The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary costs more to host in the cloud and affects the bottom line for your organization.
The post Performance Tuning with SQLFacts Tools appeared first on SQLServerCentral.