Tags » Microsoft SQL Server

Exploring system tables, views, SPs etc

I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have available to you within SQL Server. 459 more words

SQLServerPedia Syndication

I've gotten a transaction log full error but when I look it's not full??

Every now and again I’ll get an error telling me a transaction log is full. This can be for any number of reasons (make sure you are taking log backups on your full recovery databases) but many of my co-workers (DBAs and others) get really confused when they check and low and behold the log is not only not full, but it’s empty. 161 more words

SQLServerPedia Syndication

Analyze IIS log using PowerShell

In my last blog, you learn how IIS (or similar) log can be uploaded to SQL DB. Once logs are uploaded you can analyze it using PowerShell and create fancy report as well. 408 more words

Microsoft SQL Server

Upload large logs files to SQL database

Most of us will agree if I say “SQL server is one of the powerful engine for query, reporting and statistic purpose”. As part of application troubleshooting, we come across many different set of logs those can be open in Notepad OR similar tools however it’s very different to take stats out it OR even open if it large. 555 more words

Microsoft SQL Server

Deleting a lot of data

I recently had the task of deleting a bit over a billion rows from a table. Now I could have done just this:

DELETE FROM tablename WHERE createdate >= '1/1/2017' 490 more words
SQLServerPedia Syndication