SQL Archives - Page 446 of 349 - SQL Authority with Pinal Dave

SQLAuthority News – Microsoft Source Code Analyzer for SQL Injection

June 24, 2008

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Download, SQL Server Security

Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for finding SQL Injection vulnerabilities in ASP code. Customers can run the tool on their ASP source code to help identify code paths that are vulnerable to SQL Injection attacks. Perform the following steps to download and…

SQLAuthority News – Release Notes for SQL Server 2008 Release Candidate 0

June 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

All product should be documented. Particularly when any release happens product must have release notes because release notes educates people about product and its usage. Microsoft has also release notes for SQL Server 2008. This Release Notes document contains information for Microsoft SQL Server 2008 Release Candidate 0 (RC0) that…

SQL SERVER – Create Check Constraint on Column

June 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Error Messages, SQL Scripts

I found one of the Jr. Developer writing trigger for the requirement where he wanted to make sure invalidate data does not enter in table column. I suggested him to write Check Constraint. Check Constraints are very handy to make sure all the data in the table is validated before…

SQLAuthority News – White Paper: Security Overview for Database Administrators

June 21, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download, SQL Server Security, SQL White Papers

Note: Download White Paper by Microsoft SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL…

SQL SERVER – Find Current Identity of Table

June 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL Server DBCC

Many times we need to know what is the current identity of the column. I have found one of my developer using aggregated function MAX() to find the current identity. USE AdventureWorks GO SELECT MAX(AddressID) FROM Person.Address GO However, I prefer following DBCC command to figure out current identity. USE AdventureWorks…

SQLAuthority News – Famous Quotes From Bill Gates

June 18, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Humor

Bill Gates Quotes – “Success is a lousy teacher. It seduces smart people into thinking they can’t lose.” “Until we’re educating every kid in a fantastic way, until every inner city is cleaned up, there is no shortage of things to do.” “If I’d had some set idea of a…

SQL SERVER – 2008 – SQL Server Start Time

June 17, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Scripts

I have been playing with SQL Server 2008 recently. There are many new features which SQL Server 2008 have. One of the interesting addition to SQL Server 2008 is system table field which records when SQL Server was started. This field has data type as datetime that is why it…