Updated Thoughts on Antivirus on SQL Servers
I hate running antivirus on SQL Servers. I agree antivirus is a necessary evil on most systems, but I don't...
2012-04-30 (first published: 2012-04-24)
5,838 reads
Blog Posts
You need to run DBCC CheckDB regularly
You never know when you’ll encounter corruption. It can happen at any time, usually due to some sort of hardware...
2012-04-30
3,338 reads
Always use Configuration Manager for changing service account
When your service account is expired/disabled or is not having access than sql service could not able to start and you may...
2012-04-28
1,778 reads
Exposing OData Endpoints using the ASP.Net MVC Web API
The new Web API that comes with ASP.Net MVC 4 has been getting a lot of posts on creating RESTful...
2012-04-28
99 reads
SQL Saturday 130 Deck & Scripts Live
Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville. This is just a quick post to say that the...
2012-04-28
1,177 reads
Appending New Rows Only
I saw a question in the forums related to inserting new rows into a SQL Server table only if they...
2012-04-27
5,542 reads
Big Apple SQL - SQLSaturday #158 NYC Announced!
Come this August 4th, 2012, the Big Apple will be baking, but not just because of the hot summer day...
2012-04-27
1,866 reads
Comments on Acceptable Behavior
Here’s the situation. We’re absolutely falling down as men and professionals. Ladies, feel free to read on and comment, but...
2012-04-27 (first published: 2012-04-23)
2,618 reads
Cool Data Visualization
I attended a course from Edward Tufte a few years ago on Data Visualization, and while I learned some neat...
2012-04-27
2,019 reads
Slacking Off: Totally TED
Lately I’ve taken to watching TED talks in the evening. They’re thought-provoking, usually entertaining, and, best of all when watching...
2012-04-27
953 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers