Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2008   (RSS)

Testing for Database Null Values from PowerShell

PowerShell is super, but its documentation is still lousy. You might think that how to test a database field for a null value would be straightforward, and indeed it is, but it ain’t documented anywhere. I’ve just spent the afternoon searching and eventually Read More...
Posted Monday, September 15, 2008 9:27 AM by Andrew_Fryer | 1 Comments

Time and Relative Dates in SQL Server 2008 (TARDIS)

Martin Bell , MVP and time lord has been getting to the bottom of the new date and time data types in SQL Server 2008 in this practical and useful article . Read More...
Posted Tuesday, May 27, 2008 3:13 PM by Andrew_Fryer | 0 Comments
Filed under:

Time for a Date?

As a DBA I wear many hats! If I had to choose a hat for my data architect role it would probably be a nice white panama, the sort you see in the Agatha Christie re-runs on ITV3, but I digress!. As a data architect you extol the virtues of “correctly data Read More...
Posted Tuesday, May 27, 2008 2:28 PM by Andrew_Fryer | 0 Comments
Filed under:

An introduction to Powershell for SQL Server 2008

Although I understand what Powershell is I didn't understand really get it until I worked with James on our last TechNet road shows. I did know that there were special extensions and support for it in SQL Server 2008, so I suggested to our good friend Read More...
Posted Tuesday, May 27, 2008 9:20 AM by Andrew_Fryer | 0 Comments

PowerShell in SQL Server 2008

At the time of writing SQL Server 2008 is currently at the Community Technology Preview (CTP) stage. CTP 6 was delivered in February 2008 and includes a PowerShell provider. In this article I will explain what PowerShell is, why a PowerShell provider Read More...
Posted Tuesday, May 27, 2008 8:58 AM by Andrew_Fryer | 5 Comments

The Dilemma of Presenting SQL Server 2008

Martin Bell runs the Scottish Area meetings of the UK SQL Server User Group , discusses the problems of deciding what to present on SQL Server 2008 to a bunch of developers in this entertaining article . Read More...
Posted Wednesday, May 07, 2008 7:41 PM by Andrew_Fryer | 0 Comments
Filed under:

What’s new in SQL Server 2008 - dilemmas!

The other week I was asked by Colin Mackay of Scottish Developers to do a 15 minute talk on “What’s new in SQL Server 2008” for the Community Launch of Visual Studio 2008 and Windows 2008 in Glasgow. So I set about putting some slides together in Power Read More...
Posted Tuesday, May 06, 2008 7:52 AM by Andrew_Fryer | 2 Comments
Filed under:
 
Page view tracker