Did you know that the mean salary of a MCSE certified professional is $65,100, well above the industry standard (source MCP Magazine)? That's not including the long term benefits such as bonuses and promotions. No salary surveys have been conducted by Microsoft as of today for MCDBA certification. With the limited amount of MCDBA certified DBAs though, the demand far by out weighs the suply.
2001-05-01
5,057 reads
This article describes how to create a Visual Basic application for merge replication that will handle both conflict and non-conflict changes between the affected tables.
2001-05-01
2,075 reads
This article shows you the basics of connecting to SQL Server in Active Server Pages.
2001-04-30
8,642 reads
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
2001-04-30
5,407 reads
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
2001-04-30
9,433 reads
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,658 reads
This week, Brian Knight reviews the book Gurus Guide to Transact SQL.
2001-04-29
5,493 reads
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,925 reads
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-27
4,909 reads
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
2001-04-26
3,543 reads
Dreaming of a data analyst career but feeling a little lost? Already playing with...
I came across a bit of a weird error when I was trying to...
As a Software Engineer, i would like to learn how to dockerize my Python...
Hi Our Physical servers are going to be moved to a new location and...
Comments posted to this topic are about the item Is Perfect Software Attainable?
I run a marked transaction across multiple databases with this code:
BEGIN TRAN onemorenewdbTran WITH MARK 'mark from 3 dbs' USE sandbox2 INSERT dbo.AddressTable (AddressID, AddressValue, AddressPostal) VALUES (12, '123 three St', '4444') GO USE sandbox3 INSERT dbo.Logger (logdate, logmsg) VALUES (GETDATE(), 'tran message') GO INSERT sandbox4.dbo.logger (uid) VALUES (700) COMMIT TRAN onemorenewdbTran GOHow many marks are inserted into msdb.dbo.logmarkhistory? See possible answers