Previous
SQL injection attacks point to need for more secure software
Blog Like an increasing number of such attacks, it exploited weaknesses in web based applications by using the well known technique of ‘SQL injection’ to access and steal 130 million credit card numbers. At a recent (ISC)2 Secure London seminar the...
[August 26, 2009, 18:39 in Sentry Posts by (ISC)2]
Microsoft SQL zero-day adds to IE7 woes
Blog A zero day vulnerability has been reported in Microsoft SQL server. Austrian pen-testing outfit SEC Consult has put out an advisory warning of a limited memory overwrite vulnerability in Microsoft SQL Server.
[December 12, 2008, 16:46 in News Blog by Tom Espiner]
Three recovery models for backing up your SQL Server
Talkback Hello I am quite new to SQL server and when I try to run "SELECT dbpropertyex("database", "recovery")" against the Master Database I get the error: "Server: Msg 195, Level 15, State 10, Line 1 dbpropertyex' is not a recognized function name.
About: Three recovery models for backing up your SQL Server
[September 30, 2004, 9:45]
Determining the Size of a Data Warehouse using SQL Server 2005
Blog I'm fairly new at working with Data Warehouses but have been designing and developing with SQL Server for quite some time. I'm in the beginning stages of trying to figure out how to come up with the size of the DW projected out 3 years.
[September 19, 2008, 18:03 in Working with SQL Server 2005 to Build a Data Warehouse by whitsonp]
Microsoft rethinks SQL Server strategy
Blog Microsoft is having a re-think about its SQL Server strategy and in particular about what it wants to do with SQL Data Services. Part of the company’s Azure services platform, SQL Data Services, it appeared was going to produce a fairly...
[February 27, 2009, 16:25 in by Colin Barker]
Ten reasons why you should upgrade to SQL Server 2005
Talkback I went through a # of issues with performance when upgrading from SQL Server 2000 to SQL Server 2005. I compiled them all (and the solutions) here .hopefully this helps: http://rentacoder.com/CS/blogs/real_life_it/archive/2006/04/28/477.aspx
About: Ten reasons why you should upgrade to SQL Server 2005
[April 30, 2006, 8:36]
Microsoft: No more five year waits for SQL Server
Talkback If they would not release their operating system until everything worked, we would still be using Windows 3.0.
About: Microsoft: No more five year waits for SQL Server
[November 17, 2005, 12:29]
Microsoft: No more five year waits for SQL Server
Talkback "if a feature is not ready, it doesn't go in. Define "ready" for me. If it means VS.Net "ready", I would rather wait 5 years.
About: Microsoft: No more five year waits for SQL Server
[November 28, 2005, 2:50]
Three recovery models for backing up your SQL Server
Talkback USE the following, the above will not work. SELECT [Name] AS DatabaseName, DatabasePropertyEx([Name],'recovery') AS RecoveryModel from SysDatabases ORDER BY [Name]
About: Three recovery models for backing up your SQL Server
[October 4, 2005, 8:38]
Three recovery models for backing up your SQL Server
Talkback SELECT DATABASEPROPERTYEX('tempdb','recovery')
About: Three recovery models for backing up your SQL Server
[June 22, 2006, 8:34]
Microsoft eases SQL administration
Talkback Do you have a link to this tool online. Any help greatly appreciated.
About: Microsoft eases SQL administration
[January 29, 2004, 19:27]
Is SQL a standard anymore?
Talkback Good article, still relevant 2 years after it was written.
About: Is SQL a standard anymore?
[December 8, 2004, 8:42]
RE: SQL injection attacks point to need for more secure software
Blog Comment This underlines the sheer stupidity in keeping copy's of customers details for any retailers, I mean the only organizations who should have these details should be the relevant banks to which your cards belong to and thats it.
[August 27, 2009, 1:52 by CA]
Ten reasons why you should upgrade to SQL Server 2005
Talkback In your point about enterprise scalability, it might be worthwhile to mention Service Broker, a new paradigm for building asychronous, distributed applications. Service Broker adds service orientation, asyc execution, reliable messaging and...
About: Ten reasons why you should upgrade to SQL Server 2005
[March 15, 2006, 0:24]
Ten reasons why you should upgrade to SQL Server 2005
Talkback TOP 5 Reasons NOT to UPGRADE to 2k5 MS Project Server not Compatible MS MOM not Compatible MS Share Point not Compatible MS Live Communication Sever not Compatible MS WSUS not Compatible Now I say "NOT Compatible" this is in regards to Microsoft's...
About: Ten reasons why you should upgrade to SQL Server 2005
[March 13, 2006, 13:30]
Protect your SQL Server database
Talkback Just a follow-up. I posted an update to the Free Encryption Toolkit referenced in the article at http://www.sqlservercentral.com/columnists/mcoles/sql2000dbatoolkitpart1.asp. The updated toolkit supports five encryption algorithms, secure key...
About: Protect your SQL Server database
[April 24, 2006, 3:50]
SQL basics: SELECT statement options
Talkback In a company hierachy, want to find higher number of sub-ordinates reporting to their immediate senior official.which select option have to be used?
About: SQL basics: SELECT statement options
[December 7, 2005, 8:07]
SQL Server and Visual Studio get updated
Talkback Wait and see is still where the smart money is. As is keeping your options open. History so far has proven that new Microsoft technologies come with big overhauls that can introduce domino effects all over the place should one wish to make full use...
About: SQL Server and Visual Studio get updated
[November 9, 2005, 20:58]
SugarCRM unveils Microsoft collaboration
Talkback ".we'll see how customers respond".mysqldump sugarCRM > sugardata.sql mysql vtigerCRM < sugardata.sql
About: SugarCRM unveils Microsoft collaboration
[February 15, 2006, 20:50]
Tuesday
Blog SQL Slammer hits the Net, triggers faults in Cisco routers, DNS falls off the edge of the world, ATMs clam up and servers break down. It gets worse: the code that's exploited might be in SQL Server 2000 -- which people know to patch, even if MS has...
[January 31, 2003, 16:40 in Rupert's Diary by Rupert Goodwins]
