At the end of my Denali presentation at SQLSaturday #65 in Vancouver, a member of the audience asked, "What makes a columnstore index different from a regular nonclustered index?" At the end of a...
Today I presented my "What's New in SQL Server 'Denali'" deck to about 40 attendees at SQLSaturday #65 in Vancouver, British Columbia. Attached below (and here) are the slightly updated slides and samples. File...
Early this morning (or late last night, depending on your time zone), the SQL Server Release Services team pushed out three new cumulative updates for SQL Server. KB #2489375 – SQL Server 2005 SP3...
My first toe-dip into SQL Azure was not as intuitive as I was hoping.
Last weekend I spoke at SQLSaturday #60 in Cleveland, Ohio. I had a great time catching up with some existing friends and colleagues, and met a bunch of new people too. I presented two...
Tip : Enforce SQL Server Database Naming Conventions Using Policy Based Management
This has come up in conversations more than once in the past little while – recently on twitter I made the casual comment that later this year, SQL Server 2008 will be "two versions...
This month's installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: "So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or...
Time is running out to register for the Master Immersion training events being held in Dallas, TX by SQLskills. These particular events will be instructed by Paul Randal (blog | twitter), Kimberly Tripp (blog...
I've already complained about this on Connect (see #641790), but I just wanted to point out that if you're trying to make sense of the sys.dm_exec_requests document and what it lists as the commands...
Almost two years ago, I blogged that Lock Pages in Memory was finally available to Standard Edition customers (Enterprise Edition customers had long been deemed smart enough to not abuse this feature). In addition...
Every time I attend a SQLSaturday, I leave with a rejuvenated and even further reinforced sense of community. Cleveland (SQLSaturday #60) was by far no exception. Allen White (blog | twitter), Erin Stellato (blog...
A while back, I started collecting links for free SQL Server resources available to everyone in the community. I created a blog post called "Useful, free resources for SQL Server" to serve as a...
Attached are the slide decks and demos from my two presentations at SQLSaturday #60 in Cleveland: What's New in SQL Server "Denali" T-SQL : Bad Habits to Kick
Twitter has provided some great fodder for blog content lately. And twice this week, I've found an excuse to take advantage of the default trace. Tonight @meltondba asked: I'm trying to find who created...
Earlier today I made a big goof. I opened a module in Notepad, intending to use it as the basis for a new module. I was in the process of using "File > Save...
