As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. ...
2016-12-28 (first published: 2016-12-10)
1,555 reads
Using SSH keys provide a more secure way of logging into a remote computer when compared to password authentication, and today...
2016-12-10
393 reads
Had a quick interview at Microsoft on Channel 9 last month, and it’s now live. Enjoy.
https://channel9.msdn.com/Blogs/vsppstories/Including-the-database-in-your-DevOps-pipeline/player
Filed under: Blog Tagged: DevOps,...
2016-12-09
716 reads
One of the things that people have asked to be implemented for many years is an easy way to copy...
2016-12-29 (first published: 2016-12-09)
2,483 reads
Why won't my SP work? I did this exact thing. You're never too old to do something like this.
The post...
2016-12-09
566 reads
Ever had users come to you and request another version of a report just to add another field and group...
2016-12-09
616 reads
Good day everyone , In last post
In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...
2016-12-09
513 reads
One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to...
2016-12-09
368 reads
NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and...
2016-12-09
2,333 reads
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...
2016-12-27 (first published: 2016-12-08)
2,009 reads
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
I am excited to host T-SQL Tuesday for the first time. I want to...
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Comments posted to this topic are about the item Measuring Productivity
Comments posted to this topic are about the item Importing Excel files into SQL...
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers