Bill McEvoy | ITPro Today

Bill McEvoy

Latest from Bill McEvoy

T-SQL 101: Stored Procedures

T-SQL 101: Stored Procedures T-SQL 101: Stored Procedures

Apr 27, 2009

11 Min Read

T-SQL 101: Built-In Functions

T-SQL 101: Built-In Functions T-SQL 101: Built-In Functions

Sep 28, 2008

8 Min Read

All from Bill McEvoy

T-SQL 101: The CASE Function

Early Versions (SQL Server 2000 – 2008)

T-SQL 101: The CASE Function

T-SQL 101: The CASE Function

Indexed Views vs. Regular Views

Regulatory Compliance

Indexed Views vs. Regular Views

Indexed Views vs. Regular Views

Early Versions (SQL Server 2000 – 2008)

Q: How do I retrieve values from a table and store the results in a string?

Q: How do I retrieve values from a table and store the results in a string?

T-SQL 101: Views

Early Versions (SQL Server 2000 – 2008)

T-SQL 101: Views

T-SQL 101: Views

T-SQL 101, Lesson 6

T-SQL 101, Lesson 6

T-SQL 101, Lesson 6

T-SQL 101, Lesson 5

T-SQL 101, Lesson 5

T-SQL 101, Lesson 5

T-SQL 101, Lesson 4

T-SQL 101, Lesson 4

T-SQL 101, Lesson 4

T-SQL 101, Lesson 3

T-SQL 101, Lesson 3

T-SQL 101, Lesson 3

Take the Drudgery Out of Making Sure Your Databases Are Being Backed Up Properly

Take the Drudgery Out of Making Sure Your Databases Are Being Backed Up Properly

Take the Drudgery Out of Making Sure Your Databases Are Being Backed Up Properly

Early Versions (SQL Server 2000 – 2008)

2 Stored Procedures to Tune Your Indexes

2 Stored Procedures to Tune Your Indexes

T-SQL 101, Lesson 2

T-SQL 101, Lesson 2

T-SQL 101, Lesson 2

T-SQL 101, Lesson 1

T-SQL 101, Lesson 1

T-SQL 101, Lesson 1

Stored Procedure Documents Scheduled Jobs in SQL Server

Stored Procedure Documents Scheduled Jobs in SQL Server

Early Versions (SQL Server 2000 – 2008)

Take Advantage of Osql and Bcp Without Having to Remember All Their Command-Line Options

Take Advantage of Osql and Bcp Without Having to Remember All Their Command-Line Options

Early Versions (SQL Server 2000 – 2008)

Searching the Web for SQL Topics? Give SQL Hunter a Try

Searching the Web for SQL Topics? Give SQL Hunter a Try

Early Versions (SQL Server 2000 – 2008)

Retrieve Triggers from the SQL Command Prompt

Retrieve Triggers from the SQL Command Prompt

Early Versions (SQL Server 2000 – 2008)

Pull Out Text from HTML Code

Pull Out Text from HTML Code

Early Versions (SQL Server 2000 – 2008)

Stored Procedure Searches for Strings

Stored Procedure Searches for Strings

Sign up for the ITPro Today newsletter

Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

Newsletter Sign-Up