|
|
|
|
|
|
|
Browse Blog Posts by Tags
-
The next article in my series on PowerShell and SMO, PowerSMO At Work Part II is up on Simple-Talk.com now. Dan
-
I'm working on a series of articles on PowerSMO, my combination of PowerShell and SMO, for http://www.simple-talk.com . The first few are on the site now. Some of the topics in these articles are covered in the Applied SQL Server 2005 course. Dan
-
Now that we have PowerSMO! we can start making use of it. The first example will be building a test database. Whenever I work on an new database application or write labs for a course that involves databases I need to make test database with some data in them. T-SQL is just fine for defining tables and...
-
Last year I wrote a blog article about using what was then called MSH with SQL Server Management Objects http://pluralsight.com/blogs/dan/archive/2005/12/29/17703.aspx . MSH is now called PowerShell and mixing some SMO with it makes PowerSMO! SMO is a set of object models for SQL Server. With PowerSMO...
-
Lots of times when you are working with a SQL Server all you want to do is to poke at the data. You aren’t doing any real heavy duty transactional processing, you just want to get a look at what is going on. Of course you can fire up SSMS (SQL Server Management Studio) or SqlCmd and issue some...
-
PowerShell offers support for XML data directly though its [xml] datatype and this article is going to look at that. First of all to make use of the builtin [xml] datatype just prefix a variable name with [xml] when you assign something to it. PS C:\demos> [xml]$order = "<order customer='joe'>...
-
Comparing XML in SQL Server 2005 Xml is not text so a literal compare of two xml documents may lead to a false negative, that is it may indicate that two documents are not equal when in fact they are. For example these two xml documents are the same: <item x="1" y="2"/> <item y="2" x="1"/>...
-
CLR Based Histogram Functions and SQL Server 2005 One of the enhancements to SQL Server 2005 is the ability to create your own aggregates, or User Defined Aggregate as they are called. They are pretty easy to make and I'll go over the basics later in this article. But the real question is why would you...
-
How much space does xml cost in SQL Server 2005? This question seems to come up a lot because xml has a lot of meta data in it and to top it off SQL Server saves the xml data type using UTF-16 encoding. This is, at least for xml that is mostly ascii type characters, up twice as much space as the encoding...
-
I saw a wish list blogged at http://omnibuzz-sql.blogspot.com/2006/07/next-version-of-sql-server-wish-list.html. It wanted a sql function that would evaluate an string arithmetic expression in the next version of SQL Server. It turns out that function is already available, sort of, in T-SQL on SQL Server...
-
One of the things that seems to be missing from Visual Studio's support of SQL Server 2005 for CLR based functions, stored procedures and such it the ability to build a deployment script. Visual Studio makes it easy to deploy CLR functionality to SQL Server while you are in a developement enviornment...
-
/* Copyright 2006 Danal Technology Inc */ /* SQL Server has a really straightforward way to encrypt data by using EncryptDataByPassphrase. What's handy about it is that it doesn't require any keys to be added to SQL Server as the other encryption mechanisms do, you just use DecryptByPassphrase to get...
-
/* Psuedo Median Aggregrate In an item I previously blogged, YAMC, I showed how to use the ROW_NUMBER() function in SQL Server 2005 to do a pretty efficient median calculation. Being able to calculate the median in an expression can be useful, but a median aggregate function would be much more useful...
-
/* YAMC Yet Another Median Calculation SQL Server 2005 gives us yet another way to calculate a median. The secret is the ROW_NUMBER() function, it can be used to find the "middle" row. ROW_NUMBER() is a bit special because an alias for it cannot be used in a predicate in the same query. Either a CTE...
|
|
|
|
|
|