On Sunday I learned of the passing of one of my greatest mentors, Major Herbert L. Day, USMC, Retired. He was Director of Bands at The Citadel, the Military College of South Carolina, from 1984-2004. My tenure there started in August 1991 and ended with graduation in May… Read more

Tuesday

PASS Application Development Virtual Chapter - Next-Level SQLCLR: Parallel Processing and Bulk Load - Adam Machanic

Pragmatic Works - Performance tuning the cube - Adam Jorgensen

Wednesday

PASS Data Warehousing/BI Virtual Chapter - SSRS R2: The New Stuff - Mike Davis

Thursday

Pragmatic Works - Data Mining Read more

SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in the business. We're offering free lunch. And we've got some awesome prizes, courtesy of our sponsors. I say we've got great names, so here are some of them:

Microsoft… Read more

 Yesterday I posted a review on the book Choosing to Cheat. I had begun putting some of the principles into practice long before I read the book, about 2 years ago, in fact.

Architect - A Popular Title Nowadays

In December 2001, I switched from being a senior SQL… Read more

 Cross-posted from The Goal Keeping DBA blog.

I first heard about this book at SQL Saturday #51 when I was talking with Joe Webb and Thomas LaRock. Joe was describing the basic premise of the book, which is that everyone has more to do than can possibly be… Read more

Monday

PASS Data Warehousing/BI Virtual Chapter - Adaptive BI: Engineering a BI Solution - Davide Mauri

Tuesday

SQL Lunch - Restartability in SSIS - Kyle Walker

Pragmatic Works - Does Your SSAS Cube Support Your Users' Reporting Needs? - Andrew Wiles

Wednesday

PASS Database Administration Virtual Chapter -… Read more

I know we were taught to share in kindergarten, but there are some things that should not be shared. In this case, I don't want to share a stomach bug that I caught from my wife that she has been suffering with the last couple of days. My morning began… Read more

EDIT: Updated to include a picture of me.

I'm headed up this weekend to speak at SQL Saturday #46 - Raleigh. This time I'll be giving two presentations, both on SQL Server security:

Fortress SQL Server

This is my standard OS to database security presentation, but I'll be… Read more

Here are the slides and scripts from last night's presentation at Midlands PASS Chapter. The presentation was intended to introduce folks to PowerShell and get them started with some of the basics.

A PowerShell Primer

Enjoy the ferret, and the reminder. Read more

This morning my laptop went to a crawl. I looked, and sure enough, there was an AntiVirus scan running. Argh! But it looked like the processor wasn't being hit that hard because the System Idle Process was still relatively high. Time to put into practice some knowledge I picked up… Read more

If you're thinking about attending SQL Saturday #48 - Columbia, SC and need a hotel room, our crew has done the research. Our criteria were:

1. Clean and safe
2. Close to the event
3. Free Internet

We're happy to announce that we have picked out 2 hotels that meet these criteria and… Read more

The sessions have been selected and we have posted the schedule for SQL Saturday #48 - Columbia, SC. A huge thank you to everyone who submitted to present. We appreciate your desire to help and grow the SQL Server community. Also, a big thanks to Allan Cothran (twitter Read more

I know I was one of the more vocal ones these past two years when the set of nominees were revealed. To the point where I jokingly recruited a bodyguard for SQL Saturday #48 - Columbia, SC since Stuart Ainsworth is going to be there and he and I have… Read more

Cross-posted from The Goal Keeping DBA:

Re-learning how to think is always a difficult process. My oldest son is starting the the 7th grade and he’s having to go through it. We homeschool, so we pick the curriculum. Since he’s consistently been above the 95% range with respect to… Read more

Tuesday

PASS Performance Virtual Chapter - Introduction to SQL Server Statistics - Andy Warren

Wednesday

Idera - Building a Data Mart with Integration Services - Stacia Misner

SQL Lunch - Let's Get Dimensional -From Requirements to Dimension Design - Adam Jorgensen

PASS Data Warehousing/BI Virtual Chapter - Data Mining… Read more

Note: Republishing because the article covering the issue and a workaround has been published here on SSC.

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed server role could do the following:

1. Create a new login.
2. GRANT…

Read more