Cosmos DB – Monitoring performance
Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query...
2023-11-29 (first published: 2023-11-15)
209 reads
Cosmos DB has become my latest focus and I hope to start sharing more about ways you can use it. Cosmos DB doesn’t provide the same granularity of query...
2023-11-29 (first published: 2023-11-15)
209 reads
So it’s about a week after SQL Saturday Chicago 2019. The event was amazing, tons of great people and in a great venue. Here’s the details of what happened...
2019-04-15 (first published: 2019-04-01)
574 reads
My presentation so far is really rough. I need to improve a lot before SQL Saturday Chicago! For now, the...
2019-03-20
996 reads
This is a trick I use in SQL Server Management Studio at least once a week.
Today’s scripts will be screenshots...
2019-03-18 (first published: 2019-03-02)
3,143 reads
This is a series I’m writing as I prepare for SQL Saturday Chicago 2019. My session is called Performance tuning...
2019-03-18
302 reads
I’m taking a brief break from daily blogging, even though it has been a ton of fun.
No excuses
I hope...
2019-03-11
214 reads
Happy Friday! We made it. Here’s something I came across while testing optimize for ad hoc for this week’s blog...
2019-03-11 (first published: 2019-02-22)
2,093 reads
Here’s some of my favorite community scripts and how I like to run them. If you haven’t tried the optional...
2019-03-09
613 reads
This series is about my process for writing my upcoming presentation at SQL Saturday Chicago #825.
Today’s goals
Today I’m going to...
2019-03-08
327 reads
A single use plan is an entry in the SQL Server plan cache that was only used once. When a...
2019-03-07 (first published: 2019-02-19)
3,316 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers