DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Enterprise AI Trend Report: Gain insights on ethical AI, MLOps, generative AI, large language models, and much more.

2024 Cloud survey: Share your insights on microservices, containers, K8s, CI/CD, and DevOps (+ enter a $750 raffle!) for our Trend Reports.

PostgreSQL: Learn about the open-source RDBMS' advanced capabilities, core components, common commands and functions, and general DBA tasks.

AI Automation Essentials. Check out the latest Refcard on all things AI automation, including model training, data security, and more.

Avatar

Grant Fritchey

Product Advocate at Red Gate Software

Joined Dec 2015

http://www.scarydba.com

About

Grant Fritchey, Microsoft MVP, works for Redgate Software as their Product Evangelist. Grant has more than 20 years experience in IT including time as a developer, DBA and architect. He has written multiple books on SQL Server including "SQL Server Query Performance Tuning" and "SQL Server Execution Plans." He presents at conferences around the world.

Stats

Reputation: 3853
Pageviews: 934.8K
Articles: 13
Comments: 2
  • Articles
  • Trend Reports
  • Comments

Articles

article thumbnail
Extended Events: Avoid the XML
I ditched the XML, and so can you!
April 11, 2021
· 6,384 Views · 3 Likes
article thumbnail
Query Store as an Upgrade Tool
A clever way to use the Query Store.
March 22, 2021
· 6,268 Views · 3 Likes
article thumbnail
system_health Extended Events in Azure SQL Database
Explore system_health extended events in Azure SQL database.
March 14, 2019
· 4,445 Views · 4 Likes
article thumbnail
How Do You Export a Database in Azure Data Studio?
Let's explore how you can export a database with Azure Data Studio.
February 26, 2019
· 46,437 Views · 3 Likes
article thumbnail
SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations
SQL Server has made available in recent versions automatic tuning! Interested to find out how it can benefit your project? Read on to find out!
December 29, 2017
· 6,884 Views · 4 Likes
article thumbnail
Query Store Wait Statistics With sys.query_store_wait_stats
I absolutely love Query Store. But it's easy to get your data all jumbled up when sys.query_store_wait_stats comes into the mix.
December 24, 2017
· 5,297 Views · 2 Likes
article thumbnail
Database Fundamentals #8: All About Data Types
It's important to know the ins and outs of each of the myriad data types available in SQL Server. Look at those data types to see what you should use when designing your database.
August 30, 2017
· 21,953 Views · 5 Likes
article thumbnail
Database Fundamentals #2: SQL Server Management Studio
SSMS is where you'll spend most of your time while working with SQL Server, so getting introduced to it as early as possible is a great way to start learning.
Updated June 13, 2017
· 5,042 Views · 2 Likes
article thumbnail
Scheduling Statistics Maintenance in Azure SQL Data Warehouse
You can leverage your Azure SQL Data Warehouse to automate some of your maintenance. Creating a Runbook will let you schedule to your hearts content.
January 23, 2017
· 3,851 Views · 2 Likes
article thumbnail
A Sub-Query Does Not Hurt Performance
Just because it's on the Internet, does it make it necessarily true? What about the case of sub-queries affecting database performance? Read on to find out the truth.
October 25, 2016
· 7,511 Views · 6 Likes
article thumbnail
CASE Statement in GROUP BY
Sometimes tackling a problem in a single query isn't the best approach. We have a look at a scenario where a CASE statement is needed in a GROUP BY clause. What's the best way to handle this?
Updated June 29, 2016
· 20,934 Views · 2 Likes
article thumbnail
Elastic Query in Azure SQL Database and Views
Creating views that join across databases? Read this article to find out how to make those views play nice with Elastic Query.
Updated June 7, 2016
· 5,569 Views · 3 Likes
article thumbnail
Loading Data Into Azure SQL Data Warehouse
I’m not an ETL expert. In fact, I haven’t done any professional ETL work for several years. My skills are, at best, rusty. With this in mind, I knew I’d have a hard time extracting data from a local database in order to move it up to Azure SQL Data Warehouse. Read on to hear about my journey.
February 18, 2016
· 13,837 Views · 6 Likes

Trend Reports

Trend Report

Data Persistence

At the core of every modern application is an endless, diverse stream of data and with it, an inherent demand for scalability, increased speed, higher performance, and strengthened security. Although data management tools and strategies have matured rapidly in recent years, the complexity of architectural and implementation choices has intensified as well, creating unique challenges — and opportunities — for those who are designing data-intensive applications.DZone’s 2021 Data Persistence Trend Report examines the current state of the industry, with a specific focus on effective tools and strategies for data storage and persistence. Featured in this report are observations and analyses of survey results from our research, as well as an interview with industry leader Jenny Tsai-Smith. Readers will also find contributor insights written by DZone community members, who cover topics ranging from microservice polyglot persistence scenarios to data storage solutions and the Materialized Path pattern. Read on to learn more!

Data Persistence

Trend Report

Cloud Database

Trends in cloud data storage continue to accelerate at a rapid pace. Now more than ever, organizations must evaluate their current and future data storage needs to find solutions that align with business goals. While cloud databases are relatively new to the scene, they show tremendous prospect in securing and managing data.In selecting our topic for this trend report, we found the amount of promise and advancement in the space to be unparalleled. This report highlights DZone’s original research on cloud databases and contributions from the community, as well as introduces new offerings within DZone trend reports.

Cloud Database

Comments

SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations

Jan 05, 2018 · Duncan Brown

Sure thing. Happy to help.

Loading Data Into Azure SQL Data Warehouse

Mar 21, 2016 · Tim Spann

True, but once I had the conversion running through Powershell, it was really easy.

User has been successfully modified

Failed to modify user

ABOUT US

  • About DZone
  • Send feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends: