Feeds:
Posts
Comments

Archive for August, 2009

SQLAuthority News – Evaluate the Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)

Posted in SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged on August 16, 2009 | 1 Comment »

SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 to help your organization scale with confidence and improve IT and developer efficiency with new and enhanced tools for application and multi-server management, master data services and complex event processing. The new Self Service BI capabilities will empower end users to access, [...]

Read Full Post »

SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on August 15, 2009 | 37 Comments »

Simple-Talk.com has published my very first article on their site. This article is introducing Change Data Capture – the new concept introduced in SQL Server 2008. Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relational ‘change tables’ [...]

Read Full Post »

SQLAuthority News – USB Drive Fails to Copy Large File

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on August 14, 2009 | 8 Comments »

I am currently traveling on a month-long training assignment for Business Intelligence. For demonstration purposes, I use Virtual PC files and hands-on lab examples for attendees of the training. The size of my VPC file is about 15 GB. Initially, I copy this file to a USB Drive and then move it to other computers, [...]

Read Full Post »

SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service

Posted in Database, Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on August 13, 2009 | 11 Comments »

Nakul, a dedicated member of the Gandhinagar SQL Server User Group, recently emailed me with a very interesting, but quick question. He asked me why the SQL Server Agent starts before SQL Server Engine does? He made the very valid point that as the SQL Server Engine is the core service, it should start first, [...]

Read Full Post »

SQL SERVER – Backup master Database Interval – master Database Best Practices

Posted in Best Practices, Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on August 12, 2009 | 23 Comments »

During a recent consultancy project, I was asked to review a Database Backup plan. While going through the plan, I noticed that there was no backup for the master database. When I questioned this, the DBA informed me that it was not necessary. I was startled and couldn’t resist explaining to him that the master [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers