Cleanup SQL Server Query Store Data After Database Restore
In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.
2019-01-30
2,074 reads
Additional Articles
Overview of Azure SQL Database Performance Monitoring
Transitioning to the Platform-as-a-Service model typically implies relinquishing certain degree of control over your computing environment. One of the primary concerns related to this transition is diminished level of transparency providing insights into performance of cloud-resident workloads. Fortunately, with Azure SQL Database, you have a wide range of options that address this concern, allowing you to identify and remediate overwhelming majority of performance-related issues.
2019-01-29
2,366 reads
Introduction to SQL Server Security — Part 1
Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security and protecting data, but planning and effort are required to properly implement them. In this article, the first of a series, Robert Sheldon reviews the many components available to secure and protect SQL Server databases.
2019-01-28
2,859 reads
Query Store And Cruel Defaults
Erik Darling loves query store, but he really hates the default capture mode.
2019-01-25
2,931 reads
Getting Started with CQRS – Part 2
In this second article of the series, Diogo Souza walks you through creating the MongoDB code, the query side of the pattern, to complete the CQRS configuration.
2019-01-24
2,922 reads
SQL Server Reporting Services Report Builder with DAX Query Support
In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports.
2019-01-23
2,297 reads
Customizing the Default Azure Data Studio Dashboards
Explore the Azure Data Studio dashboards and see how to customize one of these dashboards to include a new widget.
2019-01-22
2,188 reads
Creating Measures Using DAX
In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the DAX language. This second article in the series explains what measures are, and how you can use DAX to create measures within Power BI. The formulae in the article apply equally well to PowerPivot and Analysis Services Tabular Model.
2019-01-21
2,447 reads
Do Functions Stop You From Using Indexes?
If you have a function in the WHERE clause, you might have heard you can't use indexes. That's not entirely correct.
2019-01-18
3,536 reads
Logging SQL and Change-Tracking Events in EF Core
Julie Lerman introduces you to the new logging APIs in .NET Core, concentrating on SQL and change-tracking events, with a focus on providers that output to the console and the debugger.
2019-01-18
2,083 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Alamat BCA KCP Modernland Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Alamat BCA KCP Cikande Telp:0821°8200°203
Telp/Wa 628218200203 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok...
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers