SQL Tips and Tricks Archives - Page 469 of 535 - SQL Authority with Pinal Dave

SQLAuthority News – My Favorite Link of This Blog

April 17, 2008

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

I have written more than 500 article on this blog so far and the number is increasing. Many times I get this question, which one link do I click the most. It is very interesting for myself to read my previous articles, as I often like to read them and…

SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures

April 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

While playing with SQL Server 2008 I found new feature of “Row Constructors”, where I can load temp table from stored procedure directly. Look at the following SQL where I have to use OpenQuery from server to itself creating loopback server and execute stored procedure and insert into temp table.…

SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks

April 15, 2008

Pinal Dave

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

Database, SQL Server Management Studio

Read my article published at SQL Server Magazine Surface Area Configuration Tools Reduce Exposure To Security Risks [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – SQL Slammer (Computer Worm)

April 14, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Server Security

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)