Security in SQL Server is not too complex, following a fairly simple framework for allowing and preventing access to data. However there are a few places where it can get tricky and some concepts that many people do not understand. Rob Farley brings us an explanation of one of those areas: ownership chaining. Read about how ownership chaining can be useful and also how it may open security holes in your environment.
2006-10-03
6,411 reads
Mairead introduces you to how to create your database project using the latest edition of Visual Studio Team System - Team Edition for Database Professionals. Check out this quick 10 minute demo to get a whirlwind tour of project creation within VSTE for DB Pro.
2006-10-03
2,122 reads
This article explains how desktop applications can use SQL Server 2005 Data Mining to analyze in-memory data.
2006-10-03
2,504 reads
We're blowing out inventory again to make room for new books. Stock up your SQL Server library with a few of our titles.
2006-10-02
3,716 reads
SQL Server 2005 has made it much easier to work with XML data in your database applications than ever before. In this article, new author Jack Hummer examines how you can use XML to move data through stored procedures.
2006-10-02
9,437 reads
Continuing the overview of Data Flow components in SQL Server 2005 Integration Services, this installment focuses on the Lookup transformation.
2006-10-02
1,785 reads
The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.
2006-09-29 (first published: 2004-09-28)
40,407 reads
Database snapshots provide a handy way to provide data integrity for Integration Services. In this presentation, Brian shows you how to create a package that can "self-heal". In the event of any problem, the database will automatically roll back to a pre-ETL snapshot.
2006-09-29
2,186 reads
Ownership chains have unique permissions' issues in SQL Server 2005. Contributor Serdar Yegulalp explains the access levels of ownership chains, and the benefits of "EXECUTE AS."
2006-09-29
1,943 reads
Our look at the SQL Server development team continues with Craig Freedman, query tuning expert working on partitioning features. Read a little about a talented software engineer that has been developing database software for over a decade.
2006-09-28
4,497 reads
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Comments posted to this topic are about the item Can You Really Downgrade from...
Comments posted to this topic are about the item What is CPU Usage?
Comments posted to this topic are about the item Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers