One thing I have gotten wrong before, or not elaborated on before in presentations on mirroring, although Roman Rehak mentioned...
2010-12-16
2,289 reads
Just this past week on Tuesday afternoon, U.K. Information Commissioner Christopher Graham spoke in the Wilson Room for the House...
2010-01-15
1,548 reads
Let's say it is a late Monday morning, because something always comes up before you are required at your vocation,...
2009-08-10
5,608 reads
You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,
2009-07-14
2,920 reads
The goal of this post is to understand the procedure cache and execution plans to ensure we use fewer resources and that queries run better. Better means higher throughput, more concurrency and fewer resources – as described by MVP Joe Webb during SQLTeach in Vancouver just last month.
2009-07-08
1,134 reads
The goal of this post is to explain how to handle errors thanks to a useful T-SQL functionality, available since SQL 2005 onwards, that developers are already used to – and similar to how exceptions are handled in the Visual Studio environment.
2009-06-11
5,706 reads
The goal of this post is to explain how to take advantage of Auto-Retry and why you will want to use it. I hope to clarify in which circumstances an auto-retry works best and when not to use it also. The (disclaimer!) point is that every job has its own constraints, requirements, and has to be evaluated individually for whether an auto-retry will work. I will try and keep this summary short and crisp, but still with enough detail to understand auto retry best.
2009-06-01
3,877 reads
Starting the summer 2002, for about a year or so, the team and I embarked on a project to develop business for local utilities giant Hydro Quebec, by developing a web site for the twenty-first International Commission on Large Dams' congress in Montreal, where it was hosted in 2003.
2009-03-30
2,257 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 with respect to the security of the data in databases used for annual reports. Internal controls fall...
2009-02-19
1,166 reads
As reporting requirements increase, it seems that aggregate functionalities have thankfully risen to the occasion concurrently. To maintain its competitive edge as Staples Canada’s best vendor, BaldGorilla, where I’m currently consulting, has been able...
2009-02-05
2,050 reads
By SQLPals
While I always configure transaction log backups for every database in non-simple recovery model,...
By Steve Jones
There’s a video of Bill Gates taking a drive in an autonomous car around...
It is common to see high worker count issue on the production server and...
We are setting up new data warehouse with Amazon Redshift and building integrations to...
I have a stored procedure that was created to run dynamically. Other than me...
Ask SSC