New SQL Server 2005 Technical Overview blogcasts from the States Demo 1-1 Using Object Explorer http://www.microsoft.com/winme/0509/25037/SQL-01_Demo1.asx Demo 2-1 Using Queries and Scripts http://www.microsoft.com/winme/0509/25037/SQL-01_Demo2-1.asx Demo 2-2 Using Solution Explorer http://www.microsoft.com/winme/0509/25037/SQL-01_Demo2-2.asx Demo 3-1 Securing SQL Server with the Surface Area Configuration tool http://www.microsoft.com/winme/0509/25037/SQL-01_Demo3-1.asx Demo 3-2 Using SAC.EXE to Export and Import Surface Area Configurations http://www.microsoft.com/winme/0509/25037/SQL-01_Demo3-2.asx Demo 4-1 Understanding User-Schema Separation http://www.microsoft.com/winme/0509/25037/SQL-01_Demo4.asx Demo 5-1 Using SQL Agent Proxies http://www.microsoft.com/winme/0509/25037/SQL-01_Demo5.asx Demo…
Redmondmag.com have published an article ‘Ten Useful Microsoft Blogs’ @ http://www.redmondmag.com/columns/article.asp?EditorialsID=1044 Guess who’s number 2? Also at number 10 is the UKs own Industry Insiders blog http://blogs.technet.com/industry%5Finsiders/. So as promised all of you who submitted articles are already gaining recognition. Alas only two articles have come form the database community. So come on, I know…
Three new SQL Server 2000 blogcasts out of Redmond: Demo 4-1 Configuring System Monitor http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-1.asxDemo 4-2 Monitoring SQL Server performance http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-2.asxDemo 4-3 Configuring alerts http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_4-3.asx
Here’s another blogcast in the SQL 2000 performance blogcast series out of the States – this time ‘Using SQL 2000 Profiler’. This one’s a bit long at 11mins 8secs. http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_3.asx
Another blogcast from the States covering performance tuning in SQL Server 2000, this one covers using index tuning wizard. 6 mins 47 secs http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_2.asx
Here’s a Blogcast, the third in a series of three from the US, looking at Performance tuning techniques with SQL 2000 ‘Managing indexes’ http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-3.asx
Here’s a Blogcast, second in a series of three from the US, looking at Performance tuning techniques with SQL 2000 ‘Analyzing an execution plan’ http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-2.asx
Here’s a Blogcast, one of a series of three from the US, looking at Performance tuning techniques with SQL 2000 http://www.microsoft.com/winme/0506/24231/TNT1-160_Demo_1-1.asx
Here is a 4min 8sec blogcast showing how to add a multicast transform to a SQL Server Integration Services package (the package created in the previous blogcast). A multicast transform can create two or more replica data flows from one original data flow.
Here is an 8min 13sec blogcast showing how to create a simple SQL Server Integration Services package. The package aggregates 2 million records from a raw data file and passes the resulting 64 aggregated rows into a table in tempdb.