The Curious Engineer

All blogs / Databases

Vijay

learn.microsoft.com/en-us/archive/blogs/vijaybk

DatabasesPythonMicrosoft blogsMSDN archive

’10’15’20’25
Posts
15 from 5 Sep 2007 to 15 Aug 2017
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/vijaybk/feed.xml

2017 3

  1. Build PowerBI Real Time Dashboards through Streaming Set with Python
  2. Generate Unique Identifiers (UID) in U-SQL on Azure Data Lake Analytics with Python extension scripts
  3. U-SQL Script with Python extension to detect Invalid input files

2009 7

  1. SQL Server Workers never yield
  2. Deadlock because of Indexed Views
  3. Features supported by Editions of SQL Server 2005/2008
  4. Query fn_dblog() for the list of Operation in active transaction of the current session
  5. DMV to observe wait count and wait time on Indexes
  6. List all the statements in the Plan Cache along with the counts and CPU usage
  7. Query to list all the databases in the order of CPU usage

2008 3

  1. Issue with @@SERVERNAME exceeding 30characters
  2. SQL Server Group accounts
  3. How to view the contents of SQL Server Resource Database

2007 2

  1. Datetime Imported from external system
  2. Logical flow of a query