Free SQL Server Learning Resources - Updated
Here is updated list of *free* invaluable SQL Server learning resources.
Unknown is an ocean.
You think I missed some important freely...
2012-12-06
3,302 reads
Ramukar LivingForSQLServer
- Interests: Spending time with my family, Reading SQL Server internals and tuning topics
LivingForSQLServer celebrates 2nd year anniversary today
It's been 2 years since I wrote my first blog post on SQLServerCentral ("What happens when a query is submitted").
No...
2012-12-05
1,448 reads
Next Chennai SQL Server UG Meet Is Scheduled
Chennai SQL Server user group meet is scheduled for Dec'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...
2012-12-05
1,590 reads
SQLOS Basics - Query and CPU
In this article We are going to understand the basics of SQLOS - CPU scheduling.
In high level:
1. When an user connects to SQL...
2012-12-03
6,327 reads
Interview questions for SQL Server Performance Tuning Specialists
If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.
I have...
2012-11-29
10,110 reads
One Interview question. Many Answers
Conducting technical interview is an art.
Most likely I would start a discussion with simple questions like "What is your favourite topic in SQL...
2012-11-27
3,501 reads
Time Pass With Transaction Log - Part 5 INSERT
In this article We are going to INSERT a record in a simple table and try reading Transaction log record.
Note:...
2012-11-27
4,511 reads
Time Pass With Transaction Log - Part 4 DDL
In this article, We are going to CREATE/ ALTER/ DROP a table and observe transaction log records created for those DDL statements.
Our...
2012-11-26
3,531 reads
Time Pass With Transaction Log - Part 3 fn_dblog
As part of this Transaction Log Internals series, In this article we are going to observe the use of fn_dblog and some of its important...
2012-11-19
17,902 reads
Time Pass With Transaction Log - Part 2 Basics
As part of this Transaction Log internal series, In this article We are going to revisit some basic properties of Transaction log.Though architecture, purpose...
2012-11-18 (first published: 2012-11-15)
3,384 reads
Blogs
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Forums
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers