Visualizing Azure Resource Metrics Data in Power BI
Learn the five steps to perform Azure resource reporting with Power BI in order to embed the reports in dashboards for stakeholders.
2020-11-23
Additional Articles
Managing Cross-Database Object References
Phil Factor explains cross database and cross-server references, how to find them in your code, and when it's better to avoid hard-coding these references and use synonyms instead.
2020-11-20
SQL Server
I am new to SQL Server and I have heard the term used in a number of different capacities and in different contexts. So what exactly is it? What are the common components? How does it work? How do people use it? I am brand new to the technology, where do I get started?
2020-11-20
DBA in training: Security
Securing data is not always easy to do, but it should be the top responsibility for database administrators. From protecting the physical servers to preventing copies of backups files from getting into the wrong hands, there is a lot to consider. In this article, Pamela Mooney covers what DBAs need to think about when securing their organisation’s data.
2020-11-19
Free eBook: Performance Tuning with SQL Server Dynamic Management Views
Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.
2020-11-18 (first published: 2013-08-21)
108,349 reads
What is database continuous integration?
Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you ever wish that they would be of better quality, quicker to change, and cost less? Grant Fritchey explains some of the secrets of doing Continuous Integration for Databases to relieve some of the pain-points of the Database Delivery process.
2020-11-18
Improving SQL Monitor’s Database Performance
Jeremiah Peschka, a tech lead for SQL Monitor development, explains the new SQL Server configuration options available for the data repository, and how enabling them might improve SQL Monitor performance, when reading and writing monitoring data.
2020-11-17
SQL Database Project with Git Feature Branch Workflow
In this tip we look at how to work with SQL Database Projects using Git source control and using branching to work on different features.
2020-11-17
Bridging the Divide between Data Management and DevOps
Join Microsoft Data Platform MVP, Grant Fritchey to discover the key strategies you can implement to bridge the divide between data management and DevOps in your organization.
2020-11-16
Using Triggers to Replace Scalar UDFs on Computed Columns
Using Triggers to Replace Scalar UDFs with Brent Ozar.
2020-11-16
Blogs
Comparing an Old Running Total to Window Functions
By Steve Jones
Often I see running totals that are written in SQL using a variety of...
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Forums
Cannot connect to Analysis Services via Excel
For myself this seems to work and for other users they receive this error:...
Azure Managed Instance Backup Schedule with SQL Job
Lets do configure backups in my own in Azure Managed Instance......My Lead has directed...
Migration Assistant Issues
Comments posted to this topic are about the item Migration Assistant Issues
Question of the Day
Migration Assistant Issues
If I run the Data Migration Assistant to check for an upgrade from SQL Server 2008 to SQL Server 2022, which categories of issues are pointed out as potential items that can affect an upgrade? (choose 3)
See possible answers