Table-Valued parameters in SQL Server 2008
Introduction
The
most awaited feature has arrived - "Table-Valued parameters in SQL Server
2008". Here, I would discuss on how to use this new...
2011-03-12
4,533 reads
A Small Collection of SQL Azure Queries
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-11
2,578 reads
My Heart Goes Out to Japan's Earthquake/Tsunami Victims, And I Pray for Rain in Kesennuma Tonight as the City Burns....
Already hit by yesterday's Tsunami, the fires have taken over the main center of town in Kesennuma, Miyagi, where I...
2011-03-11
1,132 reads
Monitoring Database Infrastructure and Performance with Systems Center Operations Manager (SCOM), and Oracle Instance Monitoring, Plus Visio Plug-In
SCOM Does the core job of monitoring SQL Server instances very well (Health Monitoring) – but it is not going to...
2011-03-11
9,000 reads
Poll: – Index Rebuild / Defrag, what page count filter do you set?
After reviewing a number of clients overnight index defrag / rebuild scripts over the years, I’m intrigued to know how many...
2011-03-11
753 reads
MagicPASS March 2011 Meeting Notice
If you're in the central Florida area you're invited to the March meeting of MagicPASS, South Orlando's SQL Server User...
2011-03-11
493 reads
Do You Enable “Lock Pages in Memory”?
Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not...
2011-03-10
3,116 reads
Interview with SQL Server MVP Joe Webb
Joe Webb will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL.
Tell us a...
2011-03-10
1,035 reads
Attending SQLskills Immersion Event on Performance Tuning Next Week
After attending the SQLskills Immersion Event on Internals and Performance in Dallas two weeks ago, I am fortunate enough to...
2011-03-10
818 reads
MCM – The Knowledge Exam
I recently took the knowledge exam, and I loved it. I thought it was a great exam. I have taken...
2011-03-10
1,727 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers