What, When and who? Auditing 101 By Roy Ernest,

What, When and who? Auditing 101

By Roy Ernest, 2011/11/28 


Part 1: http://www.sqlservercentral.com/articles/Auditing/75790/
part 2: http://www.sqlservercentral.com/articles/SQL+Server/77040/
Part 3: http://www.sqlservercentral.com/articles/Auditing/90178/ 


Other contribution on SQL Server Central by Roy Ernest:
http://www.sqlservercentral.com/Authors/Articles/Roy__Ernest/277126/ 

CRUD Operation in ASP.NET Web Applications Using HTTP Handler and jQuery By Jigar Bagadai

CRUD Operation in ASP.NET Web Applications Using HTTP Handler and jQuery

By Jigar Bagadai

Introduction

This article will demonstrate, step-by-step, how to create a basic application of CRUD (Create, Read, Update, Delete) Operations using HttpHandler in ASP.NET and Jquery Ajax API. To keep this application simple, I have not covered Validation and any other facets of a well designed application.

Requirements

Earlier, I mentioned that I have used Jquery Ajax API to make Ajax call of HttpHandler so for that, it is required to add reference of the Jquery File. You can get the latest Jquery File From the http://jquery.com or in case you are using VS2010, it will be available by default in Web projects.

........
http://www.codeproject.com/Articles/283976/CRUD-Create-Read-Update-Delete

Setup SQL Server on Amazon RDS

By Steve Jones, 2012/05/09 
http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/90227/ 

An introduction to ASP.NET dynamic data from a beginner's perspective

By Rahul Rajat Singh

http://www.codeproject.com/Articles/377291/An-introduction-to-ASP-NET-dynamic-data-from-a-beg

Things Every DBA Should Know

Things Every DBA Should Know – Webcast and Scripts

Written on May 2, 2012 by Brent Ozar in SQL Server, Videos

http://www.brentozar.com/archive/2012/05/things-every-dba-should-know-webcast-scripts/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+BrentOzar-SqlServerDba+%28Brent+Ozar+PLF%29

New FileTable Feature in SQL Server 2012

By: Ashish Kumar Mehta 

http://www.mssqltips.com/sqlservertip/2667/new-filetable-feature-in-sql-server-2012/ 

Who are the sysadmins in this sql server?

http://www.sqlservercentral.com/blogs/marlon-ribunal-sql-code-coffee-etc/2012/04/23/who-are-the-sysadmins-in-this-sql-server/

Marlon Ribunal - SQL, Code, Coffee, etc.

USE master
GO

SELECT  p.name AS [loginname] ,
        p.type ,
        p.type_desc ,
        p.is_disabled,
        CONVERT(VARCHAR(10),p.create_date ,101) AS [created],
        CONVERT(VARCHAR(10),p.modify_date , 101) AS [update]
FROM    sys.server_principals p
        JOIN sys.syslogins s ON p.sid = s.sid
WHERE   p.type_desc IN ('SQL_LOGIN', 'WINDOWS_LOGIN', 'WINDOWS_GROUP')
        -- Logins that are not process logins
        AND p.name NOT LIKE '##%'
        -- Logins that are sysadmins
        AND s.sysadmin = 1
GO

SQL Server Transaction Log Fragmentation: a Primer

SQL Server Transaction Log Fragmentation: a Primer

26 April 2012

by Greg Larsen

 

 

http://www.simple-talk.com/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/

SQL Server Reporting Services (SSRS)
http://www.mssqltips.com/sqlservertutorial/222/sql-server-reporting-services-ssrs/