Connection pooling and the DBA
Here’s a great article that I came across while on my cookie break. The demonstration is so simple and straightforward....
2013-11-27
1,165 reads
Identifying Columns to Create Index via T-SQL
To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL...
2013-11-27
1,472 reads
Wasted Space Per Database For Fill Factor: Quick Tip
As I keep looking for answers on Fill Factor... I keep finding interesting Metrics to look into. Looking my own...
2013-11-27
2,579 reads
HammerDB SQL Server Benchmarking Utility
Mike Fal
Everyone here knows how much I enjoy using the DVDstore database benchmarking utility to benchmark a SQL Server instance....
2013-11-26
1,792 reads
Disaster Recovery Planning
As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If...
2013-11-26
454 reads
SQL Server Data Tools (SSDT) – October 2013 update
Since my last post about the SSDT update for August, there have been two updates, each containing one fix:
The September...
2013-11-26
1,199 reads
SQL Cruise competition, and the winner is …
Earlier this month SQL Cruise, (an initiative created by Tim Ford (B|T)) and Dell Software announced a competition to win...
2013-11-26
733 reads
The World Needs More A/B Testing
Have you ever been told that it’s ok to fail? Did it ever feel like it was really ok to...
2013-11-26
486 reads
Review: The Year Without Pants
The Year Without Pants by Scott Berkun is about a former manager/now speaker and writer going to work for WordPress...
2013-11-26
497 reads
Setting your predicate arguments at run time Part: 2 MultiSelect
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...
2013-11-26
838 reads
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Forums
Having some performance issues with linked server query
When I run my query from DW, which uses a linked server, it times...
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers