How to Manage Date Formats in the Power BI Service
Learn how to properly configure input date formats for Power BI reports for any type of browser so users always get the results they expect.
2021-05-17
Articles
Win DevOps books with Redgate’s competition
Redgate is giving you the chance to win your choice of DevOps books and Redgate goodies in their latest competition. To enter, visit the Redgate Forums and answer the question: ‘How is SQL Change Automation helping you?’
2021-05-17
SQL Server Integrates Hadoop and Spark out-of-the box: The Why?
Why has Microsoft added new capabilities in SQL Server to connect to other types of data sources? Read on to learn more.
2021-05-14 (first published: 2019-09-09)
10,596 reads
SQL Server T-SQL CASE Statement Examples
This tip will teach you when and how you can use CASE in T-SQL statements with several code examples to give you a better understanding.
2021-05-14
Your Top 10 Ideas for SQL Server
You’ve submitted thousands of bug reports and feature requests at feedback.azure.com. Brent Ozar goes through what you’ve voted as the top 10 requests right now.
2021-05-14
Automating Azure DevOps with Logic Apps
Azure Logic Apps can be used to automate steps like sending approval emails. Elie Bou Issa explains automating Azure DevOps with Logic Apps.
2021-05-12
Take our survey to win a $500 Amazon gift card
Take the 2021 State of Database Monitoring survey and tell us about how you monitor your databases, instances and servers. By taking the survey, you’ll contribute to (and get early access to) the leading industry-wide report on database monitoring, and be entered to a prize draw for a $500 Amazon gift card.
2021-05-12
Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation
Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the desired rows and changes them while synchronously writing to the transaction log […]
2021-05-10
8,498 reads
Running Dynamic Code Quality Checks on Flyway Databases: Table Smells
How to extend the range of SQL code analysis, during database development, to include dynamic analysis of the database metadata. This will allow regular checks for problems with the design of your tables and indexes ("table smells") that can affect database performance and data integrity.
2021-05-10
SQL Server Sequence Numbers
In this tip we look at the Sequence Number feature in SQL Server and compare it to the use of identity columns.
2021-05-10
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers