March « 2011 « SQL Server Journey with SQL Authority

Archive for March, 2011

SQL SERVER – SQL Server Migration Assistant (SSMA) – Tools – Video – Download

Posted in About Me, Data Warehousing, PostADay, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 21, 2011 | 2 Comments »

I was recently working on learning various new stuff. I just would like to share very interesting resources here today. Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from any other data platform to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 [...]

Read Full Post »

SQL SERVER – Denali Feature – Zoom Query Editor

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on March 20, 2011 | 1 Comment »

SQL Server next version ‘Denali’ is coming up with very neat feature which can be used while presentations, group discussion or for people who prefers large fonts. I have increased the font size to 400 percentage and for the same reason they are very large. You can adjust the font size which is convenient to [...]

Read Full Post »

SQL SERVER – Log File Growing for Model Database – model Database Log File Grew Too Big

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 19, 2011 | 10 Comments »

After reading my earlier article SQL SERVER – master Database Log File Grew Too Big, I received an email recently from another reader asking why does the log file of model database grow every day when he is not carrying out any operation in the model database. As per the email, he is absolutely sure [...]

Read Full Post »

SQL SERVER 2008 – 2011 – Declare and Assign Variable in Single Statement

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on March 18, 2011 | 7 Comments »

Many of us are tend to overlook simple things even if we are capable of doing complex work. In SQL Server 2008, inline variable assignment is available. This feature exists from last 3 years, but I hardly see its utilization. One of the common arguments was that as the project migrated from the earlier version, [...]

Read Full Post »

SQL SERVER – Tell me What You Want to Listen – My 2 TechED 2011 Sessions

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, T SQL, Technology, tagged TechEd, TechEdIn on March 17, 2011 | 3 Comments »

I am going to present two sessions at TechEd India on March 25th, 2011. I would like to know what do you want me to cover in this session. Watch the video taken by my wife when I was preparing for the session. Sessions Date: March 25, 2011 Understanding SQL Server Behavioral Pattern – SQL [...]

Read Full Post »

« Newer Posts - Older Posts »