SQLRally 2012 Eval Scores
I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...
2012-06-25
645 reads
Blog Posts
Unable to activate a Windows 2003 VM on Hyper-V behind a proxy
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,736 reads
Excellent SSIS 2012 Upgrade Video
This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...
2012-06-24
1,312 reads
Using SQL Server 2012 FileTables
SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...
2012-06-24
13,775 reads
Inspirational Database Administration Requirements
Just as a society’s civilization is mostly nurtured by its culture, I believe that DBA work quality is mostly determined...
2012-06-23
932 reads
SQL Server 2012 Installation Guide
This article walks the user through installation of SQL Server 2012 on a Windows Server 2008 system using the SQL...
2012-06-23
215,131 reads
I don’t care and why that is good for my blog
I expressed in my About page that this blog is never meant to be a technical blog. But the pressure...
2012-06-22
823 reads
Indexed view deadlocking
Deadlocks can be a really tricky thing to track down the root cause of. There are lots of articles on...
2012-06-22 (first published: 2012-06-13)
3,830 reads
Is That Your Code? [Copyright Considerations]
Think about that last SQL statement that you wrote. Did you originally write it? Are you sure you wrote it? ...
2012-06-22
1,296 reads
Presenting at PASS Summit 2012
I am pleased to announce that I will be speaking at the PASS Summit again after a four-year “break”. I...
2012-06-22
524 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