Dave Bland
106 FOLLOWERS
My blog about SQL Server and related technologies. My current position is as a Data Architect at Stericycle prior to that I supervised the Shared Services DBA team for 4 years. I have worked as a DBA in a number of industries including casino industry, insurance industry as well as the transportation industry.
Dave Bland
1y ago
This is a blog about some additions I made to the reports I talked about in another blog post. That blog post can be found here: https://davebland.com/sql-server-assessment-using-ssms-and-ssrs I added a number of new reports as well as monitoring functionality. These reports can be found by following the link below. Report and Monitoring Tool While this ..read more
Dave Bland
1y ago
Sometimes we find things that are hidden that are very good….Easter eggs in video games can be fun, the unexpected $20 bill in the dryer or even the pot of gold at the end of the rainbow. And then there are the times that we find something hidden that isn’t as good as we would ..read more
Dave Bland
1y ago
I have now been blogging about SQL Server for almost 18 months. Along the way I have learned a great deal and hopefully have also helped a few folks along the way. From time to time I will go back and look at older posts. When I did that recently I came to realize that ..read more
Dave Bland
1y ago
Over the years I have been asked to complete assessments on SQL Servers many times. The need for these assessments have varied from gathering information needed to address a current performance issue to gathering evidence for and audit to just wanting to know more information about a particular server. I have found some great information ..read more
Dave Bland
1y ago
Every once in a while I see something in SQL Server that has what I think are “Unexpected Results”. This is the case recently. I received the dreaded ambiguous column error when only using one table. My first thought was how can that be when I am only using one table. Just a bit of ..read more
Dave Bland
1y ago
Over the years I have created a number of SQL Server Reporting Services reports. I remember when SSRS first came out, I believe somewhere around 2002, I was thinking that this will be a great product to work with. And indeed, it has turned out to be a great tool when used in the right ..read more
Dave Bland
1y ago
This is the third in a series of how to help the DBA survive an audit. The post will focus on how to get the information about who has Administrative rights on the server. The first two can be found here. Job Failures Database Backups Having worked for both a casino and a publicly traded ..read more
Dave Bland
1y ago
This is the second in a series of posts about how to survive an audit. These posts will include some basic guidelines I have learned over the years as well as how to get the information I have been asked to provide. Having worked for both a casino and a publicly traded company, audits have ..read more
Dave Bland
1y ago
Having worked for both a casino and a publicly traded company, audits have been a big part of my job for quite a few years. These audits come in many different shapes and sizes, however there are some things that they all have in common, the auditors want evidence!!! And lots of it! Surviving an ..read more
Dave Bland
3y ago
As everyone knows 2020 was a tough year. However, there were still many good things that happened, although sometimes it is a bit more challenging to remember them. I thought I would do a simple review of my year. Here are the numbers: C# Corner Blog Posts – 7 C# Corner Page Views – 19,000 ..read more