Activity Monitor in SQL Server 2008: an Embedded Optimisation Gizmo for the Thrifty DBA
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,777 reads
As promised back in December ‘08, after having spoken briefly at SQL teach here in Montreal thanks to MVP Paul...
2009-04-09
1,777 reads
If you are planning a move to SQL Server 2008, although this process can apply for many Database Migrations, perhaps...
2009-03-31
4,822 reads
Starting the summer 2002, for about a year or so, the team and I embarked on a project to develop business...
2009-03-19
973 reads
In response to former Quebec Premier Bernard Landry’s comments of this past week regarding the posting of Michael Sabia as...
2009-03-15
4,328 reads
Yesterday evening I gave a talk about Grouping Sets in SQL 2008 thanks in part to the original front-page blog post...
2009-03-13
647 reads
The continuity of operations during a disaster is as critical to running a business as just about anything. Somewhere, within...
2009-02-28
2,298 reads
I diverge a little from the typical coding-based/oriented best practice to one that is focused on governance within public or government organisations...
2009-02-15
7,913 reads
As reporting requirements increase, it seems that aggregate functions have thankfully risen to the occasion concurrently. To maintain its competitive edge...
2009-01-28
2,680 reads
(1linerForward) I originally wrote this in French while working at LaCaisse.com - http://dbhive.blogspot.com/2008/07/fichiers-journaux-de-transactions.html
Why do you care, as a DBA, or a Developer...
2009-01-17
7,582 reads
One of the great new features in SQL 2008 is Row and/or Page Compression. Plus, still good news for those...
2009-01-02
1,766 reads
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers