Deploy DACPAC to Azure SQL Database using Visual Studio
This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Visual Studio.
Understanding a Database
The ways in which you might try and reverse engineer a database design are on Steve's mind today.
INFO.VIEW DAX Functions Usage and Examples
In the December 2023 Microsoft Power BI Desktop release, more than 50 new INFO DAX functions were added. They all start with “INFO.” and return the same result as corresponding data management views (DMVs) that were available before only using a SQL-like syntax. With these new DAX functions, you can use the recently added DAX query to get metadata about your semantic mode
The State of the Database Landscape in 2025: Insights and trends
How are you navigating the database landscape? Our latest report sheds light on the current state of database management and offers valuable insights into how organizations can navigate and simplify the growing complexities of the database landscape.
Shadow AI Data Leak Risk or “From the Desk of I saw that Coming”
CSO recently published an article based on a report from Harmonic about generative AI data leaks, and the findings were eye-opening. According to the report, over 8% of employee prompts to public large language models (LLMs) contained sensitive data, ranging from security and compliance issues to privacy and legal vulnerabilities. This wasn’t just a handful […]
How to Download and Restore AdventureWorks 2019 Database
Learn how to download and restore AdventureWork 2019 Database.
Tracking Table Sizes
Today Steve asks if you track the details of your table growth inside a database.
Exploring Scalar Solutions to Complex Data Math
There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity.
An Effective Approach for High Volume Data in Azure Synapse
Learn about how you can efficiently load data in Azure Synapse.
The Job Outlook for Database Professionals
The job outlook for database professionals is good, but it's not that easy to get a great job. Steve has some advice for you today.
Blogs
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
A New Word: Waldosia
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
Deploy at Low Priority
By Zikato
Learn how to deploy schema changes in an always-online SQL Server environment without a...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
using Sql without using Pivot .
Hi How to get the below data we can create dynamically using Sql in...
Partial Backups II
Comments posted to this topic are about the item Partial Backups II
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers