SQL Server virtualization pros and cons
Virtualizing SQL Server has pros and cons. Learn the performance impacts of virtualization on SQL Server I/O, RAM and memory to decide if it is a fit for your SQL Server system.
2008-12-15
4,829 reads
Additional Articles
SQLSaturday #10 - Tampa 2009
Looking for free SQL Server training?
Join over 250 SQL Server professionals in Tampa on January 24th, 2009 for SQL Saturday #10. Featuring 6 tracks and more than 36 SQL Server presentations, it's the biggest and best free SQL event available. Visit www.sqlsaturday.com to see event details and to register.
2008-12-15
1,196 reads
Discover Analysis Service's Properties using Windows PowerShell and AMO
Part 2 of this series illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.
2008-12-12
2,235 reads
Using SQL Server meta data to list tables that make up views
One of the issues I often face is the need to find views that are already established for certain tables. This maybe for other developers, end users or even for myself. I could search the system tables to find this or explore each view, but are there other ways to easily find a list of all tables that are used for a view or even a list of all views that a table is tied to?
2008-12-12
3,940 reads
Analyze and Fix Index Fragmentation in SQL Server 2008
This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation
2008-12-11
2,876 reads
Determine Object Dependencies Before Changing Your SQL Server Schema Design
Maintaining a database often means schema changes. Before you change or delete anything, be sure to check for dependent objects.
2008-12-11
2,638 reads
Configuring storage in DB with more writes than reads
Learn how to configure SQL Server database storage with higher disk writes than disk reads. Set up a RAID 10 array, cache configuration and file disk layout.
2008-12-10
3,222 reads
Data Types in SQL Server 2008
Don Schlichting compares and contrasts the various SQL Server 2008 Data Types. In addition, he explores which Data Types are the best solutions for specific situations.
2008-12-10
4,663 reads
Scheduling Jobs in SQL Server Express - Part 2
In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself.
2008-12-09
2,872 reads
Script to build a SQL Server Data Dictionary and report with Microsoft Excel
There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?
2008-12-09
4,930 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Nginden Semolo No.Telp:087757645171
Whatsapp:087757645171 Jl. Nginden Semolo Jl. Semolowaru No.101 18, RW.19, Menur Pumpungan, Sukolilo, Surabaya, East...
BCA KCP Kas Mega Bekasi Hypermall No.Tlp.083179431643
J Mega Bekasi Hypermall UG – Teras Garuda, Jl. Ahmad Yani, RT.004/RW.001, Marga Jaya,...
BCA KCU DENPASAR No tlpon:083138717148
Whatsapp:083138717148.Jl. Hasanuddin No.58, Pemecutan, Kec. Denpasar Bar., Kota Denpasar, Bali 80119
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers