Now that all my server are SQL Server 2008 I use SSMS with SSMS Toolpack and Toad. I don't really use Query Analyzer anymore. The other day I found out that you can hide objects you don't want to see in SSMS by using filters. Let's first look at some code. Create a new database named test, create a new schema named Denis and then add 3 tables to the dbo schema and 3 tables to the Denis schema. Just run the code below

create database test
go

use test
go

create schema Denis
go

create  table Test1(id int);
go
create  table Tes...

Here is something interesting to think about Create this table and insert these 2 rows

create table TableName(id int, name varchar(50))
insert TableName values(1,'bla')
insert TableName values(2,'bla2')

Now if you try to do something like this

   SELECT TOP 1 ID,Name
   FROM TableName
   ORDER BY Name
   UNION ALL
   SELECT 0,''

You will get the following error Server: Msg 156, Level 15, State 1, ...

ASP.NET MVC 2 RC 2 has been released and is available for download.

For those that don't know what ASP.NET MVC 2 is. ASP.NET MVC 2 is a framework for developing highly testable and maintainable Web applications by leveraging the Model-View-Controller (MVC) pattern. The framework encourages developers to maintain a clear separation of concerns among the responsibilities of the application – the UI logic using the view, user-input...

This will primarily be an extension into the Wiki section on SQL Server Admin Hacks.

OLTP and Reporting

Reporting from OLTP (Online Transactional Processing) databases can be nothing short of difficult at times. The process of reporting of these types on databases can cause blocking, long wait times and in some severe cases, complete failure on the part of the high level operational requirements of the database. In the stage in which we consider how reporting will affect our databases and how t...

Yesterday 2 QNap TS-419P Turbo NAS arrived at work for me to play with. The question of course is how did I choose a solution that will work for me? To be honest pure luck. To be honest you have too much choice and choosing the right thing isn't going to happen unless you trust to pure luck or try some things out and that takes time. So I trust to luck. And no it does not help to read reviews or the manufacturer's website since most sites will not tell you the truth anyway. Neither will I BTW I just tell you what I think is impo...