Today we have a guest editorial from Grant Fritchey. The Boy Scouts motto is "be prepared" and most of you probably unconsciously follow that in your daily lives. Why is it that so many of us don't follow through on this same advice with our databases? Grant Fritchey gives a few examples of how you should "be prepared" for a database emergency.
In this article, we are going to focus on writing or refactoring the data access codes using the best practices. But, before we start playing the game, we need to prepare the ground first. So let’s do the groundwork at this very next step:
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
The first day of 2010 has Steve Jones blooper reel in addition to some well wishes.
I have often needed a means to send zipped files via email. This article shows one method to do just this.
The first day of 2010 has Steve Jones blooper reel in addition to some well wishes.
The first day of 2010 has Steve Jones blooper reel in addition to some well wishes.
In his continuing quest to bring a deeper understanding of Query Optimizer to the world at large, Fabiano Amorim takes a moment to point out a potential pitfall you may encounter. A light read, but one worth persuing.
The end of another year has an early Friday poll this week from Steve Jones. What are you looking to do in 2010?
My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Is Fabric a Reliable Service...
hi , a new user wants to be able to add sql agent jobs...
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