SQLShare - Public Profile for anovick

Member for 651 days

anovick (Author)

consultant

http://www.novicksoftware.com

Andrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site http://www.NovickSoftware.com and many videos can be seen here on JumpStart TV

Report Card

Questions Attempted:	3
Correct Answers:	3
Current Score:	100.00%

Videos I've made

Title	Published Date
SQL Azure Pricing and Billing	6/28/2010
Firewall Configuration for SQL Azure	6/13/2010
SQL Azure - Adding and Dropping Databases	6/13/2010
Connecting to SQL Azure Using Various Tools	6/13/2010
Query Differences in SQL Azure	6/13/2010
Introduction to SQL Azure	5/17/2010
Using a UDF in a Computed Columns	1/28/2009
Error Handling with UDF's	1/28/2009
Inline UDF's in SQL Server	1/28/2009
Multistatement UDF's in SQL Server	1/28/2009
Scalar UDF Parameters Explained	1/28/2009
Data Access with Scalar UDF's	1/28/2009
What is a Scalar UDF?	1/28/2009
SQL Server System Functions	1/28/2009
User Defined Functions Metadata	1/28/2009
User Defined Function Tips	1/28/2009
Testing User Defined Functions (UDF's)	1/28/2009
You Can't Do That with UDF's	1/28/2009

Videos I've watched

Title	When Watched
How to Backup the Transaction Log of a SQL Server Database	7/12/2010
Except Operator	7/2/2010
Configuring Network Settings for SQL Server	6/25/2010
Solve Parameter Sniffing By Using Local Variables	6/24/2010
Using TableDirect with SQL Compact	5/24/2010
Introduction to SQL Azure	5/21/2010
Creating a New Table in SQL Compact	5/17/2010
Building a Report Viewer Application - Part 2	5/15/2010
Building a Report Viewer Application - Part 1	5/15/2010
Connecting to a SQL Compact Database	5/15/2010
How to Detect Deadlocking in SQL Server - Part 1	4/19/2010
Capturing the Output of a Job Step	3/30/2010
Using SPIDS	3/23/2010
Decrease Replication Latency By Configuring Batches	3/15/2010
Overview of Data Driven Subscriptions in Reporting Services	3/15/2010
Statistics Based on Indexes	3/10/2010
Renaming a Database	3/10/2010
Overview of Subscriptions in Reporting Services	2/23/2010
Using a UDL File for Database Connectivity Testing	1/31/2010
Using the StatsDate Function	1/9/2010
How to Change Database Statistics Settings	12/19/2009
Tablediff - Compare Data in SQL Server Tables	12/19/2009
SQL 2008 - Central Management Servers, Part 1	11/17/2009
Using a CTE to Update With An Aggregate Expression	11/5/2009
SQL Server Error Logs	11/1/2009
The Basics of Windows Services	10/27/2009
How to Use the SQL Server 2008 Audit Object	9/13/2009
Composable DML in SQL Server 2008	5/25/2009
The Guest User in SQL Server	12/24/2008
Beating the Gears of War Final Boss	12/9/2008

My Playlists