Notes from the June 2008 oPASS Meeting
Our main presentation was on 'Unlocking the Power of SQL Compact' by Steve Lasker & Ginny Caughey. Went better than I expected...
2008-06-04
418 reads
Blog Posts
Security by Obscurity?
Andy Warren points to a TechNet article about Security by Obscurity and wanted me to post some notes. Let's start...
2008-06-04
952 reads
Managing Money
First, the usual disclaimer: I'm not a financial professional, so take all of the following with a grain of salt...
2008-06-03
742 reads
Replication Error "field size too large"
Yesterday, I was fighting with an error I have never seen in the replication and not much info can be obtained via...
2008-06-03
16,114 reads
World Wild Telescope & Misc Microsoft Stuff
Just took a look at the World Wild Telescope and it looks interesting, perhaps just as importantly looks cool! Don't...
2008-06-03
430 reads
DIY
Last month the LCD screen on our treadmill went out. We bought it last Christmas (06) as a present for...
2008-06-02
728 reads
Reminder - SQLSaturday #4 in Orlando June 7-8, 2008
Last call! We've got a 2 day event running this time. Saturday is the more traditional (it's only #4 after...
2008-06-02
231 reads
Security by Obscurity?
If you're not familiar with the term it means to make something safe/secure by using a trick to hide the...
2008-06-01
207 reads
Now on Twitter
A few colleagues of mine, Andy Leonard, Jason Massie, and Chuck Boyce, are all on Twitter. As a matter of fact,...
2008-05-30
1,514 reads
Security Issue with SQL Server Reporting Services 2008
I have a CTP of SSRS 2008 deployed to one of my servers. Today I built a couple of reports...
2008-05-30
2,535 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers