2012-10-05
8 reads
2012-10-05
4 reads
2012-10-05
6 reads
Presenting “PowerShell: Automating SQL Stats Collection”
On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco...
2012-10-05
363 reads
Presenting “PowerShell: Automating SQL Stats Collection”
On 10th Oct 6.30 PM, I will be presenting “PowerShell: Automating SQL Stats Collection for Performance Tuning”@ at San Francisco...
2012-10-05
962 reads
Tale of detaching a database which was enabled for replication!
In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.
Almost all...
2012-10-04
1,295 reads
Parallel Data Warehouse (PDW) How-To: Using BACKUP and RESTORE DATABASE on PDW
Before we get to the backup and restore syntax, its worth noting that the Parallel Data Warehouse (PDW) appliance architecture offers...
2012-10-04
5,435 reads
SQL Server: Sending Email in HTML Table Format Using TSQL
As part of our DBA life , we have to configure many alert or statistical mails which gives an idea about...
2012-10-04
1,510 reads
SharePoint dependencies
Microsoft has made a big push the last few years to have all its end-user BI tools integrate with SharePoint,...
2012-10-04
701 reads
Master Data Services (MDS): Bug deleting an attribute
UPDATE on 11/28/2012: I had this same error when trying to delete a model. Fortunately, SQL Server 2012 SP1 has...
2012-10-04
1,416 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