Things I Learned at Summit v20 - Trace Flag 4199
Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this first post...
2018-12-14 (first published: 2018-11-29)
3,595 reads
Blog Posts
Change Tracking Inserts Require SELECT Permission
I’ve been writing about change tracking in SQL Server for some time now, but I recently came across a permissions...
2018-12-13
203 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the...
2018-12-13
44,157 reads
Difference Between Restore with Recovery & Restore with Norecovery
Every tech-conscious person is familiar with restoration process in the world of computing. This process is usually followed by the process of backup. In case of SQL Server, restoration...
2018-12-13
67 reads
Maintenance Plan Owner – Back to Basics
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2018-12-13
228 reads
Maintenance Plan Owner – Back to Basics
Have you ever taken over a server that had several maintenance plans on it? Have you ever really checked who the owner of those plans is? Or, maybe you...
2018-12-13
44 reads
Naming Convention Hall of Shame
Call me pedantic, but I can be a stickler for standardized naming conventions. Whether it’s application code, database objects, documentation,...
2018-12-13
211 reads
New Resumable Online Index Create SQL Server 2019
SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...
2018-12-13 (first published: 2018-11-28)
2,244 reads
Power BI Monthly Digest – December 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-12-13
587 reads
Setting up CentOS to run docker for SQL Server
This blog post is about running SQL Server in a docker container on CentOS Linux distribution.
This was both an experiment...
2018-12-13
289 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