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
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
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
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
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)
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
Got the word today. Officially supported. Error in readme file. Reference this blog entry. Good to hear this.
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"
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
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
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”.
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.