How DO you change your SQL Login password?
SQL Server 2005 will, by default on Windows Server 2003 systems, enforce password policies for SQL Server logins as well as Windows logins. Nice feature,
Menu
SQL Server 2005 will, by default on Windows Server 2003 systems, enforce password policies for SQL Server logins as well as Windows logins. Nice feature,
For a long time I’ve been griping that SSMS projects (SQL Server Script projects) use absolute pathnames rather than relative paths. I didn’t think it
I’ve heard rumblings on various newsgroups that our book “A First Look at SQL Server 2005 for Developers” is getting a little long in the
Here's something I've noticed you can do with SQL Server 2005 and Visual Studio 2005. Take a set of XML documents with the same basic
With April CTP came the new combined managed provider replaces System.Data.SqlServer with a new improved, works in-process or out, System.Data.SqlClient. I just call it “the
One of the nice surprises in the April CTP is that SQL Server 2005 XML schema validation errors come with a location now. That's handy.
Realized that I haven't blogged in a while. I been …uh…working on stuff and traveling a lot lately. Big surprise, right? This week I'll be
Saw another Kent post on TechEd 2005. I’ll be there too (mixed marketing slogan message with SQLPass). I’m doing a talk on “SQLCLR vs. T-SQL:
Catching up on blog-reading. Kent Tegels wondered if I was speaking at SQLPass Community Summit. Yep, I am. I’m doing a 2-day pre-con on (what
Speaking of SQL Profiler brought this to mind. The number one feature that brings a smile to every DBA's face: GRANT ALTER TRACE TO [somedev] No
I've always liked the graphic showplan in SQL Server query analyzer. The biggest hassle with it came when you wanted to send the plan to
When I did my first demonstration with the combined SqlClient and SqlServer provider in the April CTP version of SQL Server, I was a bit
The last blog entry brings up the question of what I mean when I say something is "unsupported" in SQLCLR. Becuase I've said that J#
Looking at the Feb CTPNotes file again, there's another change that caught my eye. DROP ASSEMBLY has changed with respect to dependent assemblies. In past,
The data access team (known as DataWorks) has started up a team blog. Some of the individual team members, like Angel Saenz-Badillos and Sushil Chordia,
In this last entry on Service Broker enhancements I inadvertantly referred to the new poison message handling as poison conversation handling. Well, maybe it wasn't
I've been doing some experimenting with the new SQL Server Service Broker features in Feb CTP. You can read about them in the CTPNotes.doc file;
When reading the CTPNotes file from the new Feb CTP build I stumbled across the fact that the XML schema that contains SQL data types
In the new Feb CTP release, how your implement a table-valued function in SQLCLR has been re-architected. This is in the readme (CTPNotes) This was
Hi all. Not much blogging out of me lately. I’ve been on vacation and, in between, I’ve been teaching SQL Server 2005 at Microsoft Sydney
My cohort, Dan Sullivan, has released the Service Broker Explorer on his Service Broker Developer's Spot website. It a graphic user interface for Service Broker
Just catching up on my blogging before a little vacation next week. Browsing through the SQL Server BOL from the December CTP, I came across
I had a few spare cycles to do some reading recently, and thought I would check out the new Unified Dimensional Model (UDM) that can
In the last blog entry I talked about using System.Transactions in SQLCLR code. But don't try this yet, the keyword here is *will* be used.
There's been a lot of interest in the new System.Transactions.dll assembly lately. Especially from users of SQL Server 2005. This is based around two functionality
People (especially DBAs) want to see what those pesky appdomains are doing in SQLCLR. Back in beta1 there was a system function, master.sys.fn_appdomains(), that showed
I’m back home again after being on the road three weeks out of the last four. Internet access was good, except for one hotel. I
Here’s the answers to the question from Fun With static XQuery evaluation – 2 — start with a schema collection CREATE XML SCHEMA COLLECTION ages
After the last two entries, you might be thinking "I guess I can never use text() as a node test with typed XML again". Not
Reference back to the previous entry. Now that we know the rules, let's try them out: — snip — Data(),text() and string() accessors XQuery has
There's been lots of puzzled faces lately when I try to explain doing XQuery against strongly typed XML (XML typed by a SCHEMA COLLECTION) vs
A new feature of SQL Server 2005 that has been fairly well publicized is the ability, on Windows 2003 operating systems, to enforce password stregth,
One of my students last week noticed that using a Service Broker object name (like a CONTRACT, SERVICE, and MESSAGE TYPE name) with the wrong
Haven't been blogging as much recently, as I've been teaching and travelling quite a bit. Last week though, I received an interesting query on XQuery
I had an interesting flashback today. Someone wrote with a reference to a mailing list posting I'd written in 2000, about IRowsetFastLoad. They wanted code,
I've been lying pretty low lately, doing research on some topics in a slightly different space (but at least obliquely SQL Server 2005 related). Came
HTTP Endpoints in SQL Server 2005 are normally a way to support SQL Server clients that speak the SOAP protocol. It turns out that, although
I'm still assimilating little tidbits of information about the Nov-Dec CTP build. Put this one in your pubs database in the CTP: create procedure deletejob (@id
I’ve been using Visual Studio 2005 for over a year, since before the alpha version came out. Recently, I’ve had occasion to use VS 2003
It turns out that the week before last, the SQL Server and ADO.NET teams (they may be part of the same team) made public the
One of the most amazing things that happened at the class last week was Wednesday night, when Dan Sullivan and the SQL Server Service Broker
Syntactic changes are coming to the SQL Server in-proc provider. Compiling a stored procedure with the latest Dec CTP bits yielded the following message every
Another little thing I'd found had changed in Dec CTP. I'd reported a bug on this one and knew it was gonna be fixed eventually,
I answered a question on the newsgroups on how *exactly* inheritence works when you use it implement UDTs in SQL Server 2005. Also wanted to
OK, I couldn't help myself. The Dec 2004 CTP-specific readme had quite a number of things that are new. There are many improvements in SSIS, for
Now, back to our regularly scheduled technical content. About schemas, users, and owners. Although Ed originally created the table, since Fred is the schema owner,
I’m probably about the hundredth person to notice this and blog about it, but I’m not usually at home when these things happen. Thought I’d
The code for the answer is below. Greg Low is, of course, correct. Fred owns the table, but he owns it by virtue of being
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.