save disk when doing backup
As a DBA, most of us will also take care of test environment. However test servers usually cannot afford to...
2007-11-11
387 reads
Blog Posts
bcp Utility
There was a time that I avoided bcp utility like the plague. A few years ago, we needed to set...
2007-11-09
636 reads
Celko on SQL Seminar Orlando - It's Time!
We (End to End Training) will be hosting our Celko on SQL seminar tomorrow (Nov 9th). It's not too late...
2007-11-07
689 reads
Does User Voting for Best Products Work?
I happened to get an email asking me to vote for a product that was being featured in one of...
2007-11-07
659 reads
Tools: Apex SQL Log, Apex SQL Log API, Sample Corrupted Databases
Apex SQL has announced a new version of Apex SQL Log as well as an API for it.
Release Notes...
2007-11-07
790 reads
SQL Server: Showing permissions for a given database user
Building upon my post from last Tuesday, if you know all the roles for a given user, you'll probably want...
2007-11-06
611 reads
Becoming a DBA, Part II
This is a follow-up to part I from last week. You've considered what you want to do, you've looked at...
2007-11-05
918 reads
Replicate Stored Procedure Execution Published on SSC
Most people 'set it and forget it' when it comes to replication, not realizing that changes to rows on the...
2007-11-05
412 reads
SQL Server Magazine Changes
I was just reading the October 2007 issue and they have done what magazines are apt to do; redesign themselves...
2007-11-05
603 reads
Technical Debt/Steve McConnell is the man!
Steve is the guy who wrote Code Complete (get rev 2 if you buy) which I consider to be required...
2007-11-05
484 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers