Auto-Tuning and the #1 Mindset Problem I Had as a DBA
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for SQL Server? In this week’s episode, I talk about why...
2017-12-04
1 reads
A few folks have asked: will auto-tuning and adaptive query plans mean the end of performance tuning jobs for SQL Server? In this week’s episode, I talk about why...
2017-12-04
1 reads
Are you worried that you talk too fast when you give a speech, talk, or presentation? Is fear being a fast-talker one of the concerns that keeps you from...
2017-11-20
This post is part of TSQL Tuesday, a monthly blog party. You’re welcome to join in this party: if you’d like email notifications of future topics, here’s how to...
2017-11-14
I was lucky enough to serve as a judge for the Speaker Idol competition at the SQL PASS Summit conference this year. One of the great thing about watching...
2017-11-09
In this week’s episode, I’m not answering a reader’s question. Instead, I’m talking about my personal experience with anxiety. This episode touches on on healthcare, religion, and squishy emotions...
2017-11-08
1 reads
This morning, Dr Rimma Nehme tells us the story of the birth of Azure Cosmos DB, a global, scale-out database system. At the beginning of the talk, I can already...
2017-11-02
5 reads
Whee! It’s the first day of the main SQL PASS Summit conference and I made it to the keynote early for the first time ever. The hype says we’re going...
2017-11-01
SQL Server Service Packs are going away, starting with SQL Server 2017. I talk about why I think this is a good thing, and discuss Cumulative Updates, Service Packs,...
2017-10-06
People have strong feelings about SQL Server Management Studio: they love it AND they hate it. In this week’s episode, I talk about why people have such conflicting feelings...
2017-09-29
3 reads
A query is slow, and you figure out how to collect the query execution plan. Now what? In this video, I talk “big picture” about what execution plans are,...
2017-09-22
37 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...
Comments posted to this topic are about the item Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers