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)
12) SQLServer user permissions to execute Stored procedures (19-Jun-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)
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)
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)