b5media.com

Advertise with us

Enjoying this blog? Check out the rest of the Technology Channel Subscribe to this Feed

Microsoft Weblog

Archive for the ‘SQL Server’ Category

November 10th, 2008

Stop Trashing My SQL Query Diagram Layout!

Spending quite a bit of time working with SQL Server Management Studio 2005 lately. I’m still learning SQL and how to just write it by hand, so I’m still a bit reliant upon the designer mode for building and editing queries.
The problem at hand then is that I wish Microsoft did a better job on […]

By Jason Bean -- 0 comments

November 2nd, 2008

Use Less Space on Tree View Navigation

One of the most common navigation structures in software is the tree view directory.
It’s logical, it makes sense, it’s easy to quickly find what you’re looking for and it’s immediately recognizable for just about any computer easy old or new.
My only gripe is that it takes up so much room when you’re two or […]

By Jason Bean -- 0 comments

September 13th, 2008

FAT32 to NTFS Conversion Was the Beginning of My Troubles

The beginning of this week was the beginning of my frustrations with my computer that have lasted the entire week and have now extended to the weekend. I have a 250GB Western Digital Passport drive that I’ve been using now for a number of months as an extension of my laptop’s minuscule 60GB internal hard […]

By Jason Bean -- 0 comments

August 7th, 2008

Hiding SQL Databases in Directory Listing

I’m sure you’re probably getting tired of all my commentary on my complete immersion into using SQL the past few days.
As I was using SQL Server Management Studio 2005 again today I thought of another irritation that I’d like to find a solution.
When you’ve got a server open with a load of databases in it, […]

By Jason Bean -- 1 comment

August 6th, 2008

SQL Studio Management Tab Naming

Working a significant amount of time in SQL Server Management Studio this week, I was again reminded that there’s one lack of usefulness in the application that gets really annoying.
The screenshot of the interface above I’ve highlighted how the tabs appear when you have multiple query windows open.
If you open just a table or […]

By Jason Bean -- 1 comment

August 5th, 2008

Using SQL Profiler Tool

I’ve been immersing myself in a lot of SQL work the past week or so for a project going on at work. I’ve come a long way in my knowledge of SQL up to this point and the past few days have expanded that understanding into some new areas as well.
One of those areas is […]

By Jason Bean -- 1 comment

July 7th, 2008

Different Data Types Available in SQL

If you’ve been reading here very long you’re probably aware that I’ve been teaching myself VB, .NET and SQL over the past couple of years.
One of my challenges of learning is that if I’m not using something regularly, I forget it or the information isn’t just sitting in the back of my head waiting […]

By Jason Bean -- 0 comments

May 27th, 2008

Setting Up Forms Authentication for ASP.NET Website

Why in the world can I not get the built-in authentication controls to work in my installation of ASP.NET?
I’m running SQL Server 2005 and using the aspnet_regsql command tool to register everything. It appears that the aspnet_regsql works as it should, but when I try to configure the settings through the ASP.net Web Site Administration […]

By Jason Bean -- 0 comments

April 21st, 2008

What’s In Your Start Menu?

The b5 Tech Channel is having a little them post series and I thought of something that might be pretty interesting to share with everyone and we’ll get some responses back in the comments as well.
What’s in your Start Menu?
You’ve got the ability to pin a program you use frequently to your Start Menu […]

By Jason Bean -- 3 comments

April 10th, 2008

Top 10 Features in SQL Server 2008

Dan Rigsby (@danrigsby) shared some slides of information including his Top 10 Features of SQL Server 2008 at the IndyNDA meeting in Indianapolis, IN.

LINQ
Intellisense for SQL Server
FileStream Datatype
Date & Time Datatype
DateTime2 & DateTimeOffset Datatype
Hierarchical Datatype: i.e. org charts
Spatial Datatype: geography, geometry
T-SQL […]

By Jason Bean -- 0 comments