SQL Consulting: SQL Server Is Our Business.
posted on
A study by the Gartner Group concluded that 70% of all companies experiencing a serious data loss will be out of business within a few months as a direct consequence of the data disaster. According …
Continue Reading about The Best Time to Create a Backup Plan is Right Now →
posted on
Everyone who programs a database has heard many times that the SQL language is optimized for set based solutions rather than procedural solutions, but examples are seldom provided with that advice. …
posted on
Clustering, Mirroring and Log Shipping The SQL Server features most often mentioned for high-availability and redundancy solutions are clustering, log shipping and database mirroring. However, …
posted on
To get the most for your money Microsoft recently changed some details of its licensing model for SQL Server. Understanding the new licensing model might save you a lot of money on licensing …
posted on
Deadlock Graph is a trace event that first appeared in SQL Profiler for 2005. Because of the number of important new features in that release, Deadlock Graph did not get a lot of attention. …
Continue Reading about Fixing Deadlocks with Deadlock Graphs →
posted on
Like all technologies, XML has its strong and weak points. It is useful in many situations. However it is often used in places where it is not appropriate. The performance cost of XML mis-use or …