Recovering from out-of-disk space conditions for tempdb
Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...
2012-08-06
3,263 reads
Blog Posts
Rollback TRUNCATE TABLE statement
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,442 reads
SQL Audit 201 – Creating an Audit Solution
Welcome back, folks!
Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s...
2012-08-06 (first published: 2012-07-31)
6,739 reads
SQL Server - Oracle Architectural comparison
This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...
2012-08-06
4,649 reads
SQL Server : Lost all Administrator Account in SQL Server and Forgot sa Account Password
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
7,994 reads
SQL Server: How Recursive Common Table Expression (CTE) Works ?
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,294 reads
The first record on data page.
TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...
2012-08-06
1,211 reads
Time Flies When You're Having Fun (Déjà Vu Edition)
Writing - be it a technical language like T-SQL, C#, PowerShell, etc. or blogging - is like exercise. When you do it...
2012-08-06
1,535 reads
What's new in Reporting Services 2012 Free Webinar
We are starting our free monthly webinars with 'What's new in Reporting Services 2012' on Wednesday August 8, 2012 at 12...
2012-08-06
1,326 reads
Initialize a Transactional Replication from a Database Backup
During the last days I’m working on Replication – especially with Transactional Replication. The main idea of Transactional Replication is that...
2012-08-05
1,549 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers