Data Quality on the Open Web
As we look to take more data from customers and clients and embed it in our applications, data quality becomes a bigger issue
2011-09-21
86 reads
Editorials
Free as in Beer
This editorial was originally published on Feb 7, 2006. Today Steve Jones looks at the problems of plagiarism and the avoidance of work by many people these days.
2011-09-20
163 reads
Dreaming of Windows
This week Steve Jones dreams about the changes he would like to see in the next version of Windows, unveiled this past week at the Microsoft Build Conference.
2011-09-19
71 reads
Intertia
This editorial was originally published on August 22, 2006. Steve Jones looks at the pace of change in companies and notes it ought to be dictated by the business, not IT.
2011-09-19
69 reads
Dotted Line Relationships Are Everywhere – Get Good at Them!
Today we have a guest editorial from Andy Warren. Andy talks about the relationships we have at work with our management and how sometimes the indirect reports are hard to deal with.
2011-09-16
115 reads
Cloud Common Sense
Moving to the cloud, or any other type of outsourcing should be done with common sense, as Steve discusses today. That means keeping control of your backups.
2011-09-15
111 reads
Not on the Same Page
It seems that security staff and other technical people are not always on the same page. Steve Jones says that we should be working to take security more seriously.
2011-09-14
93 reads
2011-09-13
123 reads
A Matter of Life or Death
Could your job as a data professional result in the death of someone? It's entirely possible this might affect you at some point. Steve Jones talks about why you ought to do your best when setting up security.
2011-09-12
155 reads
Now you ODBC me now you don't
Phil Factor reflects on Microsoft's "handbrake turn" on OLE DB; Denali's successor will have to have all this plumbing ripped out to replace it with the older ODBC technology. It's a surprising move but makes a lot of sense, given the ubiquity of ODBC drivers for relational data access.
2011-09-12
285 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
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