Friday the 13th Strikes Again…
…or at least that’s what we’ll blame the rather brief editorial (like, blank) on for last Friday. We had a bit of a technical glitch. Must have been the Friday the 13th gremlins… or something. We’ve corrected the issue and it’s shouldn’t be an issue going forward.
Featured Article(s)
Oracle 2-Day DBA in x Days Post 7; Initialization Parameters
We are getting into the meat of what an Oracle database and Oracle instance is. The initialization file contains parameters and values to aid in instance startup. We explore the two types of initialization parameter files and learn how to change values.
SQL Server Weekly Show Available
SelectViews: Identity Lifecycle Management (huh?), Security, 100% CPU Issues and Upcoming Events. Also, SQL Server Instance Discovery in the Accidental DBA Segment, Noise and News in the DB World and a Lot More.
Previous videos:
[Watch] SelectViews – Bill Gates, OSLO, SOA and a whole lot more
[Watch] SelectViews – Injection Recovery, Auto-Grow/Shrink, Good Enough Follow-Up
LINQ, in Action
I’ve seen a list server posting, news group posting and even some blogs looking for examples of what people are doing the LINQ. These are just people looking to better understand the application of the technology. At about the same time (coincidentally, I believe, not a concerted blanketing effort), I received a note from Conrad, asking about this – so thought I’d get your opinion:
"How will [LINQ] affect database performance when non-DBA front-end programmers use LINQ to query databases? Sometimes their queries will be inefficient.
How is this different from using SQL in the front-end tool? Is LINQ really easier to use that SQL?
Most of the complexity in our work has to do with business logic, not technology. I sense that when you try to create a complex (and resource-intensive) query with a simpler tool such as LINQ, then the result is likely to be more CPU cycles, more I/O, etc."
Are you using LINQ? How have you seen it differ from other "traditional" approaches?
Featured White Paper(s)
Bust a Move With Your SSIS – Passing Package Variables
Explore the creation of sample development data using one of the most basic features in this new interface. Integration Serv… (read more)
7 Steps to Successful SQL Server Auditing
This easy-to-read guide will explain and simplify the basic steps associated with successful SQL Server auditing & give you t… (read more)