(Pinalkumar Dave) I just overheard the following statement – “I do not use Transactions in SQL as I use Stored Procedure“.

(Arshad Ali) SQL Server Service Broker – An Introduction introduced SQL Server Service Broker (SSBS), used to write message based asynchronous applications. I briefly discussed SSBS and its capabilities. Let me introduce the different components of SSBS:

(Zhiming Xue) I reinstalled SQL Server 2008 Express on my dev machine recently and ran into an error below when I tried to open and run a Visual Studio application: “Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will b

(Siddharth Mehta) SQL Server 2008 introduced a new category of datatypes known as spatial datatypes which store spatial information. The new spatial datatypes are geography and geometry. SQL Server Management Studio comes with good good support for these spatial data types like the spatial results t

(Jamie Thomson) My day job involves implementing Business Intelligence (BI) solutions which, as I have said before, is simply about giving people the information they need to do their jobs. I’m always interested in learning about new ways of achieving that aim and that is my motivation for writing b

We have written before about some of the new functionality available in SSRS 2008 R2 – you can read more on that here. We had discussed the support for map and spatial data in that post. In this post, we are going to look into another data visualization enhancement called the Data Bars. This has

(Ashish Kumar Mehta) I have installed SQL Server 2008 Developer Edition on Windows Server 2008 R2 and I am unable to get connect to SQL Server 2008 Analysis Services Instance from SQL Server 2008 Management Studio which is installed on another remote server. As I am new to Windows Server 2008 R2 it

(Buck Woody) I ran into an issue the other day where I couldn’t set up some features in SQL Server 2008 because they ddon’t support the use of Rules or Defaults. Let me explain a little more about that. In older versions of SQL Server, you could decalre a “Rule” or “Default” just like you do with a

(Gregory A. Larsen) As a database developer or DBA there is not a lot you can do about a legitimate user sharing confidential data. However, you can minimize the risks of someone breaking into our database and browsing around to find confidential information. This article explores how you can use SQ

(Wayne Berry) In my posts about RAID (part 1 and part 2), I didn’t cover RAID 1 + 0 because RAID 1 + 0 isn’t a good combination for SQL Server running Teamcenter. However, we have received many questions about why I didn’t cover RAID 1 + 0. So, I’ll explain how SQL Server can provide the 0 of RAID […]