SQL Archives - Page 443 of 519 - SQL Authority with Pinal Dave

SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting

July 17, 2008

MVP, SQL User Group, SQLAuthority Author Visit

I will be attending Ahmedabad SQL Server Usergroup Meeting on July 19, 2008. I will be taking session about “SQL Server Best Practices“. I invite all of the SQL enthusiastic to stop by User Group Meeting and meet all the fellow developers, DBAs and members. Location : 401, TIME SQUARE,…

SQL SERVER – Readers Contribution to Site – Simple Example of Cursor

July 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor, SQL Scripts

eaders are very important to me. Without their active participation this site would not be the community helping web site. I encourage readers participation and request that you help other users with your knowledge. I recently come across very good communication between two of blog readers. I want to thank…

SQL SERVER – Deferred Name Resolution

July 15, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is incorrect table name in the SP it creates the SP fine but while executing it gives run time error. However, if there is any valid table from database is referenced in SP…

SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2

July 14, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SPARSE Columns, SQL Data Storage

Previously I wrote about SQL SERVER – 2008 – Introduction to SPARSE Columns. Let us understand the concept of SPARSE column in more detail. I suggest you read the first part before continuing reading this article. All SPARSE columns are stored as one XML column in database. Let us see…

SQL SERVER – 2008 – User Account – sa or sysadmin

July 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server, SQL Server Security

Just a day ago, I noticed ‘sysadmin’ user in SQL Server 2008. While looking more into it, I found that it has same account rights as ‘sa’ account. ‘sysadmin’ is actually replacement for legacy ‘sa’ account. ‘sa’ still exist in SQL Server 2008, however, it will be deprecated in future versions of SQL Server. It is recommended to all the users who switch to SQL Server 2008 to start migrating to ‘sysadmin’ from ‘sa’.

SQL SERVER – 2005 – Two Important Security Update

July 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Server Security

If you are using SQL Server 2005, following two are very important security updates not to be missed. Security Update for SQL Server 2005 Service Pack 2 (KB948108) A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your…

SQL SERVER – 2008 – Introduction to SPARSE Columns

July 10, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SPARSE Columns, SQL Data Storage, SQL Scripts

I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup Management. I have received very good replies from many users and have requested to write more about it. Today we will look into another interesting concept of SPARSE column. The reason…