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,373 reads
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,373 reads
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,289 reads
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,159 reads
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,351 reads
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,620 reads
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,225 reads
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,316 reads
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,380 reads
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,210 reads
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,818 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
Please help and thanks. Package:Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has...
Hello SSC! I hope you all had a happy and safe holiday! Apologies if...
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 OrdersIn2000 , ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2001 , ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh WHERE soh.OrderDate > '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;See possible answers