Profile cover photo
Profile photo
Anders Pedersen
16 followers
16 followers
About
Posts

Post has attachment
Archiving Data
Many times as a DBA I have taken over a system that has had data gathering for years.  The worst I took over had about 400 million records in the main table, with an average of 24 records in the secondary related table per primary record, data going back 12...
Add a comment...

Post has attachment
SentryOne cleanup, PerformanceAnalysisDataTableAndIndexCounter table
SentryOne is a great tool for monitoring servers, but with a lot of "chatty" servers, the amount of data collected can become unwieldy.  With about 65 servers monitored, the delete functionality in SentryOne could not keep up with the deletes in the Perform...
Add a comment...

Post has attachment
Backup Restore Chain re-visited, again.
(This is an update to Backup Restore Chain revisited  I posted February 2016) . In the morning hours our disk system lost the log files for all my user databases due to a firmware bug....  The connection to the disks could not be re-established and new driv...
Add a comment...

Post has attachment
T-SQL Tuesday #83. We're still dealing with the same problems.
This months T-SQL Tuesday is hosted by Andy Mallon at  T-SQL Tuesday #83  , the subject is "We're still dealing with the same problems." In the 20+ years I have been working with MS SQL Server, some issues continue to pop up, miss configured NIC settings, b...
Add a comment...

Post has attachment
First time presenting at a SQL Saturday (#560 Charlotte)
Back in February I ended up doing a presentation called IO Tuning 101 for the local PASS chapter, so when the local BI PASS chapter announced they where looking for speakers for a SQL Saturday in September I cleared my schedule and decided to send in my sub...
Add a comment...

Post has attachment

Post has attachment

Post has attachment

Post has attachment
T-SQL Tuesday #76, text searching the hard way
T-SQL Tuesday #76 invite Text searches.    Possibly one of the least fun things to do in SQL. Back in the days before Full-Text Search in SQL, I was tasked with replacing the search engine at ABC Radio News, this search engine helped them research any broad...
Add a comment...

Post has attachment
Wait while more posts are being loaded