SQL Server BI & SharePoint eBooks, Guides and Resources
There are many free eBooks & resources available from Microsoft and members of the MVP community. This is a collection of...
2012-08-10
1,367 reads
Working With Compliance
Most larger and all publicly held companies will have some sort of compliance team – often a few varieties, ranging from...
2012-08-09
578 reads
How to prevent ‘Select *’ : The elegant way
UPDATE 2012-09-12 For my latest adventures with TSQL Parsers please see this post.
I’ve been doing a lot of work with the...
2012-08-09
1,989 reads
August 2012 – Monthly SQL Server Checklist
Summer is beginning to wrap up for those of us in the northern hemisphere and were finally to August. Maybe...
2012-08-09
1,155 reads
Excluding Schemas in SQL Compare
I saw this question posted the other day and thought it was a great idea.
I haven’t been a big...
2012-08-09
2,436 reads
Service pack Native Client, SQL XML4 and VSSWriter failed
One of my client accidentally executed a 32 bit service pack on a 64 bit SQL Server, the service Pack...
2012-08-09
1,546 reads
Forcing network protocol to connect SQL server
Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different...
2012-08-09
1,245 reads
SQLSaturday 159 - KC Can Sure Throw a SQL Saturday!
This past weekend was SQLSaturday159 - Kansas City. I drove down with my wife and our sons (2 years old and...
2012-08-09
953 reads
Using a Dedicated Administrator Connection (DAC) on SQL Server
Dedicated Administrator Connection (DAC) allows administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command...
2012-08-09
1,501 reads
Don't Use Passwords That Can Be Social-Engineered
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current...
2012-08-09
1,950 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