Troubleshooting SSRS subscription failures
Of-late one of our SSRS 2005 report subscriptions started to fail regularly with the error message
Failure sending mail: Timeout expired....
2011-01-07
3,036 reads
Blog Posts
Windows Experience on W510
I toyed with the idea of using the SSD for my main drive, but I’d really like to get the...
2011-01-07
1,062 reads
31 Days of SSIS – Recursive SSIS Package (6/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In the first post...
2011-01-06
2,561 reads
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
2011-01-06
2,406 reads
Denali is coming…..
SQL Server 11 (code-named “Denali”)
Heres the official MS speak:-
Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in...
2011-01-06
463 reads
Fun with a String
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that he had 2 tables. Table 1 has numeric key...
2011-01-06
7 reads
Fun with a String
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that...
2011-01-06
1,057 reads
Goals for 2011
Last week I wrote about my goals for last year and some frustration at having to make some trade offs...
2011-01-06
579 reads
PASSMN January Meeting Update
Thought I would drop a quick note on the January PASSMN meeting. We’re running a bit behind getting things ramped...
2011-01-06
483 reads
Rebuilding the W510 – DVD Driver Issues with x64
I backed up my machine, copied a bunch of data to both a thumb drive as well as the second...
2011-01-06
753 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers