My first article on Simple-Talk introduces Change Data Capture in SQL Server 2008, which records INSERTs, UPDATEs and DELETEs in simple relational change tables.
SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
SQL Server 2008 lets you copy database with data: turn on Script Data in the Generate Scripts wizard to get INSERT statements for the rows in your tables.
SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
What is the difference between Line Feed (\n) and Carriage Return (\r)? Why Windows, Mac and Unix read a new line differently, and what it means in T-SQL.
SQLAuthority News – Download – SQL Server 2008 Developer Training Kit
Download the SQL Server 2008 Developer Training Kit by Microsoft to learn how to build web applications with the new data types in SQL Server 2008.
SQL SERVER – IntelliSense Does Not Work – Enable IntelliSense
IntelliSense in SQL Server 2008 not showing suggestions? Four ways to Enable IntelliSense, starting with connecting to a 2008 instance and checking Tools, Options.
SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located
Can’t find the location of Activity Monitor in SQL Server 2008? It’s not under Tools. Open it from the Standard toolbar or by right clicking the server node.
SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network
Find every SQL Server on network with one command: sqlcmd -L or osql -L lists the instances on your local network. An update to my old isql script.