Category: Admin

The #TSQL2sday #70 roundup

Post author By Jen McCown
Post date September 10, 2015
Categories In Admin, Advanced, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
6 Comments on The #TSQL2sday #70 roundup

Time for the T-SQL Tuesday #70 roundup! I asked people for their best enterprise management strategies, and they responded beautifully. Here we go. Rob Farley : Superhero powers for managing the enterprise. Rob talks about what his consulting company looks for when talking to a customer. Specifically, things that are out of the ordinary. And of […]

Time for T-SQL Tuesday #70!

Post author By Jen McCown
Post date September 1, 2015
Categories In Admin, sqlserverpedia-syndication, SSC, Tech and Learning
23 Comments on Time for T-SQL Tuesday #70!

Here is your invitation for T-SQL Tuesday #70, and the topic is: Strategies for managing an enterprise We define “enterprise” in a number of ways, but I tend to default to two definitions: “the things I’m in charge of” and “anything I don’t want to do manually”. In other words, you don’t need a large shop to have […]

Assigned reading: FREEPROCCACHE

Post author By Jen McCown
Post date August 25, 2015
Categories In Admin, Intermediate, sqlserverpedia-syndication, SSC, Tech and Learning

I don’t often find myself blogging for the sole purpose of showing you someone else’s blog, but today is one of those days. I’d like you to read Grant Fritchey’s excellent piece, “Targeted Plan Cache Removal“, for this reason: the more people have learned about parameter sniffing, the more popular DBCC FREEPROCCACHE() becomes. Grant’s post explains […]