A Domain for Data
A SQL DDL statement that Steve never knew about is the subject of today's editorial.
A SQL DDL statement that Steve never knew about is the subject of today's editorial.
Introduction As you may know, in the early days of SQL Server Clustering, Microsoft advised to provide each clustered SQL Server instance with its own Microsoft Distributed Transaction Coordinator (MSDTC) resource. Since SQL Server 2012 this advice has been withdrawn. Microsoft now recommends to provide your instance with its own MSDTC resource, once you notice the […]
If you don’t know, DAX (Data Analysis Expressions) is a language for creating custom calculations and aggregations in Power Pivot, Power BI, and other data analysis tools. Two functions in DAX come close to replicating the functionality but come with limitations. Which one of these functions should you use?
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.
In this next article we look at how to use Generative AI to build tables.
DevOps includes the idea of measuring how code flows through your organization and looking for ways to improve your software development process. Steve has a few thoughts on the four main metrics many developments use.
In this first level of the Stairway to Synapse Analytics, we learn how to set up a new workspace and add data files.
In this second level of the Stairway to Synapse, we learn how to create external tables and query data that is stored in our data storage using the serverless pool.
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creation of the Synapse Workspace. In Level 2, data analysis was done on Data Lake files using Serverless SQL Pool. In Level 3, I will analyze data from the files uploaded in Data Lake container using a Spark Pool. I will […]
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creating the Synapse Workspace. In Level 2, we analyzed Data Lake files using the Serverless SQL Pool. In Level 3, we analyzed Data Lake files using the Spark Pool. In Levels 4 and level 5, I will discuss the Delta […]
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Understanding how permissions work in Microsoft Fabric can be essential for anyone managing access...
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
Comments posted to this topic are about the item Rolling Back CUs
Comments posted to this topic are about the item A Domain for Data
Comments posted to this topic are about the item Windows Clustered MSDTC and SQL...
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers