Combining SQL Server & Flash Technologies - Floor Plan example
Starting the summer 2002, for about a year or so, the team and I embarked on a project to develop business...
2009-03-19
968 reads
HuggyBear
- Interests: Lately (2019): windfoiling or windsurfing with a Skroka foil....amongst many other supposedly 'extreme' sports, but which are really just the norm for people raised in Lotusland aka Vancouver, BC, lower-mainland region, Sea-to-Sky country as we know it.
- Blog: http://dbhive.blogspot.com/
- Jobs: SQL DBA, Data Engineer, Migrator, Clusterer, Security Implementor
- Website: https://ca.linkedin.com/in/intellabase
- LinkedIn: https://ca.linkedin.com/in/intellabase
Weeding Out Discrimination in the Workplace – A Note to Government Institutions in Quebec, and ex-Premier Bernard Landry
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,318 reads
Dot Net Usergroup in Montreal Presentation notes - Grouping Sets in SQL Server 2008
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
641 reads
An Optimised Disaster Recovery Plan thanks to SQLBackup
The continuity of operations during a disaster is as critical to running a business as just about anything. Somewhere, within...
2009-02-28
2,286 reads
The Importance of the Segregation of Duties with Respect to Internal Controls
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
The Importance of the Segregation of Duties with Respect to Internal Controls
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,870 reads
All the Aggregates you crave with Grouping Sets in SQL Server 2008
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
All the Aggregate Data you Crave with Grouping Sets in SQL Server 2008
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,672 reads
It's minus twenty-five outside and I'm writing about Transaction Log Files
I originally wrote this in French while working at LaCaisse.com "Why do you care, as a DBA (or a developer for that matter), about what is happening in the transaction...
2009-01-21
1,896 reads
It's Minus Twenty-Five Outside and I'm Writing about Transaction Log Files
(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,547 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers