SQL Server (Sydney) Users Group meeting has been moved to Monday 6th November 2006 when Richard Lees will present “OLAP, what is it good for?” Richard will show the insides (and outsides) of an OLAP cube created to assist in monitoring and managing a 6 node Oracle RAC database that sustains 600 transactions per second […]
You are browsing archives for
Category: SQL Server / Microsoft SQL Server / MSSQL
SQL Server / Microsoft SQL Server / MSSQL
Moving a TFS V1.0 Sharepoint Site
Continuing on with [story:sqlserver2005-mirroring-tfs]. If you needed to make changes to your TFS Sharepoint deployment, v1.0 options are very limited. Microsoft do have a TechNote on configuring TFS to use a Remote SharePointServer. The good news is that the next version should have a lot more configuration options.
Team Foundation Server High Availability with SQL Server 2005 Mirroring
As Team Foundation Server (TFS) becomes the source code repository for more and more teams, SQL Server DBAs are ultimately responsible for the backup and availability of these databases. Sudhir Hasbe the Program Manager for Team Foundation Server has noted that SQL Server 2005 Mirroring will provide a warm standby but TFS will not automatically […]
Table Column Info or Sample Rows with a Single Key Press
Irena Kennedy has a neat trick for SQL Server Management Studio to quickly display some rows from a table, or get the metadata on columns of a table: a keyboard shortcut that is fast and works in any database. Has anyone else created similar keyboard shortcuts like this? Leave your comment here.
Inside DBCC CHECKDB… How does it work?
Paul Randal has been writing an excellent series on how DBCC CHECKDB works within SQL Server. Explaining how SQL Server 2000 and 2005 present a consistent view of the data for checking and why that is important. Paul moves onto what CHECKDB really does and then [story:sqlserver2005-dbcc-for-vldb]. Paul Randal worked as the Lead Developer / […]
Checking Database Consistency in Very Large Databases (VLDB)
Paul Randal who was previously the Lead Developer / Manager for a team working on the SQL Server Storage Engine, has written a short article on the challenges and some options for using DBCC CHECKDB in a VLDB. If you are looking after databases in the hundreds of GB or more than a TB, read […]
Visual Studio Team Edition for Database Professionals CTP6 Released
Today marks the release of CTP6 of Visual Studio Team Edition for Database Professionals. I’m pretty excited to see the development of this Visual Studio product. Finally database developers will be able to work like other programmers. Extreme Programming methods will be useful. Through Visual Studio projects and source control more developers will be able […]
Find a SQL Server 2005 MVP
Need an MVP? Or just want to verify someone’s status? Microsoft’s MVP Awardees search can help you out. Here’s the current list of SQL Server MVPs in Australia and the worldwide list. Not all MVPs are on there, quite a few choose to hide from the limelight. Not on there yet? (Me either). Become visible […]
Free SQL Scripts for Managing and Monitoring SQL Server 2005
I came across these scripts on the Microsoft TechNet Script Centre Microsoft SQL Server 2005 Buffer Cache Retrieve Buffer Counts by Object and Index CPU and Optimization Determine CPU Resources Required for Optimization Retrieve Parallel Statements With the Highest Worker Time Retrieve Statements with the Highest Plan Re-Use Counts Retrieve Statements with the Lowest Plan […]
How Common Are SQL Injection Vulnerabilities?
Michael Sutton has run a test to see how many websites have SQL injection issues and finds that 11% of the websites he tests are potentially vulnerable. The article is well written in that he discusses the methods used to select urls for testing, the change he uses to attempt a non-destructive SQL injection, and […]