DWH Workshop material
As announced in my DWH workshop in Munich, you can find here my
whole ETL solution. Thanks for attending my workshop...
2011-02-15
807 reads
More info on nested views causing performance problems
As if I needed any further convincing that nested views were bad....
The other day I had to write a particularly...
2011-02-15
1,196 reads
Are int joins faster than string joins?
This one comes up a lot on the forums, often as advice given…
“You should use integers for the key rather...
2011-02-15
5,540 reads
Presenting "Secrets Of SQL Server" Idera Webcast On Feb. 16
On Wednesday, Feb 16th, 3 PM Eastern I'm presenting a webcast for Idera's Secrets of SQL Server series. Presentation details...
2011-02-15
720 reads
UN-SQL Friday #003–Vendor Love
The love that dare not speak it’s name… Yes, love for vendors. <shudder> Oh, I mean I love my new...
2011-02-15
594 reads
SQL Saturday #60, Cleveland Speaker Evals
I just received 35 speaker evaluations from SQL Saturday #60 in Cleveland. It was a great event (although I had...
2011-02-15
1,019 reads
Recent AMD Processor News
AMD has released five new specific models in their Opteron 6100 series line. Of these, the one you should be...
2011-02-15
472 reads
February Update
I haven't written anything for a while and again, for the second month running I missed TSQL2usday. It's a shame...
2011-02-15
490 reads
Redgate’s Free SQL Search Tool
I have been using this tool for quite a while and just remembered that I haven’t written a blog about...
2011-02-15
2,144 reads
The DBA Ultimate Fitness Workout Plan
If you plan to stay on top of your DBA game then you have to workout regularly.
Those of you that...
2011-02-15
740 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