Novick Software SQL Server Consulting Design Programming Training  

  sql server mvp

 

 

Videos

Video fn_get_sql
Video Perfmon Recompile statistics
Video Profiler

SQL Server

.Net Framework
.Net SQLXML Demo Utility in C#
Achieving Programmer Productivity through Code Generation
ASP hangs res://AlxRes.dll
Book Reviews
Creating a Daily Visual SourceSafe (VSS) Label with a SQL Agent Job
Find out with fn_get_sql
Find out with fn_get_sql
fn_get_sql P 4
fn_get_sql P 4
Indexed Views
Inline UDFs for Paging
IT's Requirement
Presentations/UserDefinedFunctions/Andrew Novick on User Defined Functions.pps
Presentations/Writing-Code-To-Write-Your-DSL/Wriiting-code-to-write-your-Data-Services-Layer.pps
Securing S2K For Web
SP3 and xp_cmdshell
sp_storage - a procedure for managing SQL Server disk space
SQL Server Performance on Solid State Disk
Table Space Reporting with dba_spaceused. Better than sp_spaceused.
Tip (.Net): Object Relational Mapping Tools for .Net
Tip (FrontPage): Wrong FrontPage Server Extensions Problem
Tip (Interdev): Visual Interdev Project Creation Wizard doesn't Show all Existing Sites
Tip (SQL Server): Error Handling in a Stored Procedure
Tip (SQL Server): The CLR is disabled by default. How do you enable it?
Tip (SQL Server): xp_sql_agent_proxy_account returns 'access denied' message
Tip (SQL Server):Creating an Extended Property Over 255 Characters
Tip (Visual Studio.Net): The font in Solution Explorer is too small for demonstrations
Tip (Windows): A better command prompt
Tips and Tricks
Transact-SQL User-Defined Functions by Andrew Novick
Transact-SQL User-Defined Functions by Andrew Novick
Video fn_get_sql
Video Perfmon Recompile statistics
Video Profiler
Vol 1 #1 udf_SQL_Tbl_NotOwnedByDBOTBL
Vol 1 #10 udf_Txt_CharIndexRev
Vol 1 #11 udf_SQL_StartDT
Vol 1 #12 udf_SQL_VariantToDatatypeName
Vol 1 #13 udf_SQL_SearchDBObjectsTAB
Vol 1 #14 fn_get_sql
Vol 1 #15 udf_SQL_DefaultsTAB
Vol 1 #16 udf_Txt_FullLen
Vol 1 #17 udf_SQL_SystmeUDFText
Vol 1 #18 udf_SQL_DatatypeString
Vol 1 #19 udf_View_ColumnsIndexableTAB
Vol 1 #2 udf_DT_CurrTime
Vol 1 #20 udf_SQL_RuntimeFee
Vol 1 #21 udf_Num_RandInt
Vol 1 #22 fn_chariswhitespace
Vol 1 #23 fn_replinttobitstring and udf_BitS_FromInt
Vol 1 #24 udf_Bit_Int_NthBIT
Vol 1 #25 fn_dblog
Vol 1 #25 udf_Proc_WithRecompile
Vol 1 #26 fn_varbintohexstring
Vol 1 #28 fn_replbitstringtoint and udf_BitS_ToInt
Vol 1 #29 udf_Txt_SplitTAB
Vol 1 #3 udf_DT_WeekdaysBtwn
Vol 1 #30 Joining Strings into Lists
Vol 1 #31 udf_DT_Round2Part
Vol 1 #32 udf_Txt_CharIndexRev
Vol 1 #33 udf_Func_TableCols
Vol 1 #34 udf_Num_FpEqual
Vol 1 #35 udf_Trig_TANH
Vol 1 #36 udf_DT_FilenameFmt
Vol 1 #37 udf_Perf_FS_ByDbTAB
Vol 1 #38 udf_DT_AddTime
Vol 1 #39 udf_Instance_CPU_BUSY_Percent
Vol 1 #4 udf_TxtN_Wrap
Vol 1 #40 udf_Txt_HasCharInGroup
Vol 1 #41 udf_SQL_PasswordIsStrong
Vol 1 #42 udf_Proc_BadPrefixTAB
Vol 1 #43 udf_Tbl_ColumnList
Vol 1 #44 udf_Process_NetLib
Vol 1 #45 Percentile UDF s
Vol 1 #46 NumberToWords
Vol 1 #47 Proper Case
Vol 1 #48 FormatNumber
Vol 1 #49 udf_Instance_FilesTAB
Vol 1 #5 udf_Tbl_RowCount
Vol 1 #50 AsciiChars
Vol 1 #51 udf_Func_MayIExec
Vol 1 #52 Writing UDFs that Handle UNICODE
Vol 1 #6 udf_SQL_UserMessagesTAB
Vol 1 #7 udf_DT_dynamicDATEPART
Vol 1 #8 udf_Tbl_PKeyColumnsTAB
Vol 1 #9 udf_FactorialsTAB
Vol 2 #1 Computed Columns that use a UDF
Vol 2 #10 Get the extended properties for TABLEs
Vol 2 #11 Get column descriptions for one or many tables.
Vol 2 #12 Get detailed information about your TABLE's Columns
Vol 2 #12 Get detailed information about your TABLE's Columns
Vol 2 #13 Find potential problems due to inconsistent column definition.
Vol 2 #14 Find the Nth day of the week in a Month.
Vol 2 #15 Find the Number of Hours in a Day
Vol 2 #16 Find the number of day-of-week ranges in a date range.
Vol 2 #17 Find all your timestamp columns
Vol 2 #18 Find all columns with uniqueidentifier data type. (GUIDS)
Vol 2 #19 Find where UDTs are used.
Vol 2 #2 Convert to a Julian Date
Vol 2 #20 Is this database a replication subscriber?
Vol 2 #21 Find Column Names that don't port to DB2
Vol 2 #22 Convert from a legacy iSeries format to smalldatetime
Vol 2 #23 Convert back to the legacy iSeries format
Vol 2 #24 Convert from another legacy date format MMYY
Vol 2 #24 Convert from another legacy date format MMYY
Vol 2 #25 Convert to a legacy Month format MMYY
Vol 2 #26 FormatDateA T-SQL date formatting function like VB's Format when used on a date with a user defined date format. For example FormatDate (getdate(), 'mm/ddd/yy hh:mm:ss')
Vol 2 #27 Count the number of columns in each TABLE
Vol 2 #28 Find VB.Net keywords in SQL Server column names
Vol 2 #29 Check if a string is a T-SQL keyword
Vol 2 #3 Convert From a Julian Date
Vol 2 #30 Find Column Names that Don't Make good Property Names
Vol 2 #30 Find Column Names that Don't Make good Property Names
Vol 2 #31 Check on the backup date of all your databases
Vol 2 #32 Find SQL Agent Jobs that failed the last time they ran
Vol 2 #33 List Server Roles granted to all users.
Vol 2 #34 Use an identity column to number a resultset
Vol 2 #35 Create a sequence with a table or a UDF
Vol 2 #35 Create a sequence with a table or a UDF
Vol 2 #35 Create a sequence with a table or a UDF
Vol 2 #35 Create a sequence with a table or a UDF
Vol 2 #35 Create a sequence with a table or a UDF
Vol 2 #36 Using a UDF to replace a column with a lookup
Vol 2 #37 Create an Updatable View
Vol 2 #38 Using Column Permissions to Protect a Look-Up Table
Vol 2 #39 Check for Primary Keys
Vol 2 #4 Take the Nth root of a Number
Vol 2 #40 Survey Results and Future of this Newsletter
Vol 2 #41 Read any Windows Registry string value from T-SQL
Vol 2 #42 Obscure data with the Rot13 Cipher
Vol 2 #43 An alternative Rot13 Cipher Implementation
Vol 2 #44 Comparing the performance of Rot13 implementations
Vol 2 #45 Pin a list of tables into memory
Vol 2 #46 Find Out Which Tables are Pinned
Vol 2 #47 Validate Credit Card Numbers wtih the Luhn Formula
Vol 2 #48 Translate ZIP Codes to State Codes
Vol 2 #49 Parse a string with the InString UDF
Vol 2 #5 Calculate the value of Phi
Vol 2 #50 duplicate Using Query Analyzer Templates
Vol 2 #50 Using SQL Query Analyzer Templates to Speed UDF Creation
Vol 2 #6 How many digits of Pi can SQL Server represent
Vol 2 #7 Show which SQL Server Triggers are ENABLED
Vol 2 #8 Debugging UDFs
Vol 2 #9 Translating numbers to words
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xprototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 2 #xx prototype
Vol 3 #1 Searching the SQL Server ErrorLog
Vol 3 #10 Naming SQL Server Objects Part I
Vol 3 #11 Naming SQL Server Objects Part II
Vol 3 #12 Making Stored Procedures Readable
Vol 3 #13 Programming SQL Server 2005 with the .Net CLR
Vol 3 #14 Performance of .Net Code in SQL Server 2005
Vol 3 #15 A SQLCLR Stored Procedure to Write to a Trace File
Vol 3 #2 Finding the SQL Server Agent ErrorLog
Vol 3 #3 Trace Messages Part I: Managing Application Sessions
Vol 3 #4 Trace Messages Part II: Writing to the Trace
Vol 3 #5 Trace Messages Part III: Ending a Session and Adding Metrics
Vol 3 #6 Trace Messages Part IV: Getting the Trace Results
Vol 3 #7 Trace Messages Part V: Cleaning up the Trace
Vol 3 #8 Seperator First Formatting (SFF)
Vol 3 #9 Semicolons in T-SQL
Vol 3 #B1 udf_DeleteIfExists for Deleting Objects

Visual Basic, VB.Net, ASP, ASP.Net, and IIS Pages

.Net Development Utilities for C# and VB.Net
.Net Framework
.Net Framework Security
Achieving Programmer Productivity through Code Generation
Add a scripting engine to your VB project with SAX Basic.
Add me to the the mailing list
Adding a Scripting Engine to your Visual Basic Program
ASP hangs res://AlxRes.dll
ASP.Net 2.0 Upgaders Guide
ASP.Net 2.0 Upgaders Guide
Book Reviews
Building Solutions with Microsoft's .Net Compact Framework
Building Solutions with Microsoft's .Net Compact Framework
Building WinForms Applications on the .Net Framework
Creating a Daily Visual SourceSafe (VSS) Label with a SQL Agent Job
Creating SQL Server User-Defined Types with the .Net CLR
Creating User-Defined Types in SQL Server with the .Net CLR
Creating User-Defined Types in SQL Server with the .Net CLRPresentation on creating User-Defined Types in SQL Server 2005 using the .Net CLR. Using C# or Visual Basic .Net you can create your own types.
Defending SQL Server from SQL Injection Attack
Developing and Testing SQL Server Databases with Visual Studio 2010
Distributing the Smart Client Application
fn_get_sql P 4
fn_get_sql P 4
How to... FrontPage 2002
Inline UDFs for Paging
IT's Requirement
Learning C#
Partitioning SQL Server Tables, Views, and Indexed Views
PowerShell: the Object command line
Presentations/DotNet-Programmatic-Access-to-SQL-Server-2000-XML/DotNet-Programmatic-Access-To-SQL-Server-2000-xml.pps
Presentations/Writing-Code-To-Write-Your-DSL/Wriiting-code-to-write-your-Data-Services-Layer.pps
Professional Crystal Reports in Visual Studio.Net
Programming ASP.Net
Programming Service Broker with T-SQL and .Net
Programming Service Broker with T-SQL and .Net
Programming SQL Server 2005 with .Net
Protecting Your IIS
Replacing SQL Query Analyzer to Audit ad Hoc SQL DML and DDL
Review of Monad a book about the Microsoft Shell (MSH)
Review of Murach's SQL Server 2005 for developers
Review of Visual Basic .Net Power Coding by Paul Kimmel
Search Engine Visibility
Securing S2K For Web
SP3 and xp_cmdshell
SQL Azure - Relational Database in the Cloud
SQL Azure - Relational Database in the Cloud
SQL Azure - Relational Database in the Cloud
SQL Server Constutant - Articles about development in SQL Server, Visual Basic, XML, ASP.NET, VB.NET.
SQL Server Loadfest
SQL Server Loadfest
SQL Server Loadfest
SQL Server Loadfest
SQL Server Loadfest - FAQ
SQL Server Performance on Solid State Disk
SQL Server Programming: From 2000 to 2005
SQL Server Secruity for the ASP.Net Developer
Table Space Reporting with dba_spaceused. Better than sp_spaceused.
Test-Driven Development in Microsoft .Net
Tip (.Net): Object Relational Mapping Tools for .Net
Tip (ActiveX,IE): When IE loads an ActiveX control a small square or square with red dot shows instead.
Tip (ASP, IIS, VBScript): ASP Pages that use the FileSystemObject Hang
Tip (COM+): Install of COM+ .MSI fails
Tip (FrontPage): Wrong FrontPage Server Extensions Problem
Tip (Interdev): Visual Interdev Project Creation Wizard doesn't Show all Existing Sites
Tip (SQL Server): Error Handling in a Stored Procedure
Tip (VB Win32): Lower Your Process Priority with SetPriorityClass to Imporve Throughput
Tip (Visual Studio.Net): The font in Solution Explorer is too small for demonstrations
Tip (Windows): A better command prompt
Tips and Tricks
Understanding and Optimizing ADO.Net 2.0's SQL Statements
User Defined Functions - The Whole Story
User Defined Functions in SQL Server 2005
User Defined Functions in SQL Server 2005
User Defined Functions in SQL Server 2005
User Defined Functions in SQL Server 2005
User Defined Functions in SQL Server 2005
VB.Net Business Objects
Visual Basic 2005 New Language Features
visual-basic-dot-net-development-utilities
Web Style Guide
Windows Forms Programming in Visual Basic .Net Revied by Andrew Novick
Working with Isolated Storage in .Net
Writing Faster T-SQL Stored Procedures and Functions - Lessons Learned
Writing Faster T-SQL Stored Procedures and Functions - Lessons Learned

Security

.Net Framework Security
Achieving Programmer Productivity through Code Generation
ASP.Net 2.0 Upgaders Guide
ASP.Net 2.0 Upgaders Guide
Creating a Daily Visual SourceSafe (VSS) Label with a SQL Agent Job
Find out with fn_get_sql
Find out with fn_get_sql
fn_get_sql P 4
fn_get_sql P 4
IT's Requirement
Securing S2K For Web
SP3 and xp_cmdshell
Te Hacker Diaries

XML

.Net Framework
.Net SQLXML Demo Utility in C#
ASP hangs res://AlxRes.dll
Presentations/DotNet-Programmatic-Access-to-SQL-Server-2000-XML/DotNet-Programmatic-Access-To-SQL-Server-2000-xml.pps
Tip (.Net): Object Relational Mapping Tools for .Net
Tip (FrontPage): Wrong FrontPage Server Extensions Problem
Tip (InfoPath): When InfoPath is connected to SQL Server it may not allow submission to a database
Tip (Interdev): Visual Interdev Project Creation Wizard doesn't Show all Existing Sites
Tip (SQL Server): Error Handling in a Stored Procedure
Tip (Visual Studio.Net): The font in Solution Explorer is too small for demonstrations
Tip (Windows): A better command prompt
Tips and Tricks

Search Engine Optimization

InfoPath

Tip (InfoPath): When InfoPath is connected to SQL Server it may not allow submission to a database

RSS

Tip (RSS): Where to get the popular Feed Readers for Windows


RSS as HTML

information about novick software site

Personal Blog

Photos

New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule

 

 

Available Now

Transact-SQL
User-Defined Functions

Get it wtih the Bonus 100 UDF Library

Latest News

Novick Software Celebrates 10 Years in Business