2012-01-29
12 reads
Blog Posts
2012-01-29
9 reads
Find failed SQL jobs with powershell
This weekend I went to SQL Saturday in Auckland. It was nice to interact with other DBAs again. Kent Chenery...
2012-01-29
11,994 reads
Find Login in Active Directory
Find Login in AD
Many times we require to know if particular login is a part of ad user group. Or...
2012-01-29
861 reads
Rebuild System Databases
Yesterday night one of FB Friend have ping me, he has issue with his local SQL Server instance. Our conversation...
2012-01-29
3,387 reads
Creating merge replication conflict alerts
One of the challenges in working with Merge Replication is handling conflicts since writes can occur at any node in...
2012-01-28
1,529 reads
January #Meme15 Round-Up
The second round of #meme15 finished up last week and it’s time to see who participated. In total, there were...
2012-01-28
796 reads
Petitions on Change.org and Thoughts on Changing PASS
I tried this out – Change.org that is – recently as part of a post about PASS and wanted to post a...
2012-01-28
791 reads
Blogging: Building a Blog
I took an interest in building a blog/website several years ago when I first started my company and working for...
2012-01-27
749 reads
Deadlock Monitoring
There are four different ways you can get information about deadlocks in your system. These are:
traceflag 1204traceflag 1222trace eventsextended eventsFor...
2012-01-27 (first published: 2012-01-23)
3,082 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 Bank BCA KCU MALANG Telp:08218154393
WA:08218154393 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur 65111
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
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