SQL Saturday #128 - Istanbul
The first SQL Saturday event in Turkey, on Mar 31, 2012 at the Microsoft office in Istanbul. Sign up and come for a free day of SQL Server training.
Index Statistics in SQL Server: Stairway to SQL Server Indexes Level 14
A look at the information that helps SQL Server make better decisions.
Waiting for SP1
This Friday Steve Jones wants to ask a poll about SQL Server 2012. Do you think it's ready for your production servers?
Steps to Drop an Orphan SQL Server User when it owns a Schema or Role
What do you do when you need to remove an orphaned user, but they are the owner of a Schema or Role on that database?
Adding a log shipping monitor
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
Was This Week A Good Week?
Today we have a guest editorial from Andy Warren as Steve is on vacation. Was this a good week for you? How do you know? Do you have a definition that helps you determine if it was a good week? Today Andy Warren talks about how we view our jobs.
Using The AlwaysOn Feature of SQL Server 2012
This is the first in a four-part series on the new AlwaysOn feature in SQL Server 2012. In this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn
An Azure Outage
Recently the Azure service had an outage and Steve Jones has a few comments on this and why it might not be worse than your own company's IT group.
Basics of XML and SQL Server, Part 2: Shredding XML
In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.
No Significant Fragmentation? Look Closer…
If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.
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