This article covers the basics of Transaction Log backups and restores in SQL Server. The examples are from SQL Server 2008 however it applies to SQL Server 2005. If a database uses either the full or bulk-logged recovery model, you must back up the transaction log regularly enough to protect your data and to keep the transaction log from filling.
Continue reading about Backup and Restore Transaction Log in SQL Server
Usually AS400 supports millennium date format(i.e. CYYMMDD). SQL Server’s default Date format is YYYY-MM-DD. For obtaining our output we have to convert SQL Server Date to ISO Date, then it will be converted to AS400 date format easily.
Step 1: Convert SQL date format to ISO date format.
SELECT CONVERT(VARCHAR(8), GETDATE(), 112)
GO
Step 2 : [...]
Continue reading about Convert SQL Date into AS400 Date Format
From Long time SQL Server DBAs and Professionals are awaiting for a automatic compressed backup utility for SQL server, But It became true only with SQL Server 2008. For too long, if you wanted the benefit of compressed backups, you had to look at a third-party tool. Now, backup compression is built right into SQL Server 2008, and what’s even better is that it’s easy to use.
Continue reading about Automatic Backup Compression in SQL Server 2008
Visual Studio.NET 2008 makes it very easy for us to create LINQ to SQL Entities using the Object Relational Designer. What it does is creates classes and methods that relate to the database columns and tables. This makes it possible for us to communicate with the data using LINQ (Language Integrated Query).
For this example, we [...]
Continue reading about Use C# to create LINQ to SQL 2008 Entities
Written by industry experts Peter DeBetta, Greg Low, and Mark Whitehorn, Introducing Microsoft SQL Server 2008 will lead you through major new features in SQL Server 2008, including security, administration, performance, high availability, and business intelligence. Register to download the e-book, and sign up for the Microsoft Press Book Connection newsletter, which provides news about [...]
