2015-07-24
18 reads
Professional Development – Set the Bar High
Originally appearing at ForITPros.com. Henry Ford is reported to have once said, “Whether you think you can or think you can’t – you’re right.” That’s great insight. Too often...
2015-07-23
27 reads
DBTA – Does the Looming Shortage in DBAs Spell Opportunity?
Originally appearing in my monthly column at Database Trends & Applications magazine. In my last column, available HERE, I described some of the findings contained in an intriguing new...
2015-07-22
31 reads
Implementing Partial Backups and Restores (via Leveraging Partitions)
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked...
2015-07-06
26 reads
Implementing Partial Backups and Restores (via Leveraging Partitions)
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked...
2015-07-06
27 reads
Implementing Partial Backups and Restores (via Leveraging Partitions)
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked...
2015-07-06
24 reads
Rebuilding Existing Partitioned Tables to a New Partition Scheme
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 4. The partitioning includes several major components of work (and can be linked...
2015-06-09
25 reads
Rebuilding Existing Partitioned Tables to a New Partition Scheme
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 4. The partitioning includes several major components of work (and can be linked...
2015-06-09
30 reads
Rebuilding Existing Partitioned Tables to a New Partition Scheme
[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 4. The partitioning includes several major components of work (and can be linked...
2015-06-09
22 reads
2015-05-13
26 reads
Blogs
The New Unified Copilot in Fabric and Project Osmos: From AI Assistance to Agentic Data Engineering
By James Serra
(This post starts a three-part series on how AI is changing the way we...
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers