(Peter Blackburn and William Vaughn) Security can be a very large and daunting topic. It’s often difficult to understand and more difficult to get right. In our experience, developers often feel that they’re out of their area of expertise when people start discussing Public Key Infrastructure (PKI),

(Jeremy Kadlec) At many organizations I doubt red lights flash with the sound of blaring sirens when backups fail in production environments, but I believe at every organization backups are one of the most critical IT functions. Of all backups, database backups, by most accounts, are considered the

(Herts Chen) Analysis Services is a high-performance, multidimensional query engine for processing analytical and statistical queries, which a relational SQL engine doesn’t handle well. When such queries are simple or have pre-aggregations, Analysis Services can make your job easier. But when querie

Users can analyze data stored in Microsoft® SQL Server™ Analysis Services with greater speed and flexibility than users can query the same data stored in a relational database. Analysis Services queries data more efficiently because it organizes data into multidimensional structures, stores aggregat

(Dinesh Asanka) Temporary tables are always a great help for a developer. In the early days when I used Access I used to create tables that I treated as temporary and then delete them whenever I finished my task. Using SQL Server this is much simpler. Or is it? (R)

(Bryan Keller) The Microsoft .NET Framework provides a rich security system that can run code in tightly constrained, administrator-defined security contexts. The .NET Framework system that secures code is referred to as code access security (or evidence-based security). Under code access security,

(Drew Georgopulos) Permissions are restricted in most environments. Even in development environments, only members of the sysadmin and serveradmin fixed server roles can execute the sp_sdidebug and sp_addmessage extended procedures to grant use of SQL Server’s debugger and custom error messages, lea

(Jeremy Kadlec) The quiet buzz has turned into a big bang with enough people saying IT needs “to do more with less!” Now is the time to satisfy these demands for your Enterprise SQL Server implementation. As your staff takes on this initiative “to do more with less,” do not fall victim to sacrifici

(Gregory A. Larsen) If your organization has the kind of revolving-door staff turnover that many businesses are facing, you create new logins frequently. So how do you create a new SQL Server login that has the same permissions as an existing login? Each time you create a new SQL Server login that m

(Dinesh Priyankara) The application you have written, either web-based or windows-based, need to be run fast without making end-user annoyed. I have seen many applications that have very low-level performance but can be easily optimized for some extent. For example, we need to load all shippers to d