Edward Charbeneau 19 February 2013

Using SASS and Compass in ASP.Net MVC with Web Workbench

2

27

ASP.NET

The Designers of CSS never envisaged the demands that we make of styles. However, preprocessors such as SASS can provide the obvious missing features such as constants, selector inheritence and nesting. Compass can in turn use SASS to provide a simple browser-independent way of expressing complex layout.… Read more

Phil Factor 12 May 2011

PATINDEX Workbench

15

39

T-SQL Programming

The PATINDEX function of SQL Server packs powerful magic, but it is easy to get it wrong. Phil Factor returns to the Workbench format to give a tutorial of examples, samples and cookbook ideas to demonstrate the ways that this underrated function can be of practical use. It is intended to be pasted into SSMS and used as a basis for experiment… Read more

Robert Sheldon 28 April 2009

XML Data Modification Language Workbench

8

34

T-SQL Programming

XML Data Modification Language (XML DML) allows you to modify and update XML data. When working with SQL Server Databases, this is the most efficient way to modify elements in an XML column, yet the techniques of using XML-DML have not been well, and simply, described - up until now. Robert Sheldon presents a practical workbench to show the various modify methods … Read more

Joe Celko 05 April 2009

Median Workbench

12

23

T-SQL Programming

SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why… Read more

Robert Sheldon 02 February 2009

Full-Text Indexing Workbench

6

53

Learn SQL Server

Robert Sheldon continues his guide to Full-Text Indexing, by putting down his pen and reaching for SSMS for a practical workbench on Full-Text indexing. There is nothing like trying things out to make ideas click.… Read more

Robyn Page and Phil Factor 15 November 2008

SQL Server Matrix Workbench

15

57

T-SQL Programming

In this workbench, Robyn Page and Phil Factor decide to tackle the subject of Matrix handling and Matrix Mathematics in SQL. They maintain that 'One just needs a clear head and think in terms of set-based operations'… Read more

Robyn Page and Phil Factor 19 September 2008

Database Design Workbench – Keys

7

23

Learn SQL Server

Robyn Page and Phil Factor explore the innocent subject of Keys for their latest workbench. Everybody knows about keys. Oh yeah? Phil Factor ends up muting the immutable out of sheer devilry, and we learn how silly the British Secret Service were to tag James Bond with the code '007'… Read more

Robyn Page and Phil Factor 28 April 2008

SQL String User Function Workbench: part 2

4

21

T-SQL Programming

In which Robyn and Phil continue with their popular series on TSQL String User-functions. In this final episode, they pull together the themes from their TSQL String Array Workbench and String User Function workbench, to provide a simple TSQL string-handling package.… Read more

Robyn Page and Phil Factor 15 April 2008

SQL String User Function Workbench: part 1

26

62

T-SQL Programming

Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.… Read more

Robyn Page and Phil Factor 27 March 2008

Getting HTML Data: Workbench

11

21

T-SQL Programming

Robyn and Phil start their investigation into XHTML by showing how to use TSQL to parse it to extract data, and demonstrate how to turn an XHTML table into a SQL Server Table!… Read more

Robyn Page and Phil Factor 16 March 2008

TSQL String Array Workbench

14

48

T-SQL Programming

Robyn and Phil show how to use XML-based arrays to make string handling easier in SQL Server 2005/2008, and illustrate the techniques with some useful functions, one of which copies the PHP str_Replace function.… Read more

Robyn Page and Phil Factor 07 January 2008

The SQLCMD workbench

27

46

SQL Tools

Robyn and Phil feel strongly that there are two striking features in SSMS that extends its usefulness dramatically. The first is the Template, and the second is the powerful functionality hidden by those strange words 'SQLCMD Mode'. Here they try to demonstrate how useful SQLCMD can be to anyone who is tasked with having to administer a database.… Read more

Robyn Page and Phil Factor 27 November 2007

TSQL Regular Expression Workbench

30

77

T-SQL Programming

Robyn and Phil start by writing a gentle introduction to using Regular expressions for validation, data cleaning and data import in TSQL, and finally end up with a routine for doing google-style searches that show the context of hits. It's all done in the spirit of 'try it and see...'… Read more

Robyn Page and Phil Factor 23 October 2007

Importing Text-based data: Workbench

35

44

T-SQL Programming

Robyn and Phil return with some fresh ideas about how to import text files into SQL Server, without resorting to DTS or SSIS scripting. They go on to show how much can be done in TSQL … Read more

Adam Machanic 15 October 2007

Service Broker Advanced Basics Workbench

4

44

Learn SQL Server

SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we design and run distributed applications. Adam Machanic once more makes it all seem so easy in Part 2 of his epic series... … Read more

Adam Machanic 14 August 2007

Service Broker Foundations Workbench

21

129

Learn SQL Server

SQL Service Broker, an asynchronous queuing and messaging system for SQL Server 2005, is set to change the way we design and run distributed applications. Adam Machanic makes it all seem so easy...… Read more

Robyn Page and Phil Factor 22 July 2007

Crosstab Pivot-table Workbench

39

89

T-SQL Programming

Robyn and Phil turn their attention to the bedrock of management reporting, the Pivot Table. Under Phil's 'wild man' influence, they end up with some rather radical ideas.… Read more