XML Schema validation in SQL Server
An introduction to the XML Schema Collection and XML validation.
Call for participants in deployment process research
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.
Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS
The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.
SQL Server 2014 In-Memory OLTP Dynamic Management Views
Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.
Doing What It Takes To Get The Job Done
It can be a point of pride in technology that we work ourselves to get the job done. Is that a good thing? Andy Warren has a few thoughts.
SQL Monitor Custom Metric: Table size (MB)
This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes. If a database is growing quickly within a short time and you suspect a certain table is responsible, you can monitor its actual size, or the rate at which it is increasing.
SQL Server Backup Crib Sheet
Robyn Page's crib sheet was a Simple-Talk classic, providing a terse but thorough roadmap of all of the important SQL Server backup-related considerations. It returns, newly revised for SQL Server 2014.
Big Data - Cost of acquiring skills
If your companies first foray into Big Data project starts with a big cheque then you are doing it wrong!
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