SQL Tips and Tricks Archives - Page 327 of 536 - SQL Authority with Pinal Dave

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

March 17, 2011

SQLAuthority Author Visit, TechEd, TechEdIn

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…

SQLAuthority News – I am Presenting 2 Sessions at TechEd India

March 16, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events, SQL Wait Stats

TechED is the event which I am always excited about. It is one of the largest technology in India. Microsoft Tech Ed India 2011 is the premier technical education and networking event for tech professionals interested in learning, connecting and exploring a broad set of current and soon-to-be released Microsoft…

SQL SERVER – SQLServer Quiz 2011 – Do you know your execution plan – Two questions – One Answer

March 15, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

My friend Jacob Sebastian has SQL Server Quiz 2011 launched. This time when he asked me to come up with quiz question – I wanted to come up with something which is new and make participant to think about it. After carefully thinking I come with question which I really…

SQL SERVER – Guest Post – Architecting Data Warehouse – Niraj Bhatt

March 14, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Business Intelligence, Data Warehousing, Database

Niraj Bhatt works as an Enterprise Architect for a Fortune 500 company and has an innate passion for building / studying software systems. He is a top rated speaker at various technical forums including Tech·Ed, MCT Summit, Developer Summit, and Virtual Tech Days, among others. Having run a successful startup…

SQL SERVER – Pending IO request in SQL Server – DMV

March 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV

I received following question: “How do we know how many pending IO requests are there for database files (.mdf, .ldf) individually?” Very interesting question and indeed answer is very interesting as well. Here is the quick script which I use to find the same. It has to be run in…

SQLAuthority News – Download – Microsoft SQL Server Compact 4.0

March 12, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP.NET websites and Windows desktop applications. SQL Server Compact 4.0 has a small footprint and supports private deployment of its binaries within the application folder, easy application development in Visual Studio and WebMatrix,…

SQL SERVER – Finding Latch Statistics

March 11, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Last month I wrote SQL Server Wait Types and Queues series SQL SERVER – Summary of Month – Wait Type – Day 28 of 28. I had great fun to write the series. I learned a lot and I felt this has created some deep interest on the subject with…