Raw Materials - The Low Bid
When a job is too simple to be done in-house, how far down the phylogenetic tree should you go?
10 Good Things About Reporting Services 2008 R2
The 10 things Microsoft got right about SQL Server Reporting Services 2008 R2 (a sister article shows 10 things which aren't quite so good)
Labor Day 2011
It's a holiday in the US today and Steve Jones provides a little entertainment for those people still at work.
Piracy and Agile
Do Agile IT projects have anything to learn from the organizational structures and laws used by pirates? Phil Factor is not convinced.
TSQL Challenge 64 - A Payroll calculation Challenge
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays
Using a SQL Server Alias for SSIS Package Configuration Database Connection String
In this tip we will walk through setting up the SQL Server Alias and using it with SQL Server package configuration in an SSIS package.
The Growth of Data Types
This week Steve Jones asks you what you think will make up the majority of your future databases? Will it be numerical data or will some other type come to dominate?
Configure SQL Server Database Mirroring Using SSMS
This tip outlines a test environment and then walks through the process of setting up Database Mirroring. This includes the configurations, backups, restores and verification process.
Recovery Models
Learn the basics of recovery models in this short article from SQL Server guru and MVP, Gail Shaw.
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers