Featured Article(s)
Find out the last updated date of SP, UDF, Views, Triggers in SQL Server 2005
(Vadivel Mohanakrishnan) This article explains the way to list the last updated datetime of Stored procs, user defined functions, views and triggers in SQL Server 2005.
Watch SSWUGtv
The following are available now:
[Watch] – SelectViews SQL Server Show – Microsoft interviews, features and more.
[Watch] – SQLonCall – Top 10 List for SQL Server in 2007
Top 10 List
Last Friday I started a poll to get your top 10 things for SQL Server. I mentioned an article I’d seen, and wondered what we’d come up with as a community as a top things to consider with SQL Server… in "Top 10 List" format. Here’s a look at one partial list:
1) Changing the SA account PW to see what breaks.
2) Switching the ports that are open on your sever.
3) Letting a developer make diagrams of the tables.
4) Testing index sequences for performance in daytime hrs.
5) Never testing your backups.
6) Testing your cluster switch over in daytimes.
What would you add? Change? Delete? Drop me a note here and let me know.
I guess it’s not really about Top 10 things in 2007, but more like top 10 things for SQL Server… in general. To do, or not to do. Perhaps there are two lists.
To Do:
1) Enforce strong passwords with Windows Integrated Security
2) Learn about and test for injection
3) Monitor and Forecast server usage
…
Not To Do:
1) Give all users DBO access because it’s "easier"
2) Pay no attention to indexes
3) Have checks in place to make sure your backups are being done
4) Not testing your backups
…
Featured White Paper(s)
Top Ten Steps to Secure Your SQL Server
In most organizations today, business critical and confidential data increasingly resides in Microsoft SQL Server databases. … (read more)
Are AJAX Applications Vulnerable to Hack Attacks?
This paper reviews AJAX technologies with specific reference to JavaScript and briefly documents the kinds of vulnerability c… (read more)