Prakash K

I am a MS SQL DBA, born and brought up in Mumbai, India. Done my engineering in Electronics And Telecommunications and have been working in this industry as a DBA since 2011

Website: http://sqlserversdba.wordpress.com

All authors

SQL Server’s statistics

by Prakash K

SQLSERVERSdba

Again another interesting article from RED GATE …
SQL Server’s statistics provide the query optimizer with the information it needs to...

2015-09-14

860 reads

Live Query Statistics

by Prakash K

SQLSERVERSdba

The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option...

2015-08-27 (first published: 2015-08-19)

2,679 reads

How to find CPU intensive queries ?

by Prakash K

SQLSERVERSdba

HI all
Today received the mail from RED-GATE team on this topic “How to find CPU intensive queries” . It is an...

2015-08-24 (first published: 2015-08-17)

10,407 reads

List Out All the SQL servers In domain

by Prakash K

SQLSERVERSdba

HI ALL
In One Of the Group the question was asked that How to list all the Servers in which SQL...

2015-07-30

18,065 reads

SQL server 2016 CTP 2.2

by Prakash K

SQLSERVERSdba

Microsoft has announced that The SQL Server 2016 Upgrade Advisor Preview and SQL Server 2016 Community Technology Preview (CTP) 2.2 are...

2015-07-23

1,100 reads

COLUMNSTORE INDEX… DEMO

by Prakash K

SQLSERVERSdba

COLUMNSTORE INDEX
How data is stored in traditional way
For physical storage of a table, its rows are divided into a...

2015-07-11

2,539 reads

How to Grant limited permissions to create views in another schema?

by Prakash K

SQLSERVERSdba

How to Grant limited permissions to create views in another schema?
In SQL Server 2005 and 2008R2 you can grant permissions...

2015-07-08 (first published: 2015-07-01)

3,259 reads

SQL SERVER REPORTING SERVICE MIGRATION

by Prakash K

SQLSERVERSdba

Last week as part of job I had to migrate the Databases and Reporting Service of SQL server 2005 To...

2015-06-22 (first published: 2015-06-11)

3,210 reads

SQL Server 2016 features to look for -2

by Prakash K

SQLSERVERSdba

In Previous post we have seen the new features of SQL server 2016 in short and had a brief discussion...

2015-06-11 (first published: 2015-06-08)

4,964 reads

SQL Server 2016 features to look for -1

by Prakash K

SQLSERVERSdba

At this year’s inaugural Ignite Conference in held in Chicago Microsoft announced that the next release of SQL Server, previously...

2015-06-03

1,150 reads

All authors

Prakash K

SQL Server’s statistics

Live Query Statistics

How to find CPU intensive queries ?

List Out All the SQL servers In domain

SQL server 2016 CTP 2.2

COLUMNSTORE INDEX… DEMO

How to Grant limited permissions to create views in another schema?

SQL SERVER REPORTING SERVICE MIGRATION

SQL Server 2016 features to look for -2

SQL Server 2016 features to look for -1

Blogs

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

ADF Pipeline Debugging Fails with BadRequest – The Sequel

Forums

Why End-User Testing Is Even More Important with AI

Dynamic Unpivot

Writing as an Art and a Job

Question of the Day

String Similarity II