New home for SQL Server Citation

Change is inevitable, it's natural. I would like to quote few lines from Shrimad Bhagavad Gita says     Change is the...

Microsoft SQL Server 2016 Service Pack 1 (SP1)

Microsoft just announced Microsoft SQL Server 2016 Service Pack 1 (SP1)

Microsoft reference: [Click Here]

Ganapathi varma ChekuriLead SQL DBA, MCPLinkedin

Power BI On Premises Integration with Reporting Services Preview

Since the Reporting Services product team announced last year that it was their intention to provide an on premises deployment...

Book Review: Marshmallow Test

Different people approach their career in different ways. My working assumption, all the time, is that I don’t know enough...

Video: Introduction to SQL Server Change Tracking

SQL Server change tracking is a lightweight and synchronous mechanism for detecting inserts, updates, and deletes in tracked tables. For...

Attaching Database Using SMO & Powershell

Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw...

Friday Reading 2016-11-18

Another week almost over so in-between daydreaming about relaxing this weekend I’ll be reading…
https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/

SQL Server 2016 SP1 has been released....

Query tuning 101: How to measure Query Plan I/O cost

If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...

Microsoft Connect(); announcements

Microsoft Connect(); is a developer event from Nov 16-18, where plenty of announcements are made.  Here is a summary of the...

#SQLNewBlogger – T-SQL ESCAPE for Wildcards

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...