SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)

I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL...

Re-blog – May 13-19

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week.  Oddly enough,...

Microsoft SQL Server 2008 R2 SP1

AdvertisementsMicrosoft SQL Server 2008 R2 SP1 CTP

SQL Server 2008 R2 SP1 10.50.2418.0 CTP is available now. You may download and test it.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=15dcfec2-abb8-409d-91ff-c7c8e18c8409

Quickly Find Your DDL Triggers with PowerShell

As a consultant I spend much of the first day or two at a client site discovering everything I can...

Replicating XML Columns

One caveat that’s worth mentioning is replicating the XML data type in
SQL Server using Merge Replication.  Sometimes, when replicating...

Presentation Deck For Hardware 201 at Denver SQL Server User’s Group on May 19, 2011

I got the chance to give an updated version of Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance...

IT and Innovation

This is a powerful quote:
“This is the digital world IT must keep up with–one where Apple can view a...

MCITP and ME

Last year (and this year too) I had set the goal to renew my certification.  I failed miserably at it last year with the exception that I at least...

MCITP and ME

Last year (and this year too) I had set the goal to renew my certification.  I failed miserably at it...

Change SQL Servers Authentication Mode with PowerShell

Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One...