SQL Server 2005 has greatly expanded the capabilities of SQL Server in many different areas. One of those that has matured greatly is the integration of XML data inside SQL Server. Longtime writer and guru Michael Coles brings us the first part of a two part series on XML ion SLQ Server 2005.
How interesting would it be to not have to guesstimate what size server to buy for your next application? Steve Jones may have found a way to help you.
This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server.
Data governance is NOT a methodology. Data governance is about authority and discipline over the management of data but not THE method in which the data is governed.
Continuing on with his series on SQL Server 2005 Compact Edition, regular author Jacob Sebastian takes a look at how Visual Studio fits into your SQL CE project.
We crossed 400,000 members yesterday and it's a great achievement for us. As a celebration, we've decided to give out some prizes. Read on to see if you're one of the lucky winners.
Are specialists worth keeping inside of a company? Or does it pay to hire generalists and then get consultants as needed? Steve Jones comments on the choices you might face as your career grows.
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
The DBA life is fraught with pain. Those battles that we endure are mostly...
hi, im not a dba. For a couple of years our dev sql server...
Hello, I would like to ask whether it is technically possible to redirect a...
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Can I set Accelerated Database Recovery on tempdb?
See possible answers