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
393 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,081 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,626 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
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers