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

851 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,569 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,370 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

17,787 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,095 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,529 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,238 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,199 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,960 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,145 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

The Data API Builder Start and Add Extensions in VS Code

Using OneLake for Excel Files in Microsoft Fabric

Another AI Faux Pax

Forums

AD, powershell and ssis

File date from Extended Event .xel files

SSMS gets very messy

Question of the Day

Sparse Column Defaults