Browse by Tags

LiveDataScript: Scripting data from a database into insert statements

We've partnered with a company called Live Software Solutions on a number of projects recently and they've just decide to release a great tool we've been using on a number of projects as a free download. It allows you to generate a single script with insert statements from multiple sources...

Posted to Christian Bolton's SQL Server Blog (Weblog) by Christian on 07-30-2008
SSAS 2005 – Server side tracing starter kit

Analysis services 2005 (SSAS) added the ability to trace server side events and i have used this feature a number of times. To date i had always used the profiler gui to do the SSAS tracing but today i found myself needing to initiate and manage a trace with scripts. The good news is that it can be done...

Posted to Andrew Calvett (Weblog) by ACALVETT on 04-07-2008
SQL Server 2005 Bug Report

Saw this link to a SQL Server 2005 bug report on the Microsoft Connect site. I guess someone was having one of those days https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=253524&wa=wsignin1.0

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-21-2008
Indexing Strategies

I attended the Scottish SQL Server User Group meeting during the week and heard a presentation from Martin Bell on his favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have been involved in performance troubleshooting databases...

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-16-2008
Resources

Whitepapers & Webcasts SQL Server 2005 Waits and Queues Troubleshooting Performance Problems in SQL Server 2005 Whitepapers on SQLSkills.com SAP with SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability Top SQL Server 2005 Performance Issues for OLTP Applications...

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-15-2008
New Product: Server Alert

I’m pleased to announce a new application called Server Alert . The application is a small add-in for SQL Server Management Studio that shows a coloured bar at the side of all query windows. The coloured bar indicates which server the window is connected to. Different servers can be assigned different...

Posted to Danny's SQL Server and Internals Viewer Blog (Weblog) by Danny on 02-05-2008
Dual Database Monitor Tool

I was giving a database mirroring demo last week and needed a way to quickly demonstrate the automatic failover capabilities in SQL Server 2005. I was at a session at TechEd IT Forum last year run by Paul Randal and Kimberley Tripp and remebered seeing them use the Dual Database Monitor tool to simulate...

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-02-2008
DTS Support in SQL Server 2005

Had a call this morning from a SQL Server developer looking to run DTS packages on a SQL Server 2005 machine with Integration Services installed. The user's problem was that he could not edit or run the DTS package via Management Studio. There is a simple solution to this problem, which involves Installing...

Posted to Rob's SQL Blog (Weblog) by robcarrol on 02-02-2008
Data Data everywhere even when you think its gone

The biggest problem I have faced in IT over the last decade has been loss of data. I have had the problem at work where servers have crashed and lost data, more often than not due to failure of disks. I have also personally felt the pain in a hard disk losing its partition information, and frequently...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 08-12-2007
Add-ins for Management Studio

This is one of the popular requests, unfortunately its not going to be in Katmai. A number of people have done it through Redgate being the major guys. However I came across Seans post about his snapshot Addin ( I would love to see the code Sean) http://sqlblogcasts.com/blogs/seanprice/archive/2007/07...

Posted to SimonS Blog on SQL Server Stuff (Weblog) by simonsabin on 07-17-2007

Page 1 of 3 (25 items) 1 2 3 Next >