0) jdbc drivers and specs for SQL Server (31-Aug-20)

1) SQL Examples XRef (30-Aug-20)

2) SQL Server 2019 installation (27-Aug-20)

3) How do I schedule a backup database program on windows servers? (25-Jul-20)

4) sample sql code (25-May-20)

5) sql quick journal (24-Mar-20)

6) SSMS: Sql Server Management Studio notes (22-Mar-20)

7) Guidelines for data modelling (28-Feb-20)

8) SampleStoredProc1 (6-Feb-20)

9) Database questions (5-Jan-20)

10) Sample code: A few sample stored procs (3-Jan-20)

11) composite keys (3-Jan-20)

12) SQLServer user permissions to execute Stored procedures (19-Jun-17)

13) Please declare all your strings as nvarchar in SQL Server, including stored procedure params (30-May-17)

14) What are key SQL Server Resources? (30-May-17)

15) SQL Server and SSDs: The nasty dependency (27-Apr-17)

16) Preparing SQLServer for UTF-16 (27-Apr-17)

17) Open sourced web based database client software (31-Aug-16)

18) Basic DB2 syntax and a few other things (27-Aug-16)

19) How do I pass an exit code from sqlcmd? (15-Aug-16)

20) How do I define a column to be a primary key in tsql? (28-May-14)

21) Sample code snippet for a SqlServer View (21-May-14)

22) What does dbo stand for in sql server? (24-Apr-14)

23) A list of databases in the market place (6-Aug-13)

24) Speaking of No-SQL databases: A look (5-Apr-13)

25) sql server in clause and null set (16-Nov-12)

26) in clause in stored procedures (16-Nov-12)

27) How can i backup and restore a SQL server database? (12-May-12)

28) Can I create a unique index on a column that allows nulls? (9-May-12)

29) What is SQL Server Browser service? (1-May-12)

30) t-sql code for altering/creatign indexes (10-Jan-12)

31) Here is what sql manager does to alter the identify of a column (10-Jan-12)

32) How can I generate SQL script to regenerate/document tables in sql server? (9-Jan-12)

33) Understanding star schemas (5-May-10)

34) MYSQL Notes (18-Nov-06)

35) How to do subselects in a where clause (22-Apr-06)

36) Common table expressions (26-Nov-04)

37) How to limit rows from database queries (12-Aug-04)

38) Mastering Oracle SQL from OReilly (22-Mar-04)

39) Learning SQL from w3schools.com (22-Mar-04)

40) Notes of a java programmer on understanding and effective use of joins in select statements (20-Nov-03)

41) A sample sql server view (13-Oct-03)

42) Sample code for a function (26-Sep-03)

43) One quick way to document joins in SQL/Stored Procedures (13-Jun-03)

44) How can I use outerjoins in SQL Server? (11-Jun-03)

45) How to use sp_help? (11-Jun-03)

46) How can I execute a stored proc? (11-Jun-03)