Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,039 reads
The Surface Meta-App
Just a quick little blog post about one more app you’re going to want to track down for your Surface....
2012-12-12
958 reads
TSQL Tuesday #37 – Joins and Implicit Conversions
Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this...
2012-12-11
2,015 reads
SQL Server 2012 security: Changes for the newest version
Database infrastructure security is extremely crucial for any organization, which is why Microsoft has invested heavily in SQL Server security...
2012-12-11
1,188 reads
Does my SQL Server database use any Edition specific features?
Today, I received a phone call from a friend who is thinking to downgrade the database hosted in SQL Server...
2012-12-11
674 reads
Database Snapshots – A view of database at a specific point in time
Beginning with SQL Server 2005, Microsoft introduced a new feature called database snaphots, which gives DBAs a way of presenting...
2012-12-11
887 reads
Let’s Talk About Joins
T-SQL Tuesday #37 This month please join us in the TSQL blog party that happens on the second tuesday of the month. It is hosted this month by Sebastian Meine (@sqlity)....
2012-12-11
9 reads
Let’s Talk About Joins
T-SQL Tuesday #37
This month please join us in the TSQL blog party that happens on the second tuesday of the...
2012-12-17 (first published: 2012-12-11)
2,941 reads
Optimizing Your BI Semantic Model for Performance and Scale
Here’s my notes from the ‘Optimizing Your BI Semantic Model for Performance and Scale (BIA-402-M)’ session at PASS Summit, presented...
2012-12-11
3,023 reads
Can I use SSDT for the 2008 BI stack?
SQL Server Data Tools (SSDT) that was released with SQL Server 2012 obviously works with the BI stack (SSIS/SSAS/SSRS) for...
2012-12-11
2,422 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