Performance Monitoring with Dynamic Management Views
In this article, Ron Johnson shows how you can use DMVs for proactive real-time SQL Server performance monitoring.
2011-11-17
13,518 reads
Articles
2011-11-17 (first published: 2010-03-10)
8,016 reads
The DBA in Space Deadline is Extended
The deadline for entering the DBA in Space competition has been extended until Nov 22, 2011, noon GMT. Enter today and get the chance to fly into space or take the vacation of your dreams.
2011-11-17
1,794 reads
Webinar: PASS Data Architecture VC presents On Beyond Zebra AdventureWorks OR where did I go wrong?
On Thursday November 17th at 8PM Eastern, Steve Simon will discuss "No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
2011-11-17
1,229 reads
New PowerPivot Forum
We have a new forum setup for your Powerpivot questions. If you are working with Powerpivot, please feel free to ask questions here.
2011-11-16
1,895 reads
SQL Server Compressed Backups Disk Space Needs
SQL Server 2008 and later offers the ability to create compressed backup files. When creating the compressed backup, how much space is really needed and when does the space get allocated for the backup file?
2011-11-16
2,642 reads
The Final Question
Check out the final question for the DBA in Space contest. It's a math tease that needs research. If you can solve it, and you work with databases, enter the contest at dbainspace.com
2011-11-16
2,212 reads
Installing SQL Server 2008R2 on a Windows 2008R2 Core Server
This article will show you how to install SQL Server on to a Windows Core Server host.
2011-11-15
4,351 reads
2011-11-15 (first published: 2010-03-03)
9,852 reads
A Temporary Disagreement
Last month, Phil Factor caused a furore amongst some MVPs with an article that dared to suggest that for reasonably small-scale strategic uses, and with a bit of due care and testing, table variables are a "good thing". Not everyone shared his opinion.
2011-11-15
3,225 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCP Kramat Jaya Baru Tlp/WA 08216977701
Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar Baru, Kec. Johar Baru, Kota Jakarta...
BCA KCP City Center TLP/WA 08216977701
Kawasan Terpadu Pusat Kota, Gedung Perkantoran Tower One, Lantai Dasar, Jl. KH Mas Mansyur...
BCA KCP Menara Imperium TLP/WA 08216977701
Jl. H. R. Rasuna Said No.Kav. 01, Guntur, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers