Comments Feed

Increasing your Storage Efficiency with SQL Server Stretch Databases Commented on: 1 year ago (May 19, 2016)

Mike, is this feature available across all versions of SQL 2016, or Enterprise only?

The Essential Guide to SQL Server 2014 Series: Buffer Pool Extensions Commented on: 2 years ago (May 26, 2015)

Good writeup, Mike...I'm just a little confused about the one line "If it’s not limited SQL Server will dynamically grow the Buffer Pool until the maximum available memory in the server is between...

What's the Difference Between a Data Architect and an Enterprise Architect? Commented on: 2 years ago (January 29, 2015)

In the Zachman Enterprise Framework(tm) there are six levels, or layers of worker-types. This doesn't mean that one person will inhabit just one layer -- in many cases, in many companies, one...

SQL Server Distributed Replay Commented on: 3 years ago (September 29, 2014)

Jody, I don't think I understand...if the Microsoft SQL Server Distributed Replay feature is meant to help you assess the impact of future SQL Server upgrades, how can it do that if you can't/...

Tempdb: Checksum or Torn Page Detection (or None)? Commented on: 3 years ago (September 17, 2014)

Is there ever a situation where you'd want to use TORN PAGE DETECTION, say, for instance, for backward compatibility? Personally, I don't think I'd want to be backwardly compatible for that...

Why Aren't We All Great SQL Server DBAs? Commented on: 3 years ago (September 3, 2014)

I think I'm hearing you say that the "SQL rock stars" are driven, have extraordinary focus, and/or passion for the product...that they don't leave the work at work but rather it lives inside them...

The SQL Server 833, What Is It? Commented on: 3 years ago (August 25, 2014)

These are terrific suggestions of where to look and what to do when you get there. I wish that the vendor storage engineers and I had been able to observe first-hand what was going with the...

The Trouble with Type Tables Commented on: 4 years ago (January 29, 2013) Good job explaining reasons to use what you call "type tables", what I call "lookup tables". Couple this articles with InstantDoc ID #48811, which I wrote back in 2006, and you...
A Case for Shorter SQL Server Conference Sessions Commented on: 5 years ago (March 24, 2012) I'm with you, Brian -- 60 minutes is just too long for any presentation other than a class or workshop. Thirty minutes I can do, like you said, once or maybe even twice a week. I've lost...
Will SSDs Cause Performance Tuning Experts to Go the Way of the Milkman? Commented on: 6 years ago (June 23, 2011) Brian, you have a point when you say "this is the first time Ive started to see a pattern of throwing hardware at the problem being a decent answer." Hardware, not only SSDs, is really...

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Jul 17, 2017
Sponsored

How Inferred Linking in Matched Records Digs Deeper into Your Data

Duplicate records clutter databases and render the data within them unclear. This kind of problem is very common, and it’s the main reason that deduping software exists. But there’s another benefit to deduplication software: the ability to infer connections between individual records from various data sets....More
May 22, 2017
Sponsored

Chief Data Officer Playbook: How to Be Successful in This Ground-Breaking Role

Companies looking to grow and extract value from their data are increasingly turning to Chief Data Officers (CDOs) to execute their data strategy. The role is new, and a playbook is necessary to address the many challenges CDOs face....More
May 12, 2017
blog

5 Common Challenges to Building BI in the Cloud

After spending 20 years building analytics, BI and database solutions, I've focused on Cloud data solutions over the past 2 years. I've chosen 5 common challenges that I face every day with Cloud migrations and that you'll face in your Cloud BI projects....More

Sponsored Introduction Continue on to (or wait seconds) ×