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.
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.
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.
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.
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.
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.
Jumping the Gun
How quickly should security issues be reported? Steve Jones isn't sure, but he talks a bit about what we might want to do.
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.
Configure Windows Firewall for SQL Server Remote Connections
This article describes the process of how to configure the Windows firewall for SQL Server
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.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Duri Raya. Tlp/wa:08218168235
Jl. Duri Utara No.37 B, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Metro Permata Telpon/wa:0821°8168°291
BCA KCP Metro Permata Telpon/wa:0821°8168°291.Kompleks, Jl. Komp. Metro Permata Jl. Raden Saleh No.1 Blok...
BCA KCP Senen. Tlp/wa:08218168235
Pusat Grosir Senen Jaya Blok A8-9, Lantai 2, RW.3, Senen, Kec. Senen, Kota Jakarta...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers