Changing jobs -- Pros and Cons
I read Andy's post Changing Jobs - Should You? today with great interest. I think it is good topic in the...
2008-08-08
1,295 reads
Jeffrey Yao
Cold backup and remote control of sql server services
I recently got a request to do a "cold" backup of a small yet complex db environment, I say "small" because...
2008-08-02
707 reads
Replication Error "memory mapped file read failed"
I was fighting an error that was very rare to appear. I originally put a post on a MS forum
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.replication&tid=57229124-0a5a-4ec3-9055-a06b7869b872&cat=&lang=&cr=&sloc=&p=1
The...
2008-07-02
4,429 reads
Replication Error "field size too large"
Yesterday, I was fighting with an error I have never seen in the replication and not much info can be obtained via...
2008-06-03
15,986 reads
From DBA to DBAA
Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.
2008-05-09 (first published: 2007-07-12)
15,645 reads
Difference between truncate and delete
This is an old topic and well documented, just google it and I believe you will get a lot,
However,...
2008-04-22
2,191 reads
Documentation Value Formula (Part II)
In my last post, I talked about what prompted me to give a deep thought to documentation work. Documentation, to me,...
2008-03-17
993 reads
Documentation Value Formula (Part I)
As a DBA, documentation work is unavoidable, we need to do documentation about things we have done, for example, what...
2008-03-01
1,056 reads
New DBA type: Test DBA
In DBA world, usually two types of DBA are defined depending on what a DBA is focusing on, i.e. development DBA...
2008-02-29
1,882 reads
SQL Server 2005 Replication bug?
Last week, in our production, we noticed some records are missing in the subscriber side while existing on the publisher...
2008-01-15
916 reads
Blogs
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Why use XACT_ABORT?
This came up one day at my work when a developer was using it....
Using AI for Data Conversion
I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and...
Forums
Find all records in a table whose values when summed up will equal another value
I have a list of transactions in a table. Each transaction has a unique...
sp_lock memory leak
I spotted this in the release notes for CU17 in SQL Server 2022: KB3616559...
Migration related issue
I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every...
Question of the Day
Browsing for Instances
I have a SQL Server instance that is not listening for connections on port 1433. By default, all ports are locked down on my server, except for the SQL Server port. What can I do to allow users to connect to the instance without knowing the port?
See possible answers