Summary of 2020
Dave Bland
by dbland
2y 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
Visit website
A Faster Alternative to sp_helpdb
Dave Bland
by dbland
2y 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
Visit website
100th Blog Post: What I learned along the Way
Dave Bland
by dbland
2y 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
Visit website
SQL Server Assessment Using SSMS and SSRS
Dave Bland
by dbland
2y 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
Visit website
Ambiguous column name error when only using one Table
Dave Bland
by dbland
2y 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
Visit website
SSRS: Action setting To a URL or Report
Dave Bland
by dbland
2y 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
Visit website
Auditors are at your desk, Now what? – Sysadmin
Dave Bland
by dbland
2y 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
Visit website
Auditors are at your desk, Now what? – Backup History
Dave Bland
by dbland
2y 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
Visit website
Auditors are at your desk, Now what? – Job Failures
Dave Bland
by dbland
2y 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
Visit website
Investigative Reports: Global Temp Table Already Exists Error?
Dave Bland
by dbland
2y ago
We recently received a number of calls(just one really), that when the user tried to execute their query they get an error.  That error says the Global Temp Table Already Exists.  We thought this should not be happening, so we sent our reports in to investigate.  Their story is below. Before we get started, we ..read more
Visit website

Follow Dave Bland on Feedspot

Continue with Google
OR