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

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

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

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

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.