Security issues when using aliased users in SQL Server
This tip shows you how to find security holes when aliased users are setup in your databases and also that this feature will be deprecated in SQL Server 2008.
2009-02-09
2,352 reads
Security
SQL Server security settings using the Surface Area Configuration tool (SAC)
Are any tools available to secure SQL Server independent of the logins and users that I have in place? Do I need to manage SQL Server on each machine or can I do so from a single application?
2009-01-30
2,589 reads
2009-01-29
3,951 reads
SQL Server security: Database roles
Database roles for SQL servers can increase the security of your enterprise. Understand how to set up database roles, and learn how they function.
2009-01-21
4,193 reads
2009-01-07
2,968 reads
2009-01-06
3,392 reads
2008-12-23
73 reads
Using the Service Audit Object in SQL Server 2008
Brian Kelley looks at auditing in this article about SQL Server 2008 and the enhancements made in this version. The new Audit Object allows you to more easily determine what is happening on your SQL Server instance.
2008-12-18
3,311 reads
How do I assign permissions to users to see SQL Agent Jobs?
You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server
2008-12-16
3,346 reads
2008-12-12
49 reads
Blogs
T-SQL Tuesday #191: Invitation–Your Favorite String Parsing
By Steve Jones
It’s that time of the month, and I’m late. My apologies. I had a...
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers