The Weekly News for Oct 6, 2008 (Database Weekly)
Steve Jones looks back at some of the news from the week ending Oct 6, 2008.
2008-10-04
724 reads
Articles
Let the Excel Play
This article describes how you can use excel to pull the data from the SQL Server and use it for report generating.
2008-10-03
13,076 reads
Data Access Tracing
Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine. You can also download associated sample code for this article.
2008-10-03
2,854 reads
MS Access Can Handle Millisecond Time Values--Really
MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several user-defined functions.
2008-10-03
2,319 reads
Creating a Database Diagram in SSMS - SQL School Video
In this SQL School video, Brian Knight shows you how to create and use database diagrams in Management Studio.
2008-10-02
5,305 reads
Monitoring Changes in Your Database Using DDL Triggers
Auditing and monitoring activity in your databases is becoming more and more important all the time. New author David Dye brings us a short introduction to using DDL triggers to help.
2008-10-02
11,450 reads
Configure Windows Firewall for SQL Server Remote Connections
This article describes the process of how to configure the Windows firewall for SQL Server
2008-10-02
2,670 reads
Speed or Value?
Everyone wants extreme performance from their systems, but is that always the way to look at things? This Friday Steve Jones asks about how you consider performance in your purchasing decisions.
2008-10-02
61 reads
Speed or Value?
Everyone wants extreme performance from their systems, but is that always the way to look at things? This Friday Steve Jones asks about how you consider performance in your purchasing decisions.
2008-10-02
74 reads
Speed or Value?
Everyone wants extreme performance from their systems, but is that always the way to look at things? This Friday Steve Jones asks about how you consider performance in your purchasing decisions.
2008-10-02
66 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
You Have Homework
Comments posted to this topic are about the item You Have Homework
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers