Little Old Story
Several years back while I started working in a capacity of Jr. DBA, faced a question in walk-in interview. “Have you installed SQL Server on Linux?” without a moment delayed my answer was “Yes, many a time”. Didn’t realize my interview concluded with this “goofy” answer as REJECTED candidate. But that remained […]
Little Old Story
Hello Friends –
Back to you all with my second blog of year 2017 with Logshipping automation. This time picked up a little deviated topics like year 2016. Being a DBA background monitoring, configuring & managing high availability & disaster recovery solution were a day to day responsibility for me, like most of us have/had at […]
On behalf of DataPlatformGeeks taking an opportunity to share #DPS2017 (DataPlatform Summit 2017) launch on 28-Jan-2017 @ Bangalore in the presence of Shivir Chordia (Director, Microsoft Data Platform, India) & Deepak Rajendran (Community Program Manager, India).
This is the 3rd edition of Summit in consecutive years since 2015 and Asia’s largest Data Platform related […]
Back to you again with my all together new pick, Amazon Relation Database Service. Ah! interest, some of you might be wondering is this topic has nothing to do with SQL Server. Yes / NO ?
Working with RDS for few years and most of cases got to know from many of beginners or intermediate […]
In continuation to my previous blog about SQL Server 2016 newly introduced T-SQL Functions, putting down DATEDIFF_BIG another the new function. This function helps to find difference between two dates in the units specified by the DatePart parameter and the returned unit is of type bigint. This function like DATEDIFF function returns the number of […]
Back to you with one of my favourite feature introduced with SQL Server 2016.
Working over a decade with SQL Server in heterogeneous line businesses, heterogeneous market, unlike customers from geographic and supporting various timezones. At many occasions found messy myself while playing nicely with different timezones. Specially when day light saving switch is ON/OFF. Definitely […]
SQL Server Database Administration in my core expertise. During my journey from Jr. to Sr. DBA and so on experienced many situations where I preferred using the TRUNCATE TABLE statement against DELETE statement. Reason is simple speed, minimally logged and don’t unnecessarily eats my server resources. However, same statement made me (still does) nervous to get […]
I’m back to you with couple of new functions available in SQL Server 2016 version called “Compress” & “Decompress”. So far most of us are aware about PAGE LEVEL & ROW LEVEL compressions in SQL Server. However I have a had come to a situation, probably once of twice to look for something where […]
In continuation to my previous post, I’m going have chosen another function from SQL Server 2016 to put forward here.
New STRING_SPLIT() function in SQL Server 2016 to split a string into multiple values & rows. Function returns table from a string parameter
Type of Parameter : VARCHAR, NVARCHAR, CHAR and NCHAR
Count of parameters: 2 (Two) – […]
Getting back with you my new blog with DIE. Sound interesting & crazy at same time. Yes, SQL Server 2016 is getting to us with a new T-SQL clause DROP IF EXISTS, in short (DIE).
Traditionally we all, irrespective of holding developer, DBA or DEVOPS profile very much used to of IF EXISTS […]