Referencing Remote Data
Synonyms were added to SQL Server to make the references to remote data easier. However Steve Jones doesn't use them, do you? Are there benefits?
2012-01-10
159 reads
Editorials
On Database Migrations and Agility
It always surprises me when Application programmers tell me that all 'Agile' techniques are directly applicable to database development. Ideally, yes; but reality gets in the way.
2012-01-09
164 reads
The Stubborn DBA
Today we have a guest editorial from Phil Factor. Phil wonders why so many people in technology can be stubborn. Are you a stubborn DBA?
2012-01-09
533 reads
Read-only Data
Today's poll looks at read only data and how you handle the backup and recovery of this data.
2012-01-06
152 reads
Are Auto-Updates Good?
Internet Explorer is going to get automatic updates soon and Steve Jones thinks it's a mixed blessing.
2012-01-05
132 reads
Truth and Demos
Today Steve Jones reminds us that we are all selling something in technology, even if it's our reputation. We ought to be truthful in our dealings with our clients.
2012-01-04
139 reads
Cloud Patches
The cloud changes the way that we can administer and deploy changes to our systems. Steve Jones highlights an interesting idea, and hopes we get similar techniques applied to databases in the cloud.
2012-01-03
118 reads
SharePoint - Subversive?
A reflective editorial on how SharePoints and other collaborative work spaces are getting used.
2012-01-02
234 reads
Voluntary Constraint?
In which Phil Factor argues that Domain Constraints are a fundamental part of the relational database. If he had to sacrifice a feature of relational databases, it wouldn’t be domain constraints.
2012-01-02
107 reads
The Data Resolutions
The last Friday poll of 2011 has Steve Jones asking about what you want out of 2012.
2011-12-30
123 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers