Posted in DBA, Database, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology, tagged PASS, SQL PASS on November 16, 2009 | 7 Comments »
Update: Do not forget to checkout last three photos and follow me on twitter (of course!)
I have previously documented my four-day experience of SQL PASS 2009 Summit at Seattle. There were many reasons for SQL enthusiasts to attend the SQL PASS event; I am listing my own reasons here in order of importance to me.
Networking [...]
Read Full Post »
Posted in DBA, Database, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Constraint and Keys, SQL Index, SQL Puzzle, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on August 11, 2009 | 6 Comments »
About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In this post, I asked my readers if any could write a similar or better script. The results were interesting. While no one provided a new script, my question [...]
Read Full Post »
Posted in About Me, DBA, Database, Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, Software Development, T SQL, Technology on July 30, 2009 | 34 Comments »
Today is July 30 and I am very happy; it’s my Birthday, celebration time!!! The most common question I receive on my every birthday is -what are my plans for birthday. Let me share my plans here today. Additionally, if you are interested to know when SQL Server was born read my post SQLAuthority News [...]
Read Full Post »
Posted in Best Practices, DBA, Database, Pinal Dave, Readers Question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, T SQL, Technology on July 29, 2009 | 33 Comments »
Just about a year ago, I had written on the subject of how to insert data from one table to another table without generating any script or using wizard in my article SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE. Today, we will go [...]
Read Full Post »
Posted in About Me, DBA, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged Bing, Google on June 5, 2009 | 1 Comment »
I have been planning to write a general post on the latest technology for a long time but SQL keeps me so busy that I hardly get time. I know being busy is no excuse as everybody is busy with something. A manager is equally busy managing people as much as a peon busy doing [...]
Read Full Post »
Posted in DBA, Database, Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL Utility, SQLAuthority News, SQLServer, T SQL, Technology on May 22, 2009 | 3 Comments »
SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2005. The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008. The [...]
Read Full Post »
Posted in DBA, Database, MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLServer, T SQL, Technology on May 20, 2009 | 5 Comments »
I had a gala time at TechEd India 2009 event! Meeting with great people is an experience of a lifetime. My session was well attended and well appreciated, which also gives me another reason to feel happy. Moreover, my SQL Server Cheat Sheet gained unpredicted popularity at the event. Let me share with you all [...]
Read Full Post »
Posted in Best Practices, DBA, Database, Readers Contribution, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged Outsourcing Technology on May 10, 2009 | 6 Comments »
10 Reasons for Database Outsourcing
While you may feel that your IT material is safe and handled effectively within your own company, these reasons may give you some perspective on why you may want to consider other options.
Cost Reduction – Perhaps the most popular reason to outsource your database is the overall reduction in cost that [...]
Read Full Post »
Posted in Business Intelligence, DBA, Data Warehousing, Database, Readers Contribution, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on May 8, 2009 | 5 Comments »
This article is submitted by Nupur Dave
Future of Business Intelligence and Databases
The term business intelligence (BI) was coined by Howard Dresner in the early 1990s. He defined Business Intelligence as “a set of concepts and methodologies to improve decision making in business through use of facts and fact-based systems.” In a time when data warehousing [...]
Read Full Post »
Posted in DBA, Database, Pinal Dave, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on April 8, 2009 | 3 Comments »
SQL Server 2008 Service Pack 1 (SP1) is now available. You can use these packages to upgrade any SQL Server 2008 edition.
Download SQL Server 2008 Service Pack 1
Build of SP1 is SP1 is build 10.00.2531.00.
Reference : Pinal Dave (http://blog.sqlauthority.com)
Read Full Post »
pinaldave
