Why I Love the SQL Server Community
As many of you are aware, a SQL Server security patch came out this week (MS12-070 - Vulnerability in SQL Server...
2012-10-11
1,013 reads
MS12-070 - Should I patch more than Reporting Services?
If you're dealing with a version of SQL Server greater than SQL Server 2000, at this point I'm going to...
2012-10-11
1,986 reads
SQL Server 2012 SP1 CTP4 Is Now Available !
Service packs are very critical and important. It is very important from product upgrade & bug fixing point of view.
Microsoft has...
2012-10-11
728 reads
Performance Tuning Presentation from October 2012 BRSSUG Meeting
Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night! I hope everyone...
2012-10-11
760 reads
DAX IsFiltered Function
The DAX IsFiltered function returns True when <columnName> is filtered directly and false if there is no direct filter on...
2012-10-11
2,038 reads
Grant Execute Permission on All Stored Procedures
Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...
2012-10-10
13,444 reads
Gain exclusive control of a database
Last night a client tried to ruin a script to enable Read_Committed_snapshot on a SQL database. There were so many...
2012-10-10
560 reads
SQL Server:Understanding The Page Free Space (PFS) Page
In my earlier post, we have discussed about GAM and SGAM Page and Data Page. In this postlet us discuss about...
2012-10-10
6,402 reads
X-XMLA: vii. Partition Management with XMLA
In the 7th article of this series, I will discuss how to manage your partitions with XMLA. We will be...
2012-10-10
642 reads
Lose #5 Before #sqlpass
Win Valuable Prizes!
Impress Your Friends!
This week we’re starting up a health and weight loss competition that I hereby dub #PASSGameOn,...
2012-10-10
976 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
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
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...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers