SQL Server Instant File Initialization (PQW)
In this article we’re going to look at instant file initialization. What it is, why it’s cool and how you can use it in your environments.
TSQL Challenge 79 - Finding the Islands
The challenge is to find the Islands(gaps) in sequential dates. You need to write a query to identify continuous intervals from the start date and end date.
Init Replication From Backup
One of the great features with SQL Replication is the ability to initialize a subscription from backup instead of from a snapshot. The official use for this is to take a database backup and restore it to a subscriber then replicate any additional changes to the backup.
SQL Saturday #133 - Costa Rica
A free day of training in Costa Rica on Apr 14, 2012. If you are near San Jose, sign up today.
The SQL Saturday Australia Tour
Free days of training in Australia during the spring of 2012. Apr 12 in Brisbane, Apr 14 in Wellinton, Apr 19 in Canberra, Apr 21 in Sydney, Apr 24 in Adelaide, and Apr 28 in Perth.
Backup and Restore
Today's editorial was originally published on May 13, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about the need to train yourself, just like people in other professions.
How to create a database backup using visual studio
This article describes how to backup a database using a C# Windows Form.
World Backup Day
This Saturday is World Backup Day, and with this in mind, Red Gate's Brian Harris talks about SQL Backup 7 and why they want to make backup verification a focus for more DBAs.
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?