Improve DBA Operation Productivity – Part Two
As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our...
2012-07-31
1,901 reads
SQLSaturday #171 Pittsburgh Prep Continues
Hey, did I mention that Pittsburgh is having a SQLSaturday this year?
Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...
2012-07-30
1,561 reads
#GetHawt – The Summer 2012 Edition
Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so...
2012-07-30
1,753 reads
August 2012 S3OLV Meeting
Well well well. It has certainly been a long time between announcements on the blog about meetings for the Las Vegas SQL Server Users Group. We have had to...
2012-07-30
11 reads
August 2012 S3OLV Meeting
Well well well. It has certainly been a long time between announcements on the blog about meetings for the Las...
2012-07-30
1,596 reads
Syncing your contacts
In the same vein as my blog post about Syncing your calendars, I wanted to post how to sync your contacts...
2012-07-30
1,982 reads
SQL Server Orphanage – Using sp_change_users_login to find and fix all orphaned SQL users
Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy...
2012-07-30
1,434 reads
Video Enable PowerPivot Add-in
This is one of our first PowerPivot video tutorials and this short 1 minute tutorial we show how to enable...
2012-07-30
1,630 reads
SQL Server : Dedicated Administrator Connections
Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...
2012-08-01 (first published: 2012-07-30)
3,754 reads
How to move master and resource system databases?
I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...
2012-07-29
6,884 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers