Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
Bloated
What is going on with all this production data? Steve Jones talks about the need to manage data growth and is it really worth the resources.
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
Behind the Curtain
Commentary on the database related news of the past week. SQL Server 2008 Certification, deep inside SQL Server and the Library of Congress.
Historical Dollars
Tracking your salary over time might be a fun, or not so fun, endeavor for a DBA. However should anyone else know what your trend is? Steve Jones asks the question this week.
SQL Server 2005 Logins
Security was a major focus of SQL Server 2005 during its development, both in terms of making the product secure as well as enhancing the options. Security expert Brian Kelley brings us a look at how the paradigm of logins has changed and what you need to look for in SQL Server 2005.
Creating a Scorecard in PerformancePoint Server 2007 (PPS)
We are just getting started with PerformancePoint Server 2007 and trying to help our business users to develop their first scorecard. For those of you who are new to Office PerformancePoint Server 2007, PPS is a recent addition to the Microsoft Business Intelligence (BI) offering.
How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005
This article shows how to implement an automatic sliding window in a partitioned table on Microsoft SQL Server 2005.
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Introducing the Relational Embedding Retrieval Pattern: Storing and Querying Vector Embeddings in SQL Server
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers