PowerPivot and Market Research

This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...

Spruced up query_io_reader.rb

I built a small ruby program a while back to help with two things:
 
Quickly identify what tables have the highest...

Spruced up query_io_reader.rb

I built a small ruby program a while back to help with two things:
 

Quickly identify what tables have the highest IO in a particular query
Learn a new language (Ruby)

 
The...

Spruced up query_io_reader.rb

 I built a small ruby program a while back to help with two things:

1. Quickly identify what tables have the highest IO in a particular
...

Tools to Monitor Performance of SQL Server

To gather statistical information on how a server is performing requires, you need to use operating system tools to gather...

Comparing Inline and Multi-Statement Table-Valued Functions

Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...

Dynamic Add/Remove file in Mirroring/Logshipping

Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...

Excerpt from Upcoming Book by Grant Fritchey Called Learn “SQL Server in a Month of Lunches”

Later this year, a new book by author Grant Fritchey, called Learn SQL Server in a Month of Lunches, will...

Meme 15 - LinkedIn

 The #Meme15 assignment from Jason Strate (Blog/@StrateSQL) for February is to describe how and why we use LinkedIn.  I felt...

PASS Data Arch VC presents Steve Simon - On Beyond Zebra AdventureWorks OR Where Did I Go Wrong?

I meet Steve when  he came down from New England area for SQL Saturday #28 IN Baton Rouge, LA. He...