Year 2011 will be my favorite year for long time. I have achieved many personal milestones this year. I will list few things here today, which should keep me inspired next year to do even better. Here is my blog post which I have written for January 1, 2011 SQLAuthority News – Resolution for New [...]
Archive for December, 2011
SQLAuthority News – An Year Worth Remembering and Looking Forward to Better Next Year
Posted in Technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, Pinal Dave, T SQL, SQL Milestone, PostADay on December 31, 2011 | 8 Comments »
SQLAuthority News – A Quick History of Writing Three Books in Year 2011
Posted in About Me, Technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, T SQL, SQLAuthority Book Review, PostADay on December 30, 2011 | 10 Comments »
This has been an eventful year for me. I write in various formats online and offline but becoming a published author of printed book was always my dream. Every day I write continuously. Here are few of the writing tasks I do in my everyday routine. I write – Emails I write nearly 400+ emails [...]
SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow
Posted in About Me, Technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, Pinal Dave, T SQL, PostADay on December 29, 2011 | 33 Comments »
I have received lots of good responses to the puzzles, quizzes and brain teasers posted on this blog post. As the year is ending, I have decided to give two interesting puzzles for you. The first one is easy and the second one is equally uncomplicated, but let us see if any of you can [...]
SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup
Posted in Technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, T SQL, SQL Backup and Restore, Readers Question, PostADay on December 28, 2011 | 7 Comments »
I recently received following question from reader. I would like to share the complete story in few short sentences with you to give you complete idea. Let us call the reader Margie. Our long email conversation is converted into chat like conversation Margie: Hi Pinal – I am seeing strange behavior with regards to my [...]
SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012
Posted in Technology, SQL Server, SQL, SQL Query, SQL Function, SQL Tips and Tricks, SQL Authority, T SQL, SQL Backup and Restore, PostADay on December 27, 2011 | 8 Comments »
Recently I was going over few advanced options of SQL Server 2012 in database properties and I found a new option in the property screen. Properties screen of SQL Server 2008 R2 Properties screen of SQL Server 2012 I got little curious and decided to learn what does this new feature indicates. When I started [...]
free community tool
About Pinal Dave
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2000 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of three SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
Follow @pinaldave Send +Pinal Dave an email at pinal@sqlauthority.com
-
Blog Stats
- 36,185,381 (35 Million+)
Next Office Hours
Books I Authored
SQLAuthority Links
Subscribe to Newsletter
My Homepage
Windows Live Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
All Scripts - 3
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
> SQL Interview Q & A <
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
About Nupur Dave
Nupur Dave loves technology simply because it makes life more convenient. She is devoted to technology because it touches our heart makes our daily lives easier. Among the many technological programs she uses and embraces Windows Live most because she can do lots of things with ease – from photo management to movies; business emails to personal social media connections.
Disclaimer
This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL. My employer do not endorse any tools, applications, books, or concepts mentioned on the blog. I have documented my personal experience on this blog.
Categories
- About Me (144)
- Best Practices (143)
- Business Intelligence (36)
- CodeProject (10)
- Data Warehousing (49)
- Database (320)
- DBA (137)
- DMV (13)
- Joes 2 Pros (47)
- MVP (147)
- PASS (14)
- Readers Contribution (110)
- Readers Question (122)
- SharePoint (7)
- Software Development (69)
- SQL Add-On (99)
- SQL Azure (15)
- SQL Backup and Restore (79)
- SQL BOL (11)
- SQL Coding Standards (21)
- SQL Constraint and Keys (57)
- SQL Cursor (28)
- SQL Data Storage (59)
- SQL DateTime (47)
- SQL DMV (22)
- SQL Documentation (299)
- SQL Download (310)
- SQL Error Messages (159)
- SQL Function (161)
- SQL Humor (29)
- SQL Index (155)
- SQL Interview Questions and Answers (134)
- SQL Joins (77)
- SQL Milestone (25)
- SQL Optimization (152)
- SQL PASS (19)
- SQL Performance (340)
- SQL Puzzle (90)
- SQL Security (127)
- SQL Server DBCC (42)
- SQL Server Management Studio (44)
- SQL Service Pack (13)
- SQL Stored Procedure (116)
- SQL String (26)
- SQL System Table (61)
- SQL Trigger (24)
- SQL User Group (57)
- SQL Utility (153)
- SQL View (26)
- SQL Wait Stats (41)
- SQL Wait Types (42)
- SQL White Papers (66)
- SQL XML (12)
- SQLAuthority (629)
- SQL Training (18)
- SQLAuthority Author Visit (141)
- SQLAuthority Book Review (39)
- SQLAuthority News (574)
- SQLAuthority Website Review (42)
- SQLServer (224)
- Tech (1579)
- Pinal Dave (1567)
- SQL Scripts (858)
- Technology (2021)
- PostADay (442)
- SQL (2021)
- SQL Authority (2021)
- SQL Query (2021)
- SQL Server (2021)
- SQL Tips and Tricks (2021)
- T SQL (2021)
- Video (4)
-
Top Posts & Pages
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - How to Rename a Column Name or Table Name
- SQL SERVER - 2005 List All Tables of Database
- SQL Interview Q & A
- SQL SERVER - 2008 - Configure Database Mail - Send Email From SQL Database
- SQL SERVER - Shrinking Truncate Log File - Log Full
- SQL Server Interview Questions and Answers Complete List Download
Top 3 Commenters









