Skip to content

Jayanth Kurup SQL Guy

Everything SQL and More

  • Home
  • PowerBI
  • Simply Better Business
  • Business Intelligence
  • Contact Us
  • Clients and Testimonials
Database / MSSQL / TSQL

sys.Dm_db_database_page_allocations()

Posted on: October 10, 2014June 30, 2025

This new DMV is basically a modified version of the DBCC IND command that is used to display the page allocations for a specific database object like a […]

MSBI

Business Intelligence on a Phone Bill

Posted on: October 7, 2014June 21, 2025

I often tell my trainees that BI can be done on pretty much anything. A common example of this is the Phone Bill or the Bank statement. Your […]

Misc / MSBI

Why BI professionals should believe in Aliens

Posted on: September 27, 2014June 21, 2025

I am pretty serious about this one, not because I believe in UFOs or any other extra-terrestrial theory but because as a DBA who implements Business Intelligence solutions […]

Security

Row level permissions in SQL Server

Posted on: September 24, 2014June 30, 2025

We all know that SQL allows object level permissions down till the table, some of even know that it allows permissions at the column level too. But recently […]

Misc

Metrics vs Mass appeal? What companies probably don’t yet understand.

Posted on: September 18, 2014June 21, 2025

I wanted to ask a question today instead of blogging about a topic. To be honest I don’t know the answer to this question and that is why […]

Misc

CHN SQL Azure 17th -19th

Posted on: September 6, 2014June 21, 2025

Just finished an action packed MSBI training in HYD and now on a quick break before heading to Chennai for SQL Azure training. Can’t wait to meet and […]

Misc

When it’s an Emergency, what do you do ?

Posted on: September 1, 2014June 21, 2025

I recently needed to send a courier on a very urgent basis to a friend of mine and was stuck on how to do it. Time was critical […]

Misc

Why I Train

Posted on: August 20, 2014June 21, 2025

It is always rewarding to hear back from those who have attended my trainings. Recently I have been getting a lot of emails and face to face meetings […]

Security

SQL INJECTION using Dynamic SQL and How to fix it

Posted on: August 18, 2014June 30, 2025

At a training recently I was explaining how to do as well as prevent SQL injection and figured I should make a blog about it since very few […]

Misc

Optimistic concurrency

Posted on: August 15, 2014June 30, 2025

Hi Jayanth, QUESTIONHope you are doing good.My question is :Is there a way 2 select from tables with no timeout when u r inserting data into them via […]

Posts pagination

Previous page Page 1 … Page 40 Page 41 Page 42 … Page 51 Next page

Please consider following

Subscribe

Recent Posts

  • IntelliSense not working in latest version of SSMS
  • Converting times across time zones
  • SQL 2025 Optimized locking in SQL2025
  • You Can’t Be King till You’ve Killed Someone 
  • Fuzzy String matches in TSQL
Log in

Categories

  • administration
  • AI-ML
  • AWS
  • Azure
  • Database
  • Errors
  • Misc
  • MSBI
  • MSSQL
  • MYSQL
  • NOSQL
  • PowerBi
  • Security
  • TSQL
  • Uncategorized
  • Wordpress
Log in
Theme Shaft Blog Powered by Kantipur Themes