Database Offline – Redux
A database can be offline at the time that you take over responsibility of the database. You will be asked when it was taken offline. This script will help...
2019-04-15
6 reads
Blog Posts
Generating an SSH key on Windows
I needed an SSH key. First I needed to the WSL subsystem, and once I had that working, I could do the work I needed to do: get an...
2019-04-15
970 reads
How do I let someone execute a SQL Agent job they don’t own?
In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that ... Continue reading
2019-04-15
3,313 reads
Indexed Views – Performance Panacea or Plight
An indexed view is a view where the result set from the query (the view definition) becomes materialized in lieu of the virtual table result set of a standard (non-indexed) view. Many...
2019-04-15 (first published: 2019-04-01)
898 reads
Presentation 5: Presenting Performance Tuning with Memory Grants
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)
606 reads
Scaling SQL Elastic Pools
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
63 reads
Weekly reading #11
Good day folks! Let’s make this week great (again)! It is spring already there so it is easy to get up at 6am and write the blog! Now looking...
2019-04-15
53 reads
Global AI Night at WSB in Chorzów
The 2nd of April 2019 was a big day because of the two global IT events. The one was for developers as a new Visual Studio 2019 was born....
2019-04-13
42 reads
Notes from Orlando Code Camp 2019
Notes: Speaker party was well attended which makes it more interesting, the only downside was that the restaurant overall was LOUD, so much so that sometimes you’d have to...
2019-04-13
17 reads
The Two Year Plan
Earlier this year as I thought about what I wanted to try in Orlando related to the SQL community and thought about the time commitment, I realized it was...
2019-04-13
60 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers