Register for Sean’s Dallas precon!
On October 13, Dallas will hold our second ever Special Bi Edition of SQLSaturday Dallas - #SQLSat163 for you Twitter folk...
2012-09-14
1,088 reads
Book Review: SQL Server 2012 Integration Services Design Patterns
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly...
2012-09-14
2,789 reads
Surface Area Configuration tool available in SQL Server 2008 & onwards
Surface area configuration is a security measure that involves stopping or disabling unused components. Surface area configuration helps to improve security by...
2012-09-14
4,563 reads
Detecting and Removing Duplicate Indexes
Indexes are the solution to many performance problems, but with too many indexes on tables can hurt the performance of...
2012-09-14
1,823 reads
Something for the Weekend – SQL Server Links 14/09/12
It’s SFTW Time, I hope you’ve had a great week!
Make sure you don’t miss this weekly round-up of SQL Server Links,...
2012-09-14
1,533 reads
Two Hundred Up
I was working on my blog this last week when I realised I was approaching my 200th blog post on...
2012-09-14
750 reads
After Seven Years, Time for Something New
Earlier this month, I passed the seven year mark at Digineer. It was a weird feeling, since the last time...
2012-09-14
709 reads
Implementing a Data Warehouse with Microsoft SQL Server 2012 exam (70-463) – My Thoughts
Well I finally got around to completing the MCSA aspect of the SQL Server 2012 Certification and I’m pleased to...
2012-09-13
1,319 reads
Finding DDL Triggers
Triggers are the types of objects in SQL Server that are easy to lose track of. There isn’t an obvious...
2012-09-13
11,001 reads
You don’t want to miss this out,Serious SQLServer training – 24 Hours of PASS event !
Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all...
2012-09-13
742 reads
Blogs
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....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
Forums
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
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers