June « 2009 « SQL Server Journey with SQL Authority

Archive for June, 2009

SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged Policy Management on June 30, 2009 | 2 Comments »

This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of the system. It also provides additional [...]

Read Full Post »

SQL SERVER – Maximum Number of Index per Table

Posted in Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Index, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on June 29, 2009 | 28 Comments »

TechEd on Road Ahmedabad, June 20, 2009, was a huge success. This grand event saw over 200 attendees actively participating in the sessions. We had attendees traveling from far and wide, including Delhi, Mumbai, Jaipur, Kerala, Baroda, Himmatnagar, Rajkot, among other cities from India. This enthusiastic participation made the event truly grand. It was a [...]

Read Full Post »

SQL SERVER – 2008 – Management Studio New Features

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on June 28, 2009 | 12 Comments »

This article describes the top 5 features of SQL Server Management Studio 2008. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested by DBAs for long time. SQL Server 2008 has been released for a year now. In SQL Server [...]

Read Full Post »

SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.

Posted in Pinal Dave, Readers Question, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Trigger, T SQL, Technology, tagged DAC, sqlcmd on June 27, 2009 | 19 Comments »

I had previously written two articles about an intriguing observation of triggers online. SQL SERVER – Interesting Observation of Logon Trigger On All Servers SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution If you are wondering what made me write yet another article on logon trigger then let me tell [...]

Read Full Post »

SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution

Posted in Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Trigger, SQLServer, T SQL, Technology on June 26, 2009 | 14 Comments »

Does the title of this post trigger your mind? If you all remember, a few days back I had written an article on my interesting observation regarding logon triggers. I would advise you to first read SQL SERVER – Interesting Observation of Logon Trigger On All Servers before continuing with this article further to have [...]

Read Full Post »

Older Posts »