Ronni Colville on Configuration Management Databases
Gartner has stated in the past that "configuration management is at the very heart of IT service management." What do you mean by this?
2006-03-24
1,964 reads
Articles
Free SSIS Events and Code Camp
There are a few upcoming SQL\SSIS\Developer events coming up in the next week. Andy Warren and Brian Knight will be speaking at Code Camp in Orlando (a free full day event) and Brian will be doing a SSIS event in Philadelphia. For more information, see this blog post.
2006-03-23
1,631 reads
Ten of the Biggest Mistakes Developers Make With Databases
You may be wonderfully up-to-date with an AJAX Web interface or the latest whizbang Windows user interface, but under the covers, you're probably still pumping data in and out of a database, just as we all did a decade or more ago. That makes it all the more surprising that developers are still making the same database mistakes that date back to those good old days of Windows 95 and before.
2006-03-23
6,331 reads
Jump Start Your SQL Server 2005 Learning
There are many changes in SQL Server with the release of SQL Server 2005, but none more telling than the client tool used to manage your servers. Check out this new e-book for learning about SQL Server 2005 Management Studio form SQLServerCentral.com.
2006-03-22
5,588 reads
Are Your Database Backups Current and Available?
It is an interesting question and one I hope every DBA can answer positively. New author Thomas LaRock brings us his method for ensuring that the backups have occurred and the files are still on disk.
2006-03-21
7,998 reads
Two Stops Short of Dagenham
One of the best programmers I ever met was referred to, in Essex jargon, as being ‘two stops short of Dagenham’ (Barking)*. This was once no obstacle to the world of work…the best development teams I’ve worked on embraced the whole gamut of humanity
2006-03-21
2,286 reads
First Impressions of Professional SQL Server 2005 Integration Services
Impressions of this new book from Brian Kelley.
2006-03-20
2,672 reads
Security Enhancements in the .NET Framework 2.0
Security support in the .NET Framework got a lot of love in version 2.0, and this column is going to take you on a whirlwind tour of the goodies you'll find there. I won't be able to cover everything, but you'll know where to start looking to stay on top of the new changes. I'll take this a namespace at a time.
2006-03-17
1,725 reads
Cycling the ERRORLOG file and Deleting Backup History Information
Every DBA needs a few tricks up his/her sleeves to help them better manage their SQL Server 2000 environment. In this article I will explore a couple of such tricks. I will first explore how to cycle the SQL Server error log, and why you might want to do this. Secondly I will discuss backup history information and why you would need to periodically remove some of the older history information.
2006-03-16
2,855 reads
Server Consolidation
Are you thinking about consolidating your SQL Servers on to fewer machines? It is an interesting idea and one that is definitely more possible with SQL Server 2005 and 64-bit servers. Steve Jones takes a look at some of the pros and cons of moving to fewer servers.
2006-03-15
7,479 reads
Blogs
Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module
Full documentation on the Undercover Catalogue can be found HERE It’s been a while...
Derby City Data Days
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
Forums
Difference between equal directly and use SUBSTRING
Hello, I have a script that was running really long, and I have found...
Visualisation options as an alternative to SanKey diagram
I am building a report to show customer journeys and their arrears levels. I...
should i prefer join or left join over exists or in
hi, I have seen people use exists when exists is required and no cols...
Question of the Day
Express In-Memory OLTP
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers