TechEd: 80 minute video of Corruption Survival Techniques presentation
A great presentation from Paul Randal of SQL Skills from TechEd 2008. Definitely worth the time to watch.
Using SQL Server DMVs to Identify Missing Indexes
I can run the Database Tuning Advisor or examine the query plans, but is there any easier way to determine which indexes may be needed?
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
Getting Close to Physical - Database Weekly (Nov 8, 2008)
The performance of virtual machines is getting closer and closer to that of physical machines with better software like Hyper-V.
Combine BottomCount() with Other MDX Functions to Add Sophistication
Discover, through a hands-on practice exercise, a more sophisticated business use for the MDX BottomCount() function, in combination with the Generate(), Descendants(), Ancestor() and other functions we have explored within our series. Join BI Architect Bill Pearson in this, the second part, of an extended examination of the MDX BottomCount() function.
Simple way to export SQL Server data to Text Files
With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.
Just Keep Going and Going and Going
The upgrade treadmill might hit you in ways that you didn't expect.
Using the Aggregate Transform - SQL School Video
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
Are Your SQL Server Application Queries Wasting Memory
I am running an application that issues queries directly to the database from within its source code. I've noticed that the database server will get low on available memory and that CPU activity is higher than I'd like. What could be the problem?
Blogs
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers