The cloud should bring with it lower costs, and better efficiency, but that's not necessarily the way things are. Microsoft has a great internal project that costs out the cloud for their departments, and this would be a great addition to the public or private clouds.
2011-06-27
165 reads
There is now a vast amount of SQL Server information and 'best practice' advice available on the Internet, in the form of innumerable blogs, community sites and forums. Finding an answer to your question is relatively easy, but finding the right, or best, answer is harder than ever.
2011-06-27
473 reads
This Friday Steve Jones asks about how you handle audit data in your environment. Do you regularly analyze the data? Or do you wait for something to go wrong before you check the data.
2011-06-24
127 reads
Does the age of software matter? Steve Jones talks about this after there was a decision for the SQL 11 tools not to support Windows XP.
2011-06-23
259 reads
Today Steve Jones talks about a new use for cloud computing with Excel to analyze large sets of data.
2011-06-21
159 reads
It seems that archival isn't on the mind of most designers when they first build a database, which is OK, but DBAs ought to be building skills to implement this if the data size grows large.
2011-06-20
735 reads
This week Steve Jones notes there were quite a few patches from Microsoft for a variety of products. No SQL Server specific security patches, but that doesn't mean that DBAs shouldn't be patching systems.
2011-06-20
132 reads
This Friday Steve Jones has a disaster recovery poll. When you have a true disaster, often there are multiple things that go wrong and cause a cascading failure. Is this common, let us know what your experience is this Friday.
2011-06-17
103 reads
Today we have a guest editorial from Andy Warren. Are there particular phrases that you use in technology that resonate with you and have particular meanings? Andy shares a few of his favorites.
2011-06-16
150 reads
It is important for data professionals to understand security, but it's also important for end users that must handle data. However we have a lot of work to do to make that easier since Steve Jones thinks many IT pros struggle with this concept.
2011-06-15
280 reads
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Not sure if this is really a relational theory question but it seems about...
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
Hi all, I recently moved to a new employer who have their HA setup...
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers