Taking a Sabbatical
Today we have a guest editorial from Andy Warren as Steve is on vacation. Today Andy discusses sabbaticals, and a change in his life.
Automated Script-generation with Powershell and SMO
Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.
Call That a Database? This is a Database.
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
How to join a local table to a remote table by way of a linked server
Distributed queries on linked servers are not the greatest idea from a performance standpoint, but they can be quite useful.
The Power of Hadoop
Hadoop is an open source framework for working with data, and one that Microsoft has adopted. Is it worth using in your environment? Steve Jones thinks you should investigate it.
Point in Time Recovery Using New Timeline Feature in SQL Server 2012
SQL Server backups are key to recovering from a disaster or some type of data failure, but the real magic happens when the backup is restored. In this tip we look at a new enhancment in SQL Server 2012 for point in time recovery using the new timeline feature.
SQL Saturday #109 - Silicon Valley
Come to a free day of training on Mar 3, 2012 in Mountain View, CA
SQL Saturday #123 - Western Cape
Come to a free day of SQL training on Mar 3 in Tyger Valle, Western Cape in South Africa.
A Break from Databases
A Friday poll that's a break from work, and should be a bit of fun. Today Steve Jones asks about movies, and what's been interesting from the last year.
Using SSIS to Maintain the File System
Integration Services is one of the more flexible tools available on the SQL Server platform. Jason Brimhall shows us a way to remove old files, either backups or flat files, after a configurable period of time.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers