SP2 must haves and SP2 compatibility
SQL Server SP2 was released last Monday. The links were posted on many blogs, so I won't repost any but the main one here. SP2
Menu
SQL Server SP2 was released last Monday. The links were posted on many blogs, so I won't repost any but the main one here. SP2
My SSIS whitepaper, which was available in draft form on the SSIS wiki, is live on the Microsoft web site today. For anyone who is
The companion whitepaper to my "Planning, Implementing, and Administering Scaleout Solutions with SQL Server 2005" whitepaper (see yesterday's post) is available. This whitepaper is called
Thought I'd answer one last question or two from the last time I did the talk on SQL Server 2005 plan guides. If you're asking at this point
Here's another blog posting to answer a question from over a month ago. With separation of users and schemas, its known that the CREATE USER
It's been over a month since I've blogged, confirmed by the previous blog entry when "it's sunny in Barcelona". Thought I'd blog about a question that
Last week at TechEd I was showing off Query Notifications. When I showed using the preprovisioned queue (overloads on SqlDependency.Start and SqlDependency constructor), a delegate
I've been doing my talk on try-catch in T-SQL for a while and whining about not being able to "rethrow" (via RAISERROR) a system error.
Sorry, I know that slogan has been used already. Thanks to everyone who showed up for the SMO/Powershell chalk talk at TechEd Barcelona today. Here,
I'm in Barcelona in TechEd and tomorrow I'm going to be doing a chalk talk on SQL Server Management Objects (SMO). Although I'd usually done my
When I discuss separation of users and schemas in SQL Server 2005, I usually think of ownership chains (that follow the object owner which is
When installing previous versions of SQL Server, I'd always keep a list of the exact privileges that a SQL Server service account would need. I'd
I've noticed that, as more companies want to run SQL Server applications 24x7x365 interest of clustering has increased dramatically. One of the most asked-for papers
Even now, although SQL Server 2005 has been for about 3/4 of a year, when I teach people about the new developer features, I'm still
There's an interesting article that caught my attention in this month's (July 2006) MSDN magazine by John Mollman about building the MSDN aggregation system. The
SQL Server 2005 implements quite a few technology pieces to help database developers and administrators acheive scale-out while acheiving the appearance of (or actually accomplishing)
Started my part of the festivities today with a chalktalk mentioning SQL Server DDL triggers and Event Notifications. But explaining Event Notifications meant explaining Service
I've been looking at the DLINQ syntax a bit more (I'm participating in a BOF at TechEd next week), and its always struck me how,
Been on the road lots lately, not much blogging, I'm afraid. I'll be making up for that… I "found" a new command line utility today
This one ought to be titled "Your error message is such a tease". I've always liked the fact that SQL Server 2005 error messages are verbose
Lately I've been working on using WMI events in conjunction with SQLAgent alerts and jobs to notify operators, queue up notifications for the DBA's resolution
You've likely heard by this time that Service Pack 1 for SQL Server 2005 was released earlier today/yesterday depending on what timezone you're in. Rather
I've been intruiged for a while with the idea of using SQL Server Express edition as a gateway from HTTP messaging to Service Broker messaging.
I don't know anyone that likes to wait for an application to respond. This is especially a concern with web applications; you start to wonder
Got the word today. Officially supported. Error in readme file. Reference this blog entry. Good to hear this.
I'm sure there's something about this in BOL somewhere, but this cost me a few more than a few ticks yesterday. Hoping to save you
Service Broker security is the subject of confusion even among people who think they know how it works. Some of the confusion occurs because security
After speaking yesterday and recanting my story (for about the 100th time) about EventData being XML as a “nefarious plot” to require DBAs to learn
I've been going over how errors are raised in SQLCLR against the SQL Server 2005 RTM version. If you remember (search the blog on "6522"
I like to read the readme files. There's often juicy little tidbits of info in there that won't show up by searching the BOL (that's
Now that SQL Server 2005 has been released, I'm becoming more "at one" with the tools. I've commented on a couple of cool features as
The last five blog entries were a lot of “off-the-top-of-my-head” list writing. Mostly remembering what people had said or the “I wish there were” comments. Just
OK, SQLCLR wish list comes last. Mostly because I'm tired of being accused of being a SQLCLR bigot; I think it was because our book
Transact-SQL has been around for a lot longer, the list will be a bit smaller. But the T-SQL enhancements in 2005 were numerous but, of
This one is about SQL Server Service Broker. It's not necessarily a cool or sexy feature, but may be the most revolutionary feature in there.
OK, because it was Michael that asked originally, XML/XQuery wishes for SQL Server 200x. In no particular order. Full compliance with "standard" W3C XQuery. If
It's just a few weeks until the launch of SQL Server 2005. I'm been hiding under a rock since returning from Hong Kong. TechEd there
After writing about a lot of new security features that were added since we published our "First Look at SQL Server 2005 book" its nice
This one's been around for a while, but don't think we'd mentioned it in the book. In addition to Windows logins and SQL logins, you
You’ve probably heard by now of the usage of the EXECUTE AS clause with procedural code. As in “CREATE PROCEDURE foo WITH EXECUTE AS OWNER”.
One of the things folks would always ask during the Ascend program was "anything new for application roles? do they support connection pooling yet?". Well,
In July 2004, encryption built-ins and key management had just been introduced in SQL Server 2005. Now its old news. They'll be a good-sized section
While working on the new edition of our book for after RTM, I've been looking around for security features that I missed or that didn't exist
About a week or two ago, there was a LONG discussion on the SQLCLR beta newsgroup about the fact that the IsNull property that you
I've been working on a student question about using Impersonation inside of a stored procedure. This one's worth sharing. You can do impersonation using the
In answering a question about schemas, users, and objects (search on "schemas" to see the blog series I, II, III), I realized I never posted
I'm known for my vivid imagination when making up test/exposition examples. I have a cat named Sam. So, once upon a time, I wrote: CREATE
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.