The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what's going on inside SQL Server. They can provide information on what's currently happening inside the server as well as the objects it's storing. They are designed to be used instead of system tables and the various functions provided in SQL Server 2000. This article provides an introduction to DMVs and covers a few of the basic views and functions.
2005-11-15
2,315 reads
Everyone seems to focus on the large scale, enterprise level installations of SQL Server with not a lot of information on the little guy. To that end, new author Tim Mitchell brings us a great overview on what you should consider when setting up a SQL Server environment for a small scale setting.
2005-11-14
8,241 reads
Data, information, and knowledge. They're all different concepts and we sometimes lose sight of the fact that there are differences. This is a good look at the difference.
2005-11-14
2,393 reads
In this article, we will begin an extended examination of the MDX surrounding drilling up and down within our Analysis Services cubes. Comprising an analytical technique by which an information consumer can maneuver between summarized ("drilling up") and detailed ("drilling down") levels of data, drilling up or down occurs along the lines of drilling paths that are defined within the physical structures of our cubes. Often specified by the cube's dimensional hierarchies, these paths can also be based upon alternative relationships that exist within or between dimensions.
2005-11-11
2,036 reads
SQL Server Integration Services is one of the most highly anticipated subsystems of SQL Server 2005 and Kirk Haselden is the guy that got it done. Steve Jones caught up with Kirk at PASS and he agreed to an interview and here it is.
2005-11-10
9,921 reads
Simple Talk's newest commentator, Phil Factor, reveals the dark side of hiring database specialists: "Soon after he had been shown his desk in our crowded, open-plan IT office, he began laughing out loud, sporadically and inappropriately, while reviewing code. It wasn't my code, so I didn't mind."
2005-11-10
4,525 reads
Sometimes coincidences happen that make you sit back and say Hmm. Couple of days back Ovidiu, one of our senior developers, came by and asked me to blog about the Pivot transform. Then earlier today someone doing a high end POC down south need the same information.
2005-11-09
2,070 reads
SQL Diagnostic Manager from Idera is a great tool for troubleshooting issues with your SQL Server databases. Kathi Kellenberher puts this tool through it's paces and gives you some insight into how it fits in a busy SQL Server environment.
2005-11-08
16,153 reads
Where does Access fit in Microsoft’s future? Before that question is answered, we should examine why it might be important.
2005-11-08
5,350 reads
Cryptography and encryption are coming to many systems, including databases. Check out a sample chapter from this upcoming book.
2005-11-07
3,833 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers