Automatic Query Performance Tuning in SQL Server Database
In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.
2018-07-10
4,171 reads
Additional Articles
Azure and Windows PowerShell: Getting Information
In the second part of his series, Nicolas Prigent describes in detail how to automate the login process using PowerShell and Azure CLI. Nicolas also explains how to retrieve information about your Azure subscription.
2018-07-09
2,531 reads
How to Fix sp_BlitzIndex Aggressive Indexes Warnings
Either you've got too many indexes, or not enough. Here's how to tell.
2018-07-06
2,870 reads
Using Parameters for SQL Server Queries and Stored Procedures
One of the benefits of SQL is the ability to write a query and use parameters to dynamically act upon the resultset. Depending on the situation, there can be benefits to parameterizing queries, but it is not always clear when or how to do this. In this tip we look at different ways to pass in values as parameters to queries and the advantages and disadvantages.
2018-07-05
3,805 reads
Missing Data
Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.
2018-07-04
2,461 reads
Azure SQL Database and GDPR Compliance
In recent years, technology landscape has undergone dramatic changes, driven primarily by cloud computing and a continuously increasing level of attention dedicated to security, privacy, and compliance. One of the more significant initiatives that attempts to address these challenges is General Data Protection Regulation (GDPR. In this article, we will explore how Azure SQL Database could help with addressing the GDPR requirements.
2018-07-03
2,311 reads
Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3
R is a powerful language for manipulating data and creating visualizations. In this article in the series, Robert Sheldon demonstrates how R can be used within Power BI Desktop to import data and to create visualizations.
2018-07-02
2,546 reads
Data Governance, DevOps, and Delivery
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to...
2018-06-29
2,318 reads
Introducing Microsoft BI Reporting and Analysis Tools
Choose the right BI tool by learning about the different strengths of the Microsoft analysis and reporting tools. Microsoft provides a variety of BI tools that can address key workloads, such as Power BI and Excel. The article discusses the workloads and the tools that best support each workload.
2018-06-29
3,416 reads
Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI
In this tip, you will be walked through a method to calculate MTD, QTD, YTD and running total in Power BI. This method is useful in stock calculations and balance sheet calculations.
2018-06-28
3,361 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
ALAMAT BCA KCU INDRAPURA 082225313145 WA CS
WhatsApp 082225313145 Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
Alamat Kontak BCA KCP Semut 082225313145 WA CS
WhatsApp 082225313145 Jl. Bongkaran No.17-19, Bongkaran, Kec. Pabean Cantian, Surabaya, Jawa Timur 60161
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers