Data Mining Introduction Part 8: Microsoft Sequence Cluster
This is an introduction to the SQL Server Microsoft Sequence Cluster Algorithm.
Mongo Jumbo Backups
Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.
New Cartoons at SQLServerCentral
SQLServerCentral has commissioned a new cartoon that will be coming later this week.
Five Tips to Get Your Organisation Releasing Software Frequently
The frequency of releasing software varies widely in the industry. If the test and release process is made as reliable and predictable as possible, then everyone gains. But how do you get started?
Adding to SQL Server
This week Steve Jones wonders what you might want to add to SQL Server. With SQL Server 2016 likely in the early planning stages, where would you want to see the development effort focused.
Database Mirroring Setup
This great tutorial shows how to set up database mirroring across two instances in a virtual environment.
Reduce Time for SQL Server Index Rebuilds and Update Statistics
This tip will explore two features to speed up SQL Server index and statistics maintenance in the SQL Server Enterprise, Standard and Express editions.
Finding “Active” Rows for the Previous Month (SQL Spackle)
SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.
Backup to the right location, by default
How do you configure where your database backups are created? Do you have problems updating all of your backup jobs if the backup location needs to change? See how you can make use of Windows settings and a few lines of simple TSQL to have total control over where you database backups are created.
SQL Saturday #273 Tampa. FL
SQL Saturday is coming to Tampa, Florida on February 22, 2014. SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This is a free event, so register early to secure your place.
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers