Transparent Data Encryption (TDE) SQL Server 2008
Transparent data encryption, otherwise known as TDE is one of the new features introduced in SQL Server 2008.
Finding the causes of poor performance in SQL Server, Part 2
In the first part of this series of articles, Gail showed how to find the procedures that contributed most to performance problems. In this final part, she shows how to use query statistics to pinpoint the queries that are causing the biggest problems, and then use the query execution plans to find out which operations are the root cause.
Installing Reporting Services on SQL Server 2005 Express Edition
Having completed our coverage of the Service Broker characteristics specific to SQL Server 2005 Express Edition, we now turn our attention to Reporting Services. In this article, we will present the initial setup process, leaving discussion of configuration, management, security, and usability for future installments.
Starting Conversations - Part 3
If you haven't already, start with Part 1 and Part 2. In Part 2 I mentioned that I have hired Don to coach me on networking, and this week I'll share some results from our first 1.5 hour session.
Mining for Experts
How do you determine who is an expert in a field? Or if they are willing to answer questions for others? A new system that should do just that intrigues Steve Jones.
Mining for Experts
How do you determine who is an expert in a field? Or if they are willing to answer questions for others? A new system that should do just that intrigues Steve Jones.
Mining for Experts
How do you determine who is an expert in a field? Or if they are willing to answer questions for others? A new system that should do just that intrigues Steve Jones.
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.
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 Kas Tlogosari No.Tlp.083179431643
Jl. Tlogosari Raya II No.28, Tlogosari Kulon, Kec. Pedurungan, Kota Semarang, Jawa Tengah 50196
BCA KCP Pintu Air Telp:08213111109
Jl. Pintu Air Raya No.36 Q, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat,...
BCA KCP Kranggan No.Tlp.083179431643
Jl. K.H. Wahid Hasyim No.7, Bangunharjo, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
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