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,196 reads
Blog Posts
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,530 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,323 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 you...
2012-08-05
8,941 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,541 reads
SQL Server : List Login's Database and Server Level Role Permission
In my last post, we have discussed about the orphaned users and fixing the orphaned users. The next step in...
2012-08-05
10,516 reads
SQL Server 2008 Diagnostic Information Queries (August 2012)
Here is the August 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-08-05
1,091 reads
Chennai SQL Server User Group (CSSUG) meet
Let me start with my sincere apologies first for not blogging consistently.
Primary reason is, my wife gave birth to our...
2012-08-04
1,346 reads
Getting to the next level in your SQL Server career
Jen McCown (Blog | Twitter) wrote about an interesting topic on the different levels of database professionals. In her article, Jen...
2012-08-04
1,282 reads
Protect Against SQL Injection Using Triggers
Before I became a SQL Server DBA, I used to be a web developer in ASP3. Since then, I sometimes...
2012-08-04
624 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers