Subscribe to latest posts
Archives: January 2010
Professional Association of SQL Server (PASS)
I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make chapter and user group meetings (like me) this can be an excellent way of getting some excellent SQL Server training. I only came across the virtual chapters recently.…
0 comments, 461 reads
Posted in The SQL DBA in the UK on 31 January 2010
Reading in 2009
2 comments, 437 reads
Posted in The Voice of the DBA on 31 January 2010
Interview Questions on Sql Server -Part 3
1) Inner join or Equi join
2) Self Join (it can be considered as the part of Inner join)
0 comments, 657 reads
Posted in Vivek's SQL Notes on 31 January 2010
Interview Questions On Sql Server -Part 2
0 comments, 575 reads
Posted in Vivek's SQL Notes on 31 January 2010
Interview Questions on sql server -Part-1
0 comments, 635 reads
Posted in Vivek's SQL Notes on 31 January 2010
Group by.....Having Clause
0 comments, 829 reads
Posted in Vivek's SQL Notes on 31 January 2010
Difference Between Having and Where Clause in Sql Server
0 comments, 674 reads
Posted in Vivek's SQL Notes on 31 January 2010
How to find duplicate values in a table
0 comments, 562 reads
Posted in Vivek's SQL Notes on 31 January 2010
Sql Server View
0 comments, 523 reads
Posted in Vivek's SQL Notes on 31 January 2010
Stored Procedure to Get SQL Job Execution Status
Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a while searching on Google I did not turn up anything I liked so I turned to Profiler and started looking at what calls SQL Management Studio uses. After a… Read more
0 comments, 746 reads
Posted in Adventures in SQL on 31 January 2010
Try Catch within an SSIS Script Tasks and Components
Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice. The thing you want to be able to do is push any errors you trap to a log file. The syntax is somewhat simple, but it took me some…
0 comments, 516 reads
Posted in SQLRunner on 30 January 2010
SEO my SQL Server Blog
0 comments, 440 reads
Posted in The SQL DBA in the UK on 30 January 2010
SQLSaturday #41 Announced
Stuart Ainsworth will be coordinating the second SQLSaturday in Atlanta, this time on April 24th, 2010. Registration and call for speakers is now open!
1 comments, 422 reads
Posted in SQLAndy on 29 January 2010
Columbia Code Camp 2010
We're making a final push to let everyone know about the Columbia Code Camp 2010, which happens tomorrow, January 30. It's being held in downtown Columbia, and there are 6 different tracks, including 2 SQL tracks (yes, 2 SQL tracks at a code camp). From the SQL Server side speakers include… Read more
0 comments, 453 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 January 2010
Introduction: Developing with SQL Server
As a developer based primarily in the Microsoft world I have over the last 10 years spent time working with four of the main Seattle produced database products: Excel, Access, SQL Express and SQL Server.
In this time I have learned to find my way around each product and made… Read more
0 comments, 379 reads
Posted in DatabaseExpertise.com on 29 January 2010
Paul Randal’s Benchmarking Series
Fellow SQL MVP Paul Randal of SQLSkills, (who is also Kimberly Tripp’s husband, and a former long-time Microsoft employee) has been working hard on a great benchmarking series with some actual Dell server hardware that he has setup in his house (and I thought I was a geek). His… Read more
0 comments, 951 reads
Posted in Glenn Berry's SQL Server Performance on 29 January 2010
Book Review: The Breach
The Breach by Patrick Lee ($8 at Amazon) was a gift, and wasn’t quite what I expected based on the title. Bad guy now good guy Travis Chase is out on a mountain hike to find himself when he finds a recently crashed 747, which poses the obvious question –… Read more
0 comments, 408 reads
Posted in SQLAndy on 29 January 2010
SQLSaturday #30 Rescheduled
Got the email today, SQLSaturday #30 has been rescheduled for April 10, 2010, due to projected bad weather on the original date this weekend. Andy Leonard and Jessica Moss did a great job of handling this, getting an email out early in the week to warn of a possible change… Read more
0 comments, 395 reads
Posted in SQLAndy on 29 January 2010
But We Have Always Done It That Way
I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL Server 2008. At the same time, the older physical hardware had been replaced by newer hardware. The DBA who had set up and configured the older server was no longer… Read more
17 comments, 635 reads
Posted in SQL Aloha on 29 January 2010
SQL Saturday Richmond - Postponed
If you’re anywhere from the southwest to the deep south, you’re probably aware of the impending winter weather bearing down on this large area. Unfortunately, Mother Nature has temporarily claimed a significant victim: This weekend’s SQL Saturday event has been postponed until April 10, 2010.
For more information, visit the… Read more
0 comments, 409 reads
Posted in Tim Mitchell on 28 January 2010