We recently discovered some of our databases in an Error State for SQL Server. Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup. They are working on a bug fix for it. For now, it suggested you set up something that checks your databases to see
Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following: Brent Ozar blogged about it in this article Building SQL ConstantCare®: Why People Aren’t Using Query Store. Erin Stellato blogged about it in this article Why Aren’t You Using Query Store?
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same time. So here is a quick little post on how you can schedule the workload to spread out across all your servers across
This month Rily Major (b | t) ask us to talk about how we are giving back to the community if we are or how we would if we aren’t, to lay out a plan. I’m already heavily involved in the community and haphazardly landed that way with no plan,
Well, three SQL Saturdays down for April. Raleigh which was local for me and I helped organize, Philadelphia where I got to give two talks, and Wheeling which made the news. At least this month we had spring weather for all of them. On the way to Philadelphia, the crew
Problem If you been reading this series you are used to looking at Windows and SQL Server but who knows what InfluxDB is and what to look at there especially if installed it on Linux. Lucky for us there is a dashboard to use to watch InfluxDB as well so
Problem As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system admins and share our new shiny toys and watch Windows using the same tools as SQL Server. Install and Configure Telegraf for on Windows The solution for this is fairly simple
This T-SQL Tuesday is brought to us by Jens Vestergaard (b | t), and we are asked to share our favorite SQL Server tools. Hint Profiler will not be on the list. But where do you start there are so many tools out there. In alphabetical order here are my top
Problem For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial backups, piecemeal restores, and for performance to separate your tables and indexes. You need different filegroups when looking at separating your indexes and tables and partitioning. Creating all these
I had two SQL Saturdays this month SQLSaturday Chicago and SQLSaturday Rochester both of which were very cold. Hopefully, the winter SQLSaturdays are over, for now, I want it to be spring and see no more snow for awhile. I know I’m a baby, but I’m used to North Carolina