When was your last database backup?
Its pretty often that you have to sit down at a SQL Server and need sort out what the backup situation is. One of the first things that I...
2015-06-10
2 reads
Anthony Nocentino Blog
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training...
2015-05-16
617 reads
Immersed in SQL Server at SQLskills
Over the last two years I have had the pleasure of attending all three SQLskills Immersion Event classes. This training is second to none in its quality and intensity....
2015-05-16
1 reads
Moving SQL Server data between filegroups – Part 2 – The implementation
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups...
2015-05-06 (first published: 2015-04-28)
7,167 reads
Moving SQL Server data between filegroups – Part 2 – The implementation
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is the second of our...
2015-04-28
1 reads
Moving SQL Server data between filegroups – Part 1 – Database Structures
Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...
2015-04-21
2 reads
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 2 – Monitoring
AlwaysOn Availability Groups have made a big splash in the SQL world and are quickly becoming the HA and DR...
2015-04-13
1,118 reads
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 2 – Monitoring
AlwaysOn Availability Groups have made a big splash in the SQL world and are quickly becoming the HA and DR technology of choice for many SQL Server environments. Crucial...
2015-04-13
1 reads
Moving SQL Server data between filegroups – Part 1 – Database Structures
Why is moving data between filegroups hard?
As a consultant its common to walk into a customer site and find databases...
2015-04-09
804 reads
Designing for offloaded log backups in AlwaysOn Availability Groups – Part 1
AlwaysOn Availability Groups made their initial appearance in SQL 2012 and have generated a lot of buzz, HA and DR...
2015-04-06
959 reads
Blogs
A New Word: Querinous
By Steve Jones
querinous – adj. longing for a sense of certainty in a relationship; wishing there...
Master SQL Subqueries with This Free Course
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
Forums
MDX SSAS Calculated measure for last totals + turnovers
I have a measure with totals for specific dates with the LastNonEmpty aggregation, and...
display bytea image
I moved a table from MsSql to Postgresql that had a field defined as...
When trying to use a LocalDB, I get an error
I tried to find an appropriate forum to post the question. This one seems...
Question of the Day
SQL in an Azure VM Backup
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers