All Articles - SQL Authority with Pinal Dave

SQL SERVER – SQL Slammer (Computer Worm)

April 14, 2008

Just a day ago, while talking with my outsourcing team one of the DBA asked me question. Is there any virus associated with SQL Server? I really find this question very interesting as I did not know if there are any viruses associated with SQL Server. I searched Google for…

SQL SERVER – 2008 – Important Resources

April 13, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

In one of the recent public speaking event I was asked if I can list some important resources of SQL Server 2008. I promised that I will post the links on my blog. Here are Important Resources for SQL Server 2008. Learn more about data programmability http://www.microsoft.com/sql/2008/technologies/dataprogrammability.mspx Learn more about…

SQL SERVER – 2008 – Download Presentation and Whitepapers

April 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL White Papers

SQL Server 2008 Manageability Learn about the new manageability improvements in SQL server 2008 that enables you to administer, monitor and maintain your data platform infrastructure while reducing the time and cost of management. This session provides an overview of the new manageability improvements that enables you to manage the…

SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS – Part 2

April 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

Previously I have written two different ways to find database collation SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS. One of blog reader jwwishart has posted another method for doing the same. SELECT collation_name FROM sys.databases WHERE name = 'AdventureWorks' Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2

April 10, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Function, SQL Scripts

Blog reader Donald Crowther has posted following comment. I have not tested this solution and when I tried to test it, it did not work for me. However, I have received email from two of my Jr. DBA who have done experiment about this and they are suggesting it works.…

SQL SERVER – 2005 – Connection Strings For .NET

April 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

SQL Native Client ODBC Driver Standard security Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase; Uid=myUsername;Pwd=myPassword; Trusted Connection Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes; Connecting to an SQL Server instance Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase; Trusted_Connection=yes; SQL Native Client OLE DB Provider Standard security Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase; Uid=myUsername;Pwd=myPassword; Trusted connection Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes; Connecting to an SQL Server instance Provider=SQLNCLI;Server=myServerName\theInstanceName;Database=myDataBase; Trusted_Connection=yes; SqlConnection…

SQL SERVER – Change Order of Column In Database Tables

April 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

One question I received quite often. How to change the order of the column in database table? It happens many times table with few columns is already created. After a while there is need to add new column to the previously existing table. Sometime it makes sense to add new…

SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)

April 7, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage

Just received question from one of the DBA Question: I do not have full backup of my database. My .mdf and .ldf are corrupted. Is there any way I can restore database now? Answer: Sorry. I do not think there is any way you can do it. Try attaching this…

SQL SERVER – 15 Best Practices for Better Database Performance

April 6, 2008

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Server

In this blog post we will see 15 best practices for better Database Performance.

SQL SERVER – 2005 – Transferring Ownership of a Schema to a User

April 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

One of the blog reader asked me how transfer of ownership of schema to another users. Follow the simple script and you will be able to transfer ownership of schema to another user. ALTER AUTHORIZATION ON SCHEMA::SchemaName TO UserName; GO Reference : Pinal Dave (https://blog.sqlauthority.com)