A weird issue with missing log data from the SQL Server Agent.
Erik Darling posted a great video with results i couldn't reproduce. Untill i stumbled on some clustered columnstore behaviour 😀
One way to find out why your database might be slow.
I love issues on old machines and editions... This one is about Error 3314 severity 17 state 3 combined with error 665.
This post is a response to this month’s T-SQL Tuesday #111prompt by Andy Leonard. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional topics every month. In this month’s topic Andy asks why do we do what we do? First and foremost, because i like it and because … Doorgaan met het lezen van Why do i do this?
In my previous blog i shared my experience on my first day of work at a new client (https://wordpress.com/read/feeds/90430081/posts/2132980200). After this initial day, time to get to know the sql estate at hand. Accounts were already taken care of, and i got the admin level. I can check whatever i want and it shows a … Doorgaan met het lezen van Analyzing an environment