Setting Up a Server Side Trace
Recently I wrote a short post on the default trace in SQL Server. You can read that here. In this...
2010-03-14
14,823 reads
Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
2010-03-14
1,705 reads
Document, Document, Document
A while back I blogged about using Checklists , but there's another task you want to incorporate into your workflow - documentation....
2010-03-13
1,205 reads
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...
2010-03-12
514 reads
Business needs vs dirty reads
I have worked in many industries, but most of my time has been in the publishing industry. For those not...
2010-03-12
293 reads
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...
2010-03-12
3,689 reads
SCSUG March Meeting Recap
The Monsoon
My trip to the meeting, short as it was, involved some of the worst driving conditions I've ever personally...
2010-03-12
394 reads
My Experience with a Virtual Assistant using TimeSvr
Predicting the future with bold certainty is not for the faint of heart. It’s a hard job. A few get...
2010-03-12
969 reads
Great Turnout for The Montreal XV's First Practice - Rugby XV de Montréal Première pratique
The Montreal XV Rugby Club (rejuvinating the Rugby Football Club name from the 1920s) first practice was the other night at Collège Marie...
2010-03-12
801 reads
Working for/with High Caliber Folks
Within a couple of days of each other, both Andy Leonard (@AndyLeonard) and Paul Randal (@PaulRandal) tweeted about possible job opportunities which would...
2010-03-12
1,860 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 Kantor BCA KCU CIREBON Telp:08218154398
WhatsApp:0821-8154-398 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111
Alamat Kantor BCA KCP Kalimalang Telp:08218154398
WhatsApp:0821-8154-398 Jl. Inspeksi Kav. PTB Blok A 2 No. 2 C-D, RT.1/RW.4, Pd. Klp.,...
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
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