Log in | Register

Prince Rastogi, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Prince Rastogi, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

PrinceRastogi

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

Prince Rastogi

About Prince Rastogi

Prince Rastogi is working as Principle Database Administrator at Admiral Technologies. Prince started his career working on SQL Server since Yukon. Prince is having almost 7 years of experience and worked in ERP Domain, Wealth Management Domain. Currently he is working in Insurance domain. In the starting of his career he was working on SQL Server, Internet Information Server and Visual Source Safe. He is post graduate in Computer Science. Prince is ITIL certified professional. Prince likes to explore technical things for Database World and Writing Blogs. He is Technical Editor at SQLServerGeeks.com.

SQL Sever 2017 – Smart Transaction Log Backup

Hello Friends,

SQL Server 2017 CTP 2.1 has been announced with some new features, one of them is Smart transaction log Backup i.e. exposing the log in mb since last log backup. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post […]

SQL Server – ROW_NUMBER versus TOP N

Hello Friends,

This blog post is the result of question asked by some professionals working on databases. While writing T-SQL code they generally use TOP N in the code to get the top n number of rows in the result set. They knew the another way to achieve the same result by using ROW_NUMBER. Now the […]

SQL Server 2017 – Smart Differential Backup

Hello Friends,

SQL Server 2017 CTP announced with lots of new features to help database professionals. One of that feature is Smart Differential Backup i.e. exposing the modified extent page counts. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post we […]

SQL Server 2017 – SELECT INTO on FileGroup

Microsoft has announced SQL Server 2017 CTP version with lots of new features and improvements as compare to previous version i.e. SQL Server 2016. You can download the SQL Server 2017 in the fastest way as explained by Avanish in his recent post. In this blog post we will learn about the new feature […]

SQL Server 2016 – USE HINT without having SA permission

Hello Friends,

Trace Flags are really important considerations in SQL Server where we wants to change some default behavior at instance level or query level. If we want to enable the trace flag globally then we can enable it for the instance level. We can also use the trace flags at specific query level as […]

By |April 17th, 2017|Categories: Security and Encryption, SQL Server|Tags: , |Comments Off on SQL Server 2016 – USE HINT without having SA permission

SQL Server 2016 – sys.dm_db_incremental_stats_properties for Incremental Stats

Hello Friends,

During various troubleshooting scenarios, we generally check the statistics information on the objects. These statistics information helps us a lot to detect the root cause. There is a DMF that we use to check the statistics information i.e. sys.dm_db_stats_properties. This DMF requires the object id and stats id to return the details.

SQL Server […]

By |April 7th, 2017|Categories: Database Administration, Database Development, Indexes & Statistics|Tags: , |Comments Off on SQL Server 2016 – sys.dm_db_incremental_stats_properties for Incremental Stats

SQL Server 2016 – Two things developers should know

Hello Friends,

There are lots of new features and improvement launched by Microsoft in SQL Server 2016. There are two small but really interesting things for the T-SQL Developers, DBA Developers who are involve in writing T-SQL code.

Situation: Let’s think about a situation where we are creating a new object (for example –  Stored Procedure) […]

By |April 3rd, 2017|Categories: SQL Server, Transact-SQL|Tags: , |Comments Off on SQL Server 2016 – Two things developers should know

SQL Server Trace Flags Information in Execution Plans

Hello Friends,

SQL Server trace flags are important consideration for a query plan compilation and execution. Trace flag can impact the execution of a query and might hit the performance badly if not used appropriately. Sometimes during performance troubleshooting by using execution plan is not easier because we don’t have the information about the trace […]

By |March 14th, 2017|Categories: Performance Tuning|Tags: , |Comments Off on SQL Server Trace Flags Information in Execution Plans

SQL Server – Compare Showplan

Hello Friends,

During performance troubleshooting, It was not easy to compare the execution plan for the queries. We generally save the execution plans and then compare them by opening in different SQL Server Management Studio windows but it was not easy to compare the various things about two operators from the plan. In new SSMS […]

By |March 5th, 2017|Categories: Performance Tuning, SQL Server|Tags: |Comments Off on SQL Server – Compare Showplan

Data Platform Summit 2017 #DPS2017

After successful completion of SQLServerGeeks Annual Summit 2016 last year, I was getting so many questions about the next conference in INDIA. Questions were like “Are you guys going to do this conference next year?”, “May I know the city name for the next annual conference?” and “This time I was unable to attend […]

By |January 31st, 2017|Categories: SQL Server||Comments Off on Data Platform Summit 2017 #DPS2017
Newsletter_Footer