Script to Get Available and Free Disk Space for SQL Server
Often we face the situation where we need to check the total disk space and available disk space for both physical and LUN/Mount drives. See how this can be done using PowerShell.
Devil's Advocate
With the one hand, Chris applauds the outstanding work of the SQL Server community, and tentatively raises the other to ask if we're on the cusp of a chance.
How to Name Sheets in Exported Excel Workbooks with SSRS 2008 R2
A new feature of SSRS 2008 R2 is the ability to name sheets in exported Excel workbooks. This article explains how to utilize this feature.
Virtual Security
As more and more companies move to virtualized servers, security should be on their minds. Steve Jones talks about that changes that you should consider.
SQL Saturday #93 - Toronto
Come get a free day of SQL Server training in Toronto on Sept 17, 2011 at SQL Saturday #93. The event takes place at Humber College in Toronto.
A Flock of SQL Servers
Do you want to integrate Twitter with your database server? Steve Jones asks the question this week.
SQL Server Restore Tutorial
What good is a backup if you do not know to restore the backup? In this tutorial you will look at what restore options are available and which options are only accessible using T-SQL commands.
PASS Data Architecture Virtual Chapter presents Data Warehouse Architecture
On Thursday August 18th, John Racer will discuss some common architects and practices for Data Warehouses.
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?