SQL Server 2014 – A new and exciting journey !!! “Into the cloud”
Today Microsoft announced their next major version of SQLServer, SQL Server 2014 at Tech-Ed NA 2013.
This version of SQLServer is indeed a reflection...
2013-06-03
1,368 reads
anup.varier@gmail.com
- Website: http://sqlsailor.com
Book Review – Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.
Today I will talk about a book titled ” Windows PowerShell 3.0 Step by Step” by Ed Wilson;O’Reilly Media, Inc.
When I...
2013-05-23
924 reads
SQLSaturday Redmond(SQLSat212) – A quick recap !
That was indeed a great day at Redmond. I had a great time talking to some of the best SQLServer minds...
2013-05-20
694 reads
SQLSaturday Redmond(SQLSat212) is almost here…Will you be there?
This is my first SQLSaturday and I’m super excited to attend this event.
SQLSaturday’s are always a great opportunity to learn something exciting,...
2013-05-16
624 reads
The Activity Monitor is unable to execute queries against the server !
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...
2013-05-02
3,395 reads
Linked Server created using a script is missing Product name and Data source fields !
Today I will discuss about an issue which was observed while creating a linked server via script.
The existing linked server was scripted...
2013-04-19
1,306 reads
SQLServer Log Shipping Work File ! What is this all about ?
A short and sweet post for a gorgeous morning -
Have you seen a file with extension .wrk in the log shipping copy folder...
2013-03-29
4,273 reads
CU3 for SQL2012 SP1 – Couple of interesting hotfixes.
Here comes CU 3 (Build 11.0.3349.0.) for SQLServer 2012 SP1. You can download the same from
http://support.microsoft.com/kb/2812412
Similar to CU2 there...
2013-03-21
1,426 reads
Apply CU2 for SQL2012 SP1 – Fix for Windows Installer starting repeatedly and causing CPU spikes !
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...
2013-03-19 (first published: 2013-03-15)
2,437 reads
Adding a Linked Server with ‘Oracle Provider for OLE DB’ as the provider – Proceed with caution !
Adding a linked server is an easy task which can be done at any point of time. I was under...
2013-03-13
2,922 reads
Blogs
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
SQL Server Auto-settings: The Good, the Bad, and the Ugly
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
Bad Request Error when Running PowerShell Command in Azure Devops
I needed to run a PowerShell cmdlet in an Azure Devops pipeline. The cmdlet...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Question of the Day
Has the PK been used --
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers