sqlservercentral.comSQLServerCentral – The #1 SQL Server community

Articles Editorials Stairways Forums Forums home Active threads Latest topics Most popular Leaderboard Scripts QotD Books Blogs Register Login Write for us Menu Articles Editorials Stairways Forums Forums home Active threads Latest topics Most popular Leaderboard Scripts QotD Books Blogs Write for us Register Login Crazy Interviews by Steve Jones SQLServerCentral Interviews Today Steve has a few thoughts about some of the nightmare interview processes tech workers are going through. Using Machine Learning Pipeline Execution Activity in Azure Data Factory by Sucharita Das SQLServerCentral Uncategorized This article shows how one can run a machine learning activity in an Azure Data Factory (ADF) pipeline. Read Data Stored in a Lake Database using Azure Synapse Analytics by Additional Articles MSSQLTips.com Microsoft Fabric (Azure Synapse, Data Engineering, etc.) In this article, we look at how to read data stored in a lake database using Azure Synapse Analytics to help reduce overall Azure costs. Honeybee Swarms by RyanBooz SQLServerCentral Community Editorial I love honeybees. This will be my seventh year as an amateur beekeeper, and aside from family or data, there are few other topics that I could easily spend an afternoon talking to you about. They’re amazing creatures. This past winter I had to move my beehives temporarily to the apiary of a friend. With […] Identifying Customer Buying Pattern in Power BI - Part 2 by Farooq Aziz SQLServerCentral Power BI In this article, we develop the Power BI DAX formula for basket analysis. It is the technique used in retail industry for market based analysis. Multiple Display Productivity by Steve Jones SQLServerCentral Work environment How many monitors do you need? Steve notes that having multiple ones seems to be a standard these days for tech workers. Do more make you more productive? Answer the poll today. Database Subsetting and Data Extraction by Additional Articles SimpleTalk ETL/SSIS/Azure Data Factory provisioning Let’s start by defining a subset and why you would require a data subset? When dealing with the development, testing and releasing of new versions of an existing production database, developers like to use their existing production data. Are IT Certifications Still Relevant? by Steve Jones SQLServerCentral Career Growth certification Certifications Steve talks about certifications today, after watching a video that showcases the benefits of why they are good for your career. Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining by Don-Kiely SQLServerCentral.com Ownership chaining Security Stairway Series Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely. SQL Server Filtered Index Essentials Guide by Additional Articles MSSQLTips.com Filtered Indexes Indexing Learn ing filtered indexes for SQL Server tables and some of the potential issues you might be faced with when using a filtered index. Next 1 2 3 … 1,899 Take Our Poll SSC Newsletters Subscribe to the daily newsletter to get fresh SQL Server articles, scripts and info every day, and Database Weekly for a roundup of all the big stories in the SQL Server world. Email SSC Daily Newsletter Database Weekly Blogs T-SQL Tuesday #174: Your Favorite Job Interview Question By Mala Mahadevan My blog has been quiet lately. I recently wrapped up a master’s program (more... I like KQL and I like managing my test data – are they mates? By HeyMo0sh Test Data Management (TDM) is essential in software development to ensure your application runs... T-SQL Tuesday 174 - Your Favorite Job Interview Questions By alevyinroc T-SQL Tuesday is a monthly blog party hosted by a different community member each... Read the latest Blogs Forums SSIS Connecting to Azure SQL Managed Instance w/ MFA By tjcavins We’ve been testing out Azure SQL Managed Instance and created SSIS packages to run... Summarizing Raw Sales Data with Group Summaries and Final Summary By Paul Stasny Greetings, I need to transform data returned in a query from several tables as... Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c By rpalani65sql Hi Replication and publisher configured on the same sql server 2022 version. Subscription to... Visit the forum Question of the Day The Query Traceflag If I want to enable a trace flag for a specific query, how do I do it? See possible answers About SQLServerCentral Contact Us Terms of Use Privacy Policy Contribute Contributors Authors...