My Interview at SQL Server Geeks 2016
One of the biggest highlights of this year for me was speaking at SQL Server Geeks Annual Summit 2016. In...
2016-12-11
394 reads
Nagaraj Venkatesan
Query Store - Part 4 - Find the plans and queries forced by Query Store
As most of you know, one of the most fundamental uses of query store is to force query plans. Unlike...
2016-12-08
1,082 reads
Data Channel - Interview 01 - Andreas Wolter on Columnstore
Dear all,
Welcome to the first ever interview of DataChannel. I am honored to have Mr.Andreas Wolter, a German MVP, MCM, MCSM...
2016-12-03
727 reads
SQL Server 2016 SP1 – Rocking RELEASE!!!
Last week, I did a presentation titled "SQL Server 2016 SP1 – Rocking RELEASE!!!" to Singapore SQL User Group. The Presentation was...
2016-11-29
851 reads
Data Channel - Launch
Dear All,
I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this...
2016-11-26
414 reads
SQL Server 2016 - SQL Service Doesn't Start after GDR Security update
Recently, after an security fix GDR (https://support.microsoft.com/en-us/kb/3194716) on SQL Server 2016 RTM, SQL Service refused to start. Though, the patch...
2016-11-20
1,183 reads
Residual Predicate and "Number of Rows Read" in Execution Plans
What is Residual Predicate?
Lets say one gets a query to fine tune. While checking the execution plan, if there is...
2016-11-17 (first published: 2016-11-13)
4,627 reads
SQL Server 2016 SP1 Release - Thoughts and Comments!!!
SQL Server 2016 SP1 has released last night and most of the features that were previously part of enterprise edition...
2016-11-17
723 reads
SQL Server 2016 - “Number of Rows Read” on Execution plan
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....
2016-11-10
830 reads
Query Store - Part 3 - How it works?
Query Store collects 2 important kinds of data. They are
1) Compile time statistics - Query Plan, Estimated Costs, Estimated number of...
2016-11-06
807 reads
Blogs
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers