Performance Improvement: Understanding
This article will cover the core understanding of the performance conversation
2009-10-16
3,675 reads
Additional Articles
How to Backup and Restore a SQL Server FILESTREAM Enabled Database
Most SQL Server DBAs have questions about backing up and restoring FILESTREAM enabled databases. In this tip, we will take a look at the steps Database Administrators need to follow in order to perform a backup and restore of a FILESTREAM database.
2009-10-15
3,288 reads
Databases in the Cloud: Elysian Fields or Briar Patch?
The cornucopia of products for handling distributed data in the cloud includes everything from lightweight key-value stores to industrial-strength databases
2009-10-14
1,857 reads
Open DBDiff for SQL Server 2008
The DBDiff utility compares two databases and generates a script to synchronize the two databases. In this article, MAK illustrates the various uses of the Open Diff utility.
2009-10-14
4,061 reads
SQL Server Tempdb Usage and Bottlenecks tracked with Extended Events
How do I effectively find out if the Tempdb database is suffering from an allocation bottleneck? Should I create multiple TempDB files per core on this server to improve performance? How do I check this information programmatically?
2009-10-13
4,199 reads
Using new location-aware data types in SQL Server 2008
With SQL Server 2008, you will have new built-in support for location based data types and supporting geospatial features. Next you will learn how these new data types work.
2009-10-13
2,899 reads
Executing Stored Procedures and Functions From PHP in Windows
Discover how to call stored procedures and functions in MySQL from PHP using three database extensions: MySQL, MySQLi, and PDO.
2009-10-12
1,576 reads
Generating Database Objects Scripts in SQL Server 2005
SQL Server Management Studio provides a wizard to generate script out of a database. Learn how to automate the process to generate and store the database script.
2009-10-12
3,712 reads
Configure disaster recovery across SharePoint farms by using SQL Server log shipping
This article describes how to use Microsoft SQL Server 2005 or Microsoft SQL Server 2008 log shipping to create a disaster recovery farm in a geographically distributed data center for Microsoft Office SharePoint Server 2007 with Service Pack 2 (SP2). By using this configuration, you can provide a disaster recovery site that provides current search results when a failover occurs. The article assumes that you are familiar with the concepts and terms presented in Plan for availability (Office SharePoint Server).
2009-10-09
2,570 reads
SQL Server 2005 Index Best Practices
In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance. Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.
2009-10-09
6,894 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Telp BCA KCP Kemang Pratama Cs 0823-7497-7784
Wa:082374977784 Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blk AN, RT.004/RW.001, Bojong...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Alamat BCA KCP Modernland Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers