SQL Server 2008 Diagnostic Information Queries (July 2012)
Here is the latest version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements to...
2012-07-03
1,363 reads
Blog Posts
SQL Server Auditing – Getting started
In my organization, one of my jobs is auditing our database environment. I’ve been tasked with this responsibility for several...
2012-07-03
1,863 reads
SQL Server Get Identity after Insert using SP
I thought I will share my experience how you can get identity value after insert using SQL Server. I have...
2012-07-03
631 reads
SSIS SCD vs MERGE Statement – Performance Comparison
I wouldn’t class myself as an expert in SSIS but I certainly know my way around but came across something...
2012-07-03
8,699 reads
Useful new DMV’s in SQL Server 2008 R2 SP1 and SQL Server 2012
Introduction
Microsoft SQL Server 2008 R2 and SP1 and SQL Server 2012 has a new set of DMVs that includes sys.dm_server_memory_dumps,...
2012-07-03
5,414 reads
Colorado Wildfires
More than a few people have asked how I’m doing with all the fires in Colorado, so I wanted to...
2012-07-02
984 reads
Comparing DirectQuery and ROLAP for real-time access
In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution...
2012-07-02
1,371 reads
Guest Post: SQL Server Installation Error by David Postlethwaite
A strange SQL installation error with even a stranger solution
This week I was installing SQL Server 2008 R2 Developer onto...
2012-07-02
1,014 reads
July Question: If you could pick your manager, what ideal qualities would he or she have?
I think all of us have had poor, good, and great managers at one time or another in our career....
2012-07-02
1,946 reads
Lost in Translation – Deprecated System Tables – syscacheobjects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-02
1,059 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