Yearly Archive: 2010

A more reliable and more flexible sp_MSforeachdb

A more reliable and more flexible sp_MSforeachdb

Updated July 2018 I've complained about sp_MSforeachdb before.  In part of my "Bad Habits to Kick" series in 2009-10, I described how I worked around its sporadic inability to actually process all of the...

SSMS Tools Pack now supports Denali CTP1

SSMS Tools Pack now supports Denali CTP1

Earlier today, Mladen Prajdić (blog | twitter) released an updated version of his SSMS Tools Pack (v.1.9.4), a free add-in for Management Studio that provides a ton of helpful functionality that isn't available with...

Cumulative Update #1 for SQL Server 2005 SP4

Cumulative Update #1 for SQL Server 2005 SP4

Well, much quicker than I would have suspected, the SQL Server Release Services team has incorporated all of the fixes in 2005 SP3's CU #12 into the first CU for SP4.  Thanks to Chris...

SQL Sentry Plan Explorer : Version 1.1!

SQL Sentry Plan Explorer : Version 1.1!

Last week, Microsoft offered up an early Christmas present: SQL Server 2005 SP4.  This week, it's SQL Sentry's turn to play Santa Claus: several new features and fixes have been packaged up into SQL...

Cumulative Updates for SQL Server 2005 SP3 and 2008 R2 are available

Cumulative Updates for SQL Server 2005 SP3 and 2008 R2 are available

After releasing SQL Server 2005 SP4 on Friday (you can read more about it here), the release services team did not hang up their hats for the Christmas holiday, but continued working on other...

The curious case(s) of the Microsoft product naming department

The curious case(s) of the Microsoft product naming department

A long time ago, in a galaxy far, far away… Okay, it was here on earth, a little over 5 years ago.  With SQL Server 2005, Microsoft introduced a very useful feature called the...

SQL Server v.Next (Denali) : Metadata enhancements

SQL Server v.Next (Denali) : Metadata enhancements

In my previous job, we had several cases where schema changes or incorrect developer assumptions in the middle tier or application logic would lead to type mismatches.  We would have a stored procedure that...

SQL Server 2005 SP4 is here!

SQL Server 2005 SP4 is here!

Yes, the day has finally arrived, and a couple of weeks ahead of schedule.  Typically when Microsoft promises a release in Qx or Hx, the software comes on the last or second last day...

Slide Deck & Demos : Charlotte SQL Server User Group, 2010-12-15

Slide Deck & Demos : Charlotte SQL Server User Group, 2010-12-15

On Wednesday I presented my "What's New in Denali" presentation in Charlotte, NC.  Attached is a .zip file containing the PowerPoint presentation, as well as the scripts used in the demos and some sample...

What permissions are required for SET IDENTITY_INSERT ON?

What permissions are required for SET IDENTITY_INSERT ON?

SQL Server 2000's SET IDENTITY_INSERT ON topic says: Execute permissions default to the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and the object owner. While the SET IDENTITY_INSERT topic...

The old "do as I say, not as I do" problem

The old "do as I say, not as I do" problem

Microsoft is often considered a leader, an innovator, a trend-setter.  The same could be said for Apple, Google, and a host of other tech companies.  And each of those has its set of critics...

T-SQL Tuesday #13 : Business Expectations

T-SQL Tuesday #13 : Business Expectations

This month's T-SQL Tuesday is being hosted by Steve Jones (@way0utwest) over at SQLServerCentral.  For some history on T-SQL Tuesday, see Adam Machanic's posts here and here.  The topic this time is summarized as:...

Ola Hallengren adds STATISTICS support to his solution

Ola Hallengren adds STATISTICS support to his solution

Last week, Ola published a very useful update to his Backup, Integrity Check and Index Optimization scripts: the solution now supports updating statistics.  There are several options, such as only updating when the data...

SQL Server v.Next (Denali) : Deriving sets using SEQUENCE

SQL Server v.Next (Denali) : Deriving sets using SEQUENCE

One complaint about SEQUENCE is that there is no simple construct such as NEXT (@n) VALUES FOR so that you could get a range of SEQUENCE values as a set.  In a previous post...

SQL Server v.Next (Denali) : More on contained databases and "contained users"

SQL Server v.Next (Denali) : More on contained databases and "contained users"

One of the reasons for contained databases (see my previous post) is to allow for a more seamless transition when moving a database from one server to another.  One of the biggest complications in...

Slides : Philly SSUG, 2010-12-08

Slides : Philly SSUG, 2010-12-08

Attached are the slides and samples from my presentation to the Philadelphia SQL Server User Group on December 8 (Denali_PSSUG_20101208.zip).  Please let me know if you have any problems.   File Attachment: Denali_PSSUG_20101208.zip

SQL Server v.Next (Denali) : Another SSMS bug that should be fixed

SQL Server v.Next (Denali) : Another SSMS bug that should be fixed

Sorry to call this out in a separate post (I talked about a bunch of SSMS Connect items the other day), but Aaron Nelson (blog | twitter) jogged my memory today about an issue...

SQL Server v.Next (Denali) : Launch point for BI resources

SQL Server v.Next (Denali) : Launch point for BI resources

Microsoft's new data platform vision for BI is called BISM – Business Intelligence Semantic Model.  While I focus primarily on manageability, availability and database engine features, I'd like to keep tabs on who can...

SQL Server v.Next (Denali) : How has sys.databases changed?

SQL Server v.Next (Denali) : How has sys.databases changed?

Earlier, I documented the system objects that have changed in Denali.  One that caught my eye was a slew of new columns made available through sys.databases, mostly to support a feature I also blogged...

[OT] : An open blog post to bit.ly

[OT] : An open blog post to bit.ly

I am not sure when it happened, but at some point, bit.ly marked all URLs to connect.microsoft.com as dangerous.  So for example, I created this shortened link http://bit.ly/fKKQPT which just goes to http://web.archive.org/web/*/https://connect.microsoft.com/sql/.  When...