SQL Server Soldier :: News from the frontlines of the database wars

T-SQL Tuesday #88: My Top WTF Moments

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

Welcome to T-SQL Tuesday #88 being hosted this month by Kennie Nybo Pontoppidan (blog|@KennieNP). This month’s topic is the “daily...

2017-03-14

564 reads

2016/2017 Whitepaper Updates

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

One of the problems with whitepapers is that they get out of date pretty quickly. It’s important to update them...

2017-03-13

503 reads

The Costs of Hiring Cheaper Consultants

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

From time to time, I see posts in forums from people complaining about how much some consultants charge. A really...

2017-02-17

568 reads

T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems...

2017-02-14

660 reads

Warning: Not a valid checkpoint file name

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

One of the other DBAs I work with noticed a warning message that was flooding the log files on one...

2017-01-30

1,563 reads

Finding Automatic Soft-NUMA

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL...

2017-01-04 (first published: 2016-12-30)

2,174 reads

T-SQL Tuesday #85 Part Deux: Backup Myth Restoring Differential Backups

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....

2016-12-13

705 reads

T-SQL Tuesday #85: Backup Log With NoRecovery

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

Welcome to T-SQL Tuesday #85 being hosted this month by Kenneth Fisher (blog|@SQLStudent144). This month’s topic is “Backup and Recovery”....

2016-12-13

757 reads

T-SQL Tuesday #83: Resource Governor CAP_CPU_PERCENT: It just runs faster?

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

Welcome to T-SQL Tuesday #83 being hosted this month by Andy Mallon (blog|@AMTwo). This month’s topic is “We’re still dealing...

2016-10-11

690 reads

T-SQL Tuesday #81 – Migrating Databases with Dell LiteSpeed

• by Robert Davis

• SQL Server Soldier :: News from the frontlines of the database wars

It’s time for T-SQL Tuesday again, and this month’s host is fellow Certified Master and Data Platform MVP Jason Brimhall...

2016-08-09

642 reads