Catalog view or compatibility view?
G’day,
The recommended way to access SQL SERVER metadata is through the catalog views.
The challenge is to be able to distinguish...
2011-05-08
3,020 reads
Orlando 101 For SQLRally Attendees: Weather
The inaugural SQLRally in Orlando is less than a week away (May 11-13)! Maybe you're coming to Orlando for the...
2011-05-06
849 reads
RCSI/SI doesn't work with rows larger than 8046 bytes
During this week I have prepared a workshop about Locking & Blocking for one of
my customers. One big part of this...
2011-05-06
1,451 reads
SQLRally OverDrive Events!
So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented?...
2011-05-06
402 reads
My 2011 PASS Summit Submissions
I wasn’t sure that I would submit anything, but in the end I committed to a few events in Seattle...
2011-05-06
802 reads
The best IT job boards
There are three job boards that I use: Dice, Monster, and LinkedIn. I prefer Dice by far, since it has...
2011-05-06
1,297 reads
SQL University: Precedence Constraints
Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables...
2011-05-06
2,114 reads
Re-blog – April 29-May 5
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-06
567 reads
New Diagnostic Manager functionality
The latest version of Ideras’ SQL Diagnositc Manager offers some pretty nifty predictive analysis capability. Offering at present, a 12 hour forecast.
This gives...
2011-05-06
1,043 reads
Why you should ask your CTO to attend the User group meetings.
When we (Bill Wunder and me) started our user group, the first person we invited to sign up to our...
2011-05-06
1,861 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
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....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers