The Scary DBA

I recently flew from Boston to the UK through the Heathrow airport. It just happened to be on the day...

2018-01-02

693 reads

SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations

by Grant Fritchey

The Scary DBA

In Azure SQL Database for quite some time and now available in SQL Server 2017, Microsoft has put a lot...

2017-12-26

809 reads

Query Store Wait Statistics with sys.query_store_wait_stats

by Grant Fritchey

The Scary DBA

The second best thing to questions that people ask is when I sit down to write a book. It’s so...

2017-12-18

691 reads

Execution Plan Metrics and Units of Measure

by Grant Fritchey

The Scary DBA

Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I...

2017-12-26 (first published: 2017-12-11)

1,440 reads

SQL in the City 2017

by Grant Fritchey

The Scary DBA

Redgate is once again hosting a live, virtual event for SQL in the City. We’re going to give you a...

2017-12-08

317 reads

Why I Use AdventureWorks for Demos

by Grant Fritchey

The Scary DBA

I know that when some people see AdventureWorks, their vision turns all red around the edges, their blood pressure spikes...

2017-12-04

377 reads

Automating T-SQL Code Analysis

by Grant Fritchey

The Scary DBA

With all the options available within T-SQL these days, it’s more and more imperative that our code be clear and...

2017-12-11 (first published: 2017-11-28)

2,253 reads

Database Fundamentals #15: Modifying Data With T-SQL

by Grant Fritchey

The Scary DBA

The preferred method for modifying your data within a database is T-SQL. While the last Fundamentals post showed how to...

2017-12-11 (first published: 2017-11-27)

1,797 reads

I May Never Be a Data Scientist

by Grant Fritchey

The Scary DBA

Chances are extremely high that I’ll never put down Data Scientist as my job. Considering what you do and what...

2017-11-22

405 reads

Get That Profiler Feel in Extended Events

by Grant Fritchey

The Scary DBA

I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.
Unfortunately though, I think a lot...

2017-11-29 (first published: 2017-11-20)

1,399 reads

The Scary DBA

Snow, Heathrow Airport, Disaster Recovery

SQL Server Automatic Tuning and sys.dm_db_tuning_recommendations

Query Store Wait Statistics with sys.query_store_wait_stats

Execution Plan Metrics and Units of Measure

SQL in the City 2017

Why I Use AdventureWorks for Demos

Automating T-SQL Code Analysis

Database Fundamentals #15: Modifying Data With T-SQL

I May Never Be a Data Scientist

Get That Profiler Feel in Extended Events

Blogs

Five Ways Redshift Serverless Quietly Eats Your Budget

A Career of Memories

Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

Forums

Alamat Kantor BCA KCP Bumiayu Telp:0817866887

BCA KCP Permata Ujung Menteng Tlp:0817839777

Alamat Kantor BCA KCU RAWAMANGUN Tlp:0817839777

Question of the Day

BCP on Linux