Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will...

2016-12-21

448 reads

Data gateway confusion

by James Serra

James Serra's Blog

Microsoft has created data gateways as a way that cloud products such as Power BI and Azure Machine Learning can...

2016-12-21

437 reads

Run Book, Run!!!

by Monica Rathbun

SQLEspresso

How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains...

2016-12-21

1,252 reads

sp_helptext vs object_definition()

by Kenneth Fisher

SQLStudies

I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...

2016-12-21

1,963 reads

SQL Agent Permissions

by iainthepitman

Datawarehouse: SQL Server and Stories

Problem

I was contacted by a user asking if it was possible for his team to be able to execute specific...

2016-12-21

2,652 reads

SQL Server and Hyper-threading

by Igor Micev

Si vis pacem, para sql

This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...

2016-12-20

38 reads

SQL Server and Hyper-threading

by Igor Micev

Si vis pacem, para sql

This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation for them. Licensing is given at the end of...

2016-12-20

23 reads