SQL Server – sys.master_files and list all database files
Use the system view “sys.master_files” for a single view of databases and database files.
Instead of using sys.sysfiles joing to sys.sysdatabases...
2012-03-07
1,457 reads
Blog Posts
SQL Server 2012 (“Denali”): Reporting Services in SharePoint integrated mode
In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took...
2012-03-07
4,513 reads
SQL Server 2012 Data Mining add-in for Excel 2010 Released
Another release that went without much trumpeting was the SQL Server 2012
Data Mining add-in for Excel 2010. This has...
2012-03-07
1,684 reads
SQL Server Database Mirroring (Not Dead Yet)
SQL Server Database Mirroring is a high availability and disaster recovery feature that was added to the product with SQL...
2012-03-07
3,104 reads
2012-03-07
7 reads
Windows Server 8 Hyper-V Lab boot from VHD
Windows Server 8 Beta is out, check this video to use existing windows laptop/desktop to build VHD bootable Windows server...
2012-03-07
959 reads
2012-03-07
8 reads
2012-03-07
10 reads
2012-03-07
22 reads
Choosing the Right Microsoft Reporting Technology Part 2: Excel
This post is a continuation of a series started to help you understand each of the Microsoft presentation layer tools...
2012-03-06
2,000 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers