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,314 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,461 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,597 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,360 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,136 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,517 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,525 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,543 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
18,018 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-16 (first published: 2012-11-15)
3,399 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Fulltext filter daemon host (FDHost) process has stopped abnormally
We have performed a side-by-side upgrade, from SQL Server 2016 to 2022 Developer Edition,...
Automating OSM Data Refresh in Power BI’s Azure Maps Reference Layer
Comments posted to this topic are about the item Automating OSM Data Refresh in...
Database Mail Configuration
Comments posted to this topic are about the item Database Mail Configuration
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers