My Favourites Of Paul Randal
As a new blogger, It is a little pain for me to blog on a technical topic.
It starts from learning, exprimenting, being comfortable with topic,...
2012-11-15
3,974 reads
Ramukar LivingForSQLServer
- Interests: Spending time with my family, Reading SQL Server internals and tuning topics
Time Pass With Transaction Log - Part 1
Hundreds of expert level books, articles, videos and blogs has talked much about Transaction Logs and How well to manage it.
Everything from basics...
2012-11-05
1,898 reads
Transaction Log Internals - My session ingredients
Still 18 days to go for my session on Transaction Log Internals for Chennai SQL Server User Group (17-Nov).
While seeing...
2012-10-30
2,603 reads
My Training Topics For Coming Months
Just few days gone since our last Chennai SQL Server User Group meet. This is the right time to choose...
2012-10-18
880 reads
CSSUG Oct2012 - My Session Presentations and Scripts Are Available Here
Chennai SQL Serve User Group Meet for Oct'2012 happend today at Microsoft Traning Centre located in Radhakrishnan Road, Chennai.
Its pleasure seeing enthusiastic...
2012-10-13
892 reads
Yet Another Facebook Page - Living For SQL Server
I have created facebook page named "Living For SQL Serever" couple of days back.
https://www.facebook.com/LivingForSqlServer
Inviting our community friends to like this...
2012-09-28
1,789 reads
Pearls in the Ocean – Part 1
In our day to day life with SQL Server, We refer web for many reasons.
This includes understanding new SQL...
2012-09-12
800 reads
My Session on Locking Internals Part 1 in CSSUG Meet
Bad weather won't stop hungry minds. Our today’s Chennai SQL Server User Group (CSSUG) meet happened with around 25 enthusiastic SQL Server...
2012-09-08
845 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,336 reads
Tempdb quick notes from Professional SQL Server 2008 internals and troubleshooting
I spent sometime to understand more about tempdb today. posting some key points for our quick reference.
some key books/links on...
2012-03-15
2,260 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Active and Active Cluster
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers