The Kimball Approach
The Kimball Approach
There are a lot of misconceptions about dimensional modeling and the Kimball approach to building a DW/BI system....
2012-04-08
58,686 reads
Calling Function / UDF using linked server
If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...
2012-04-08
3,032 reads
Why shrink sql server data file failed?
Today I need to shrink a big data file, I know shrink file is not a best practise, and it...
2012-04-07
2,416 reads
Clean SQL Server Cache
I lives alone, usually, I clean my small apartment at every weekend, wipe the table/firniture with cloth, clean the capet...
2012-04-06
26,981 reads
Designing Database Solutions for Microsoft SQL Server 2012 Beta exam (70-465 / 71-465) – My Thoughts
After sitting the Administering Microsoft SQL Server 2012 Databases Beta exam (71-462) on Monday, I was still a little disappointed...
2012-04-06
1,382 reads
Certification Exams: From the Other Side
Today I took the 70-464 beta exam today "Developing Microsoft SQL Server 2012 Databases" and after spending the last few...
2012-04-06
786 reads
SQL Server 2012: Installing on a Virtual Machine
Now that SQL Server 2012 RTM is out, I have an update to my blog post SQL Server 2012 (“Denali”): Installing...
2012-04-06
15,172 reads
April 2012 Speaking Events
This month I’ll be out and about quite a bit with speaking events. Thought I’d detail them quickly in case...
2012-04-06
970 reads
Slacking Off: Planes, Trains, and Automobiles
It’s finally Friday. Grab a cup of coffee, a breakfast pastry of choice, and take a break with some non-SQL...
2012-04-06
817 reads
Steady State vs Tempo
It’s helpful at work to understand things at work change from time to time and to consider the impact on you...
2012-04-06
1,008 reads
Blogs
Speeding Up Patching – Beyond Patch Delivery
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
Monday Monitor Tips: Query Recommendations
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Forums
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Making an Impression
Comments posted to this topic are about the item Making an Impression
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers