Stop Storing Unencrypted Passwords!
I was called over today by a person doing application support to help troubleshoot a database connectivity issue. This isn't a...
2012-07-30 (first published: 2012-07-26)
2,746 reads
PASS Is Hiring Another Evangelist–Could It Be You?
Just about a year ago PASS hired Karla Landrum to fill the vacancy of the Community Evangelist and that marked...
2012-07-30 (first published: 2012-07-25)
999 reads
Sacramento SQL Saturday Here I Come
Packing for SQL Saturday #144 in Sacramento, CO. Dan Hess, one of the organizers, asked me last November at the...
2012-07-25
1,199 reads
Transact-SQL Script to Monitor Replication Status
Today, I’ve written the following T-SQL script which you can use to monitor the status of transactional replication and performance...
2012-07-25
7,038 reads
SSIS aggregate transformation
In this SSIS 2012 tutorial we will show you how to use data flow Aggregate Transformation and we will use...
2012-07-25
1,769 reads
Introducing PowerView with Excel 2013
In this blog post we show video that introduces PowerView with Excel 2013. You provide an overview of the tool...
2012-07-25
1,759 reads
Visual Studio 2012 does not support BI
In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does not...
2012-07-25
16,080 reads
DevConnections – Fall 2012
This fall is the DevConnections SQL Server Connections conference in Las Vegas again. It’s at the Bellagio, setting for one...
2012-07-25
1,710 reads
Why You Should Speak at SQLSaturday (Or Any Other Free Event)
I talk to people about career planning and professional development quite a bit. It’s common to find them wanting to...
2012-07-25
1,071 reads
Cross-Post: Set Milestones for Little Victories
This seemed appropriate to cross-post from Goal Keeping DBA given the editorial for today:
One of the first pieces of advice...
2012-07-25
1,095 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