PayPeriod Matching
Recently I was asked to alter a report to pull different more meaningful data. The particular report was pulling data...
2010-01-21
1,002 reads
Blog Posts
PowerShell Script for Creating Indexes
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...
2010-01-21
1,810 reads
Speaking at European PASS
I just heard that two of my presentations have been accepted for the European PASS Conference 2010 in Neuss, Germany,...
2010-01-21
688 reads
Speaking at SQL Saturday Tampa and Richmond
Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).I...
2010-01-21
581 reads
SQL Server 2008 - Top Reasons to Upgrade.....
OK, you've seen many of these before, but if you haven't figured out its TIME to upgrade your SQL Servers to...
2010-01-21
1,214 reads
SQL Server 2008 R2 - official date
Since the August 2009 when the CTP ( Community Technology Preview) version was available, the Microsoft announced the offical release date...
2010-01-21
444 reads
SQL Server 2008 R2 to be Available in May
This past Tuesday, Microsoft officially announced that SQL Server 2008 R2 will be available in May 2010. See the announcement...
2010-01-21
671 reads
SQLSaturday #32 – Tampa
Just a reminder that SQLSaturday #32 – Tampa is taking place this weekend (January 23rd). This will be my 5th SQLSaturday...
2010-01-21
337 reads
Using sp_ExecuteSql to Run Dynamic SQL
Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...
2010-01-21
635 reads
Can query performance be dependent on the client?
This question sounds really easy! The query performance depends essentially on the execution plan, which in its turn isn’t dependent...
2010-01-20
646 reads
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...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
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