there are 1000 reasons to celebrate
As many of you know, I created a facebook group named 'Living For SQL Server' couple of months back.
SQL Server...
2013-08-05
1,391 reads
Ramukar LivingForSQLServer
- Interests: Spending time with my family, Reading SQL Server internals and tuning topics
Special Recognition For Top Community Leaders In India
I got a special recognition from Microsoft, India as one of the top community leaders.
My sincere thanks to SQLServerCentral (my...
2013-06-19
1,317 reads
Few thoughts and updates
Few of my regular readers may have noticed I am not actively blogging @ SSC at frequent interval.
There is a reason behind...
2013-06-14
1,182 reads
Mar'2013 Chennai SQL Server UG Meet Is Scheduled
Chennai SQL Server user group meet is scheduled for Mar'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:00...
2013-03-11
1,370 reads
Chennai SQL Server User Group Looking For Sponsors
Chennai SQL Server Group (CSSUG), one of the most active UG in India planning to conduct major SQL Server event (Q2 this...
2013-03-08
1,646 reads
Feb'2013 Chennai SQL Server UG Meet Is Scheduled
Chennai SQL Server user group meet is scheduled for Feb'2013.
Venue: Microsoft Training Centre, Radhakrishnan Salai, Chennai
Landmark: Opposite to President hotel
Timing: 09:30...
2013-02-05
1,240 reads
Few thoughts
I would like to share few thoughts/updates with our SQL Server community.
1. While checking my SSC blog posts, i realised that my...
2013-01-21
1,340 reads
Free SQL Server Learning Resources - Jan'2013
Database Normalization (some useful links)
http://www.ischool.utexas.edu/~wyllys/DMPAMaterials/normstep.html
http://www.guru99.com/database-normalization.html
http://www.aliencoders.com/content/basics-normalization-examples
SQL Server Programming Fundamentals (some useful links)
http://www.blackwasp.co.uk/SQLProgrammingFundamentals.aspx
http://beginner-sql-tutorial.com/sql-select-statement.htm
SQL Server Database Administration
DBA Responsibilities
http://www.bradmcgehee.com/2011/12/the-day-to-day-tasks-of-the-average-dba/
DBA Best Practices
http://www.bradmcgehee.com/presentations/
Free eBooks (to...
2013-01-02
3,418 reads
SQLOS Basics - Chennai User Group Meet - Presentation File Download
Chennai SQL Server User Group (CSSUG) meet is happening tomorrow (15-Dec-2012) in Microsoft Training Centre, Chennai.
You can download presenation and demo scripts here
http://www.sqlservercentral.com/blogs-admin/blogs/livingforsqlserver/CSSUG_SQLOS_Basics_15Dec2012/SQLOS_CSSUG_Meet_15Dec2012.zip
Tomorrow, I...
2012-12-14
2,238 reads
46756e2057697468205061756c2052616e64616c
49206a75737420747765657465642062656c6f7720656d6f74696f6e616c206d65737361676520746f205061756c2052616e64616c20696e204865782e202020
224a4d5057465a50565142564d53424f45424d22202020
54686f7567687420686520776f756c642067657420746865206d65737361676520616e64207265706c79206d6520696e203135206d696e757465732e202020
4775657373206865207761732076657279206275737920617420746861742074696d652e2048652067617665207570206166746572203220636c75657320616e642032
20617474656d7074732e202020
4861707079207468617420492073706f696c6564206869732076616c7561626c652035206d696e75746573203a2d29202020
4465616c20686572652069732068652068617320746f2066696e642074686520616e73776572206f6620686973206f776e206f7220656c7365
2068652068617320746f202020
6368616e676520686973206f70696e696f6e20616e6420737570706f727420746865206e656564206f6620646f63756d656e74696e67
20616e61746f6d6f79206f6620742d6c6f67202020
7265636f7264732e202020
497420746f6f6b206d6f7265207468616e20313020686f757273206a75737420746f20756e6465727374616e64
206c6974746c6520626974206f662073696d706c6520494e53455354202020
6c6f67207265636f72642e20202020
687474703a2f2f7777772e73716c73657276657263656e7472616c2e636f6d2f626c6f67732f6c6976696e67666f7273716c7365727665722f3230313
22f31312f32372f74696d652d706173732d776974682d7472616e73616374696f6e2d6c6f672d706172742d352d696e736572742f202020
5468696e6b2069747320696d706f737369626c6520746f20646f63756d656e7420616e61746f6d79206f6620616c6c207479706573206f66
20742d6c6f67207265636f7264732e202020
4275742069742063616e20626520646f6e6520746f20736f6d6520657874656e642e202020
496620796f75206172652072656164696e6720746869732c20646f6e7420666f7267657420746f20636f6d6d656e7420796f7572206e616d6520696e
204865782e1f1f
706c6561736520646f6e27742074616b65207468697320736572696f75736c792e204a75737420612066756e20617474656d70742e202020
2012-12-07
1,838 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers