In my previous editorial on this topic, I stated that the An Exceptional DBA is defined more by what they do than what they know. Judging by the responses, there is little disputing this fact among DBW readers. However, before we accept technical knowledge as a "given", and move on, I'd like to consider the […]
2008-04-21
1,319 reads
There are many SQL Server DBAs with an intimate knowledge of how SQL Server works, the operating system, hardware and so on. They have the skills to keep a production system running without a hitch. It is no longer enough.
2008-03-31
986 reads
SQL Server isn’t used much for web-based applications, simply because the cheapest ISPs use Linux and Apache for their platform. There are ISPs that provide a .NET platform and SQL Server but it is at a cost. SSDS seems to be Microsoft’s latest attempt to break into the market for database-driven websites.
2008-03-17
139 reads
Anyone who inherits a database application dreads poorly laid-out SQL code. Development teams loathe it. Putting it right would be easier, if there was a common, agreed, standard in place, so why the difficulty?
2008-03-03
213 reads
2008-02-04
40 reads
The purchase of MySQL by Sun is an interesting move by Sun, which has pondered it's own database product.
2008-01-21
42 reads
Tony Davis offers his congratulations on a new MVP at SQLServerCentral.com and DatabaseWeekly.com.
2008-01-07
47 reads
By Brian Kelley
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking...
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
Hello Everyone, I am using Microsoft SQL Azure (RTM) - 12.0.2000.8, as of October...
For MSSQL is there any queries or methods for me to pull historical data...
Background: I have two tables. Tests and Grades. For each Tests record there are...
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers