Setting up a SQL cluster under MS VS2005 R2 Part1
This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers.
Take Care of Yourself
There are many ways to invest in yourself and Steve Jones reminds us of one in today's editorial.
Cambridge SQL UG - SSIS and SSRS sponsored by Redgate
Come and join us for this great evening focusing on SQL Server Integration Services and Reporting Services in Cambridge, UK on Wed, May 20, 2009.
Rant: Is It an Effective Control or Not?
This is spurred on by a comment a pen tester made. He was referring to a particular technology and said something to the effect of, "What do you expect? It's 30 year-old technology." I was stunned when the comment was relayed to me. My response...
Report Design Tips and Tricks
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is frequently requested.
Swap column data due to inserting data into wrong columns for SQL Server table
This article is for newbies who have just started their career in SQL development. Everyone might have faced this problem when importing or inserting data into tables when they accidentally put the data in the wrong columns. The first thought would be to delete the data and start over, but in this tip we look at a simple solution to swap the data.
The Rights for Data
As we develop new applications and our computers gain new capabilities, what rights do our data include? Steve Jones explores a controversy with the Amazon Kindle.
The Rights for Data
As we develop new applications and our computers gain new capabilities, what rights do our data include? Steve Jones explores a controversy with the Amazon Kindle.
The Rights for Data
As we develop new applications and our computers gain new capabilities, what rights do our data include? Steve Jones explores a controversy with the Amazon Kindle.
Mastering SQL Server Profiler - Part 3: Getting Started
This, the third installment of the "Becoming a Profiler Master" online training course, shows how to start, stop and control Profiler and how to save the traces.
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...
ALAMAT BCA KCP Palmerah Tlp:08218154393
WA:08218154393 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
ALAMAT KONTAK BCA KCP Bintaro Tlp:08218154393
WA:08218154393 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...
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