Physical File Defragmentation
A guest editorial by Brad McGehee talks about physical fragmentation and asks if you are concerned about it on your servers.
What is sysprocesses and what can it do for you?
This article presents a description of sysprocesses aimed at the newer DBAs. From new author Edward Elliot, he dives into what you can learn from this system view.
Script dimensions using Windows PowerShell and AMO
Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.
SQL Server 2005 Row Versioning-Based Transaction Isolation
Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications.
Mastering SQL Server Profiler - Introduction
This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master. In it, MVP Brad McGeHee will discuss some of the critical factors that might persuade you of the need to master this powerful SQL Server profiling tool.
Mistakes in April
Steve Jones has a blooper reel for today that shows some of the things that happen when shooting a daily podcast.
Networking Results
I've written quite a few posts lately on networking and a very common question is - where's the results? What do I get out of all the effort, and so far my best (if lame) answer is that networking is an investment based on faith that...
Peer-to-Peer Replication in SQL Server 2008 – Configure a two-node topology
The first installment of this series describes the steps to configure a two-node Peer-to-Peer replication topology.
Performing Hierarchical Restructuring Using ANSI SQL
Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.
Secure Storage
How do you keep the passwords and keys for encrypted data safe? Steve Jones comments on the challenges of working with keys and passwords.
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 KCU DARMO TLP/WA 083800209966
PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
BCA KCP Golden Trade Center Telpon/wa:0821°8168°291
BCA KCP Golden Trade Center Telpon/wa:0821°8168°291.Jl. Glugur Jl. Gatot Subroto No.11-12, Petisah Tengah, Kec....
hubungi ( CS ) call Center Garuda Indonesia
Call Center Garuda Indonesia (24Jam) Bisa Menghubungi Official Garuda Indonesia (0821-7007-002) Hubungi Melalui Telepon...
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