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
483 reads
Blog Posts
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
8,991 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,126 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
747 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
814 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,113 reads
Interview with DBA Brian Kelley
Brian Kelley will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL.
Tell us a...
2011-03-10
936 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,034 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,725 reads
SQL Bitwise Operations
How many DB professionals have never had to deal with bitwise operations in SQL Server? Who has never had a single value in the database represent more than one...
2011-03-10
22 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers